Recover using backup controlfile
Disk which contains all of my controlfile got corrupted.
1) Shutdown the database
2) Copied the yesterday controlfile binary backup to init.ora control fie location
3) startup mount
4) recover datbase using backup controlfile(Selected auto option. It applied all the archive log files)
5) alter database open reselogs;
Now getting the following error
alter database open resetlogs
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
Please guide me how to reover my database in this situation.
Again I issued the command
recover database using backup controlfile;
it was asking for non existent archive log file
I have pasted the one logile from each group and media recovery got completed.
Now the datbase is up
Since your DB is now up.
Issue the following: alter database backup controlfile to trace;
Next look at the udump trace file that is created....
You didn't have to do "alter database open resetlogs"....
Click Here to Expand Forum to Full Width