This content has been marked as final. Show 4 replies
What you have done does not, to the best of my knowledge, correspond to any documented process from Oracle for creating a valid Data Guard Physical standby.
My advice: Burn it to the ground ... open the docs ... read them and follow them. Doing so not only creates the end result but gives you a fully supported environment.
Is your SAN mirroring active-active OR active-passive. This happens in active passive mirroring where it is possible when your controlfile is mirrored but part of the online redolog is not. When you try to open the database controlfile will have little more information and will ask about the required redo log. This does not happen in active-active mirroring.
How is the SAN mirroring implemented ?
A mirror-split can be done only with the database in BEGIN BACKUP mode. You must also ensure that the corresponding archivelog(s) is/are shipped to the DR storage.
Since the database is in BACKUP mode, when you attempt to issue a normal STARTUP, Oracle warns that RECOVERy is needed.
You must follow the SAN vendor's precise documentation for mirroring Oracle databases.
Hemant K Chitale
PS : Also see Oracle Support article "Supported Backup, Restore and Recovery Operations using Third Party Snapshot Technologies [ID 604683.1]"
Edited by: Hemant K Chitale on Jan 24, 2013 10:00 AM
Added PS on the Oracle Support article
Its expected behavior , as during time span of SAN sync redo log files were overwritten & generated archive logs.
Instance Recovery performs redo log scan only & whenever sequences required for recovery doesn't match / available in redo it prompts to supply archive-logs containing old sequence threads.
If your sync would have completed quickly before any of the redo getting overwritten , Recovery would have been manged by oracle itself but of-course it may not be possible based on disk size/bandwidth of sync