-
Unable to open database - needs media recovery
Last week we had disk failure. Unfortunetly I have lost arch logs and trc files. When we were trying to start the database, we starting getting the following error:
ORA-01113 file 8 needs media recovery.
After reading arround we tried the followings:
Startup nomount;
recover database until cancel;
[cancel]
alter database open resetlogs;
When we tried again, we started getting new error:
ORA-01194: file 1 needs more recovery to be consistent;
It is complaining onSYSTEM01.DBF file now. Please guide me how can open the database without latest logs and Tracefiles;
Thanks in Advance.
V.
-
how about just RECOVER DATABASE?
Jeff Hunter
-
Originally Posted by marist89
how about just RECOVER DATABASE?
I have tried that same problem. Thanks
-
Basically that error is telling you that all your files are not at a consistent point. Your system.dbf file needs to have more recovery applied (from redo or archived redo) in order to be consistent enough to open.
What do you have for a backup?
Jeff Hunter
-
Unfortuntely, we don't backup this server. It is one of our test server.
-
one hidden parameter can help this, remember do a backup once open. either full export/import.
_ALLOW_RESETLOGS_CORRUPTION=TRUE
DO IT ONLY YOU HAVE NO OTHER WAY TO RECOVER YOUR DATA.
Pls be sure that it's not supported by Oracle and it may bring ur database to dangerous situation.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
-
I have move a step further after finding some files from last months folder command. It don't have all the files but SYSTEM,CONTROL and REDOs.
Now I am getting this error:
ORA-0283: recovery session cancelled due to errors
ORA-01112: database file 3 failed verification check
ORA-01110: data file 3: g:\oradata\DWTEST\RBS01.dbf'
ORA-01207: file is more recent then controlfile - old control file.
Any ideas to move forward from here.
Do you think, if try to take this rollback segment offline. will that going to work. Please advice.
-
Originally Posted by avion1
Do you think, if try to take this rollback segment offline. will that going to work. Please advice.
no.
If it's a test database then just clone your production db, re-apply any changes and you're done.
Jeff Hunter
-
Thanks for the advice.
But, I am trying to open database withot restoring from live. We are not bothered about loosing data. Cheers.
Last edited by avion1; 08-02-2005 at 11:48 AM.
-
Originally Posted by avion1
Thanks for the advice.
We are not bothered about loosing data. Cheers.
Then why not just create another database?
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|