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
Thursday, September 21, 2006
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment