| startup problem pla help me out [message #301198] |
Tue, 19 February 2008 09:11  |
mandygrewalindia
Messages: 14
Registered: February 2008
Location: india
|
Junior Member |
|
|
hi frnds
when i start databse it is mounted but not opened..
it shows following errors..
ora-01122 database file 1 failed verification check
ora-01110 datafile 1='<location of dat datafile'>
ora-01207 file is more recent than control file -old contrl file
intially it was nt getting mounted now it gets mounted but not opened.
|
|
|
|
|
|
| startup problem pla help me out [message #301201 is a reply to message #301198] |
Tue, 19 February 2008 09:18  |
mandygrewalindia
Messages: 14
Registered: February 2008
Location: india
|
Junior Member |
|
|
i tried in this manner also
>alter database backup controlfile to trace;
database altered
>shutdown immediate
now what do i check in udump for trace files i read dis solution also:
(" You can find the file in userdump dest. Open the trace file and edit for neccesary changes")
what do i edit..
further steps: cudnt nt do since i dont know what to edit in tace files
3. Startup the database in nomount state.
SQL > startup nomoun
4. Run the controlfile script create in step 2
SQL > @cfile.sql
5. Recover the db
SQL > recover database using backup controlfile
6. Open the database.
SQL > alter database open;
|
|
|
|
| Re: startup problem pla help me out [message #301214 is a reply to message #301198] |
Tue, 19 February 2008 10:36 |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
| Quote: | cudnt nt do since i dont know what to edit in tace files
|
you dont need to edit any thing .
check for the location of the trace file generated with the result of alter database backup controlfile..statement.
copy and paste the create controlfile statement into your sqlplus prompt.
then
alter database mount;
alter database open;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
