Home » RDBMS Server » Backup & Recovery » Restore dabase + copied archivelogs (Oracle,10.2.0.4, Windows)
Restore dabase + copied archivelogs [message #535474] Wed, 14 December 2011 04:34 Go to next message
Flyby
Messages: 187
Registered: March 2011
Location: Belgium
Senior Member
Question: does oracle recover past the scn mentioned in the controlfile or do you need recover using backup controlfile for it? No specific scn,time specified.

Scenario: Restore database on new server + copy archivelogs from original to minimize dataloss.
Backup : 5 AM
Archivelogs: 7 AM

New server:
Configure dummy instance
Restore spfile from tape
Restore controlfile from tape: SCN 5AM
Restore database (no scn specified) from tape: : SCN 5AM
Copy archivelogs from old server to archivelog new location: SCN 7AM.
Recover database
open database -> SCN 5AM or 7AM?

Does it recover till SCN 5AM (controlfile) or SCN 7AM (latest scn in copied archivelog)
Re: Restore dabase + copied archivelogs [message #535476 is a reply to message #535474] Wed, 14 December 2011 04:36 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Question: does oracle recover past the scn mentioned in the controlfile or do you need recover using backup controlfile for it?

The latter.

Regards
Michel
Re: Restore dabase + copied archivelogs [message #535481 is a reply to message #535476] Wed, 14 December 2011 04:47 Go to previous message
Flyby
Messages: 187
Registered: March 2011
Location: Belgium
Senior Member
Thanks for your quick answer.
Previous Topic: RMAN control File auto backup error
Next Topic: how to know the latest backup sets
Goto Forum:
  


Current Time: Sun Oct 21 20:02:12 CDT 2018