Switchover and Switchback
I have reviewed the graceful switchover and switchback document.
I have a question, I have a standby database in Oracle8i Release 220.127.116.11.0.
on AIX Version 4. Is graceful switchover possible?
When I do this 'alter database create controlfile as ' '
I'll be creating the script 'create controlfile script',
How do I do this 'reverse production to standby sites roles'?
Where can i get the script to the switchover and switchback?
AFAIK gracefull switchover is not possible before Oracle9i DataGuard. So for 18.104.22.168 the answer is (at least to my knowlege)): No, switchover/switchback is not possible - the only option is to perform failover.
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Let me tell you that I did it, I made the switchover and it was really great an simple with the document "Graceful switchover and switchback.
If you have any questions let me know remember a I have Oracle 8i.
Its possible with 8i, one have to be little careful in doing that as its not documented procedure. I mean one fail to do so its at their risk...
It is very well documented by Oracle. There is white paper with step by step procedure for 8I. You do have to be carefull as you follow the steps . I have done it on AIX 4.3 and Oracle 22.214.171.124 multiple times and did not have any problem at all.
Dataguard basically the same thing for you except it is all "kernalized" versus manual procedure.
One, who thinks that the other one who thinks that know and does not know, does not know either!
AFAIK, Its not documented by Oracle and there is a white paper on this topic by Private Oracle Expert which Oracle metalink points to.
Its not a complex task, but not advisable for novice DBAs incase of productyion databases. Thats what I mean saying not documented procedure.
Click Here to Expand Forum to Full Width