Thursday, September 21, 2006

the instance needs recovery and all controlfiles are damaged

Scenario:
1.your database needs recovery(i.e. instance crash, power off, media problem)
2.all of the controlfiles are damaged
3.you have a available backup, all the archivelogs.

Solution:
1.restore all the files needs restoration
2.recover database using backup controlfile until cancel
3.print "auto" when prompted
4.recover database using backup controlfile until cancel

Go to step 5 and step 6 if online redo logs are damaged, go to step 7 and step 8 if not

5.print "cancel"
6.alter database open resetlogs

7.print the name of one online log(you may have to try several times to find which one is correct)
8.alter database open

No comments: