Switchover and Switchback
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Switchover and Switchback

  1. #1
    Join Date
    Mar 2003
    Location
    Panama
    Posts
    6

    Wink Switchover and Switchback

    I have reviewed the graceful switchover and switchback document.
    I have a question, I have a standby database in Oracle8i Release 8.1.7.3.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?

    Please response!

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    AFAIK gracefull switchover is not possible before Oracle9i DataGuard. So for 8.1.7.3 the answer is (at least to my knowlege)): No, switchover/switchback is not possible - the only option is to perform failover.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Mar 2003
    Location
    Panama
    Posts
    6
    jmodic:

    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.

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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...
    Reddy,Sam

  5. #5
    Join Date
    Nov 2001
    Posts
    335
    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 8.1.7.3 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!

  6. #6
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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.
    Reddy,Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width