-
Recover using backup controlfile
Hi all,
Disk which contains all of my controlfile got corrupted.
Steps Followed
---------------
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.
Thanks,
Seelan
-
Hi,
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
Seelan
-
-
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"....
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
|