| Restore dabase + copied archivelogs [message #535474] |
Wed, 14 December 2011 04:34  |
 |
Flyby
Messages: 188
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)
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
