This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Dec 12, 2012 7:44 PM by 819737 Go to original post RSS
  • 15. Re: Simulate Failover between Primary RAC to single instance
    819737 Newbie
    Currently Being Moderated
    Hi Guru,

    I have another quention related reinstate fail primary using backup from disk. It is possible using daily backup before fail over to reinstate the fail primary. I have some refer document but not sure whether is working as per below. I was doubt if do not have backup standby controlfile how it able to mount and restore/recover. Based of you experience, may be you can clear my doubt

    on the new primary run as

    sql > select to_char(standby_become_primary_scn) from v$database


    on fail primary run as

    rman > run
    {
    set until scn <standby_become_primary_scan +1 >;
    restore database;
    recover database;
    }


    SQL > alter database convert to physical standby;


    SQL > shutdown immediate;

    SQL > startup mount;

    SQL > alter database open read only;


    Regard
    William
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points