Dataguard failover - what went wrong here?? - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: Dataguard failover - what went wrong here??

  1. #11
    Join Date
    Jan 2001
    Posts
    2,828
    pando
    hahaha :-) sorry i couldnt stop laughing out loud..these kind of questions deserve those answers :-D

    regards
    Hrishy

  2. #12
    Join Date
    Jan 2008
    Posts
    17
    hi hirshy ,
    there i nothing to laugh in it
    i have maximum performance mode so i dont need standby logfile;
    i was confused whether to use ....finish skip standby logfile or just recover ... skip standby logfile before giving switchover command,'
    as some document recomends 1) alter database recover managed standby finish skip standby log file;
    and some recomends 2) alter database recover managed standby database skip standby logfile;

  3. #13
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Okay i have stopped laughing...but my 2 cents you should always have a standby logfile even when you are having maximum performance mode.

    regards
    Hrishy

  4. #14
    Join Date
    Jan 2008
    Posts
    17
    in maximum performance mode its not necessary to have standby redo logs.
    anyways if any has done failover himself plz comment..

  5. #15
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    You need to do this as you dont have standby redologs

    ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH

    and then failover using

    ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY

    http://download-east.oracle.com/docs...nt.htm#1024703

    regards
    Hrishy

  6. #16
    Join Date
    Jan 2008
    Posts
    17
    sorry hirshy
    but as far as i know if u dont have standby redo logs,
    u have to fire "alter database recover managed standby database finish skip standby logfile"

  7. #17
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    I was wrong you indeed need to do

    ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH
    SKIP STANDBY LOGFILE

    regards
    Hrishy

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