You are missing the fact that you only need to activate standby database in case some kind of emergency and most likely some archived redo logs will be lost which in turns will prevent online redo logs from using.
What you have described is very well documented by Oracle procedure called Gracefull Switchover. It designed for Oracle 8.1 (I beleive 9i has it built in Data Guard). In case of gracefull switchover when all archived redo logs are available you do not need to activate standby database . Instead you can transfer online redo logs and regenerate control file and you standby database will become primary. Very simular you primary can become standby. It is done so you do not have to invalidate all you backups for any kind of maitenance or DR exercises.
I guess your steps will work as well.
Hope it helps
Last edited by BV1963; 12-16-2003 at 03:55 PM.
One, who thinks that the other one who thinks that know and does not know, does not know either!
Reply With Quote