This discussion is archived
6 Replies Latest reply: Mar 26, 2013 6:48 AM by Repos RSS

failover

Repos Newbie
Currently Being Moderated
Hello Forum Member
Is it is possible Oracle dataguard can failover (Unpalnned) without resetlogs option.

Regards
  • 1. Re: failover
    Acooper Explorer
    Currently Being Moderated
    Almost always.
  • 2. Re: failover
    Repos Newbie
    Currently Being Moderated
    That means always have to open with resetlogs option , if that is the case
    how to avoid that

    Reagrds
  • 3. Re: failover
    mseberg Guru
    Currently Being Moderated
    I hesitate to answer because you do not use the forum well.
    Total Questions:      64 (57 unresolved) 
    You don't close old questions or mark anything helpful. Please consider marking some old questions answered.

    Here's a link to my failover test which answers your question :

    http://www.visi.com/~mseberg/data_guard/Data_Guard_Failover_Test_using_SQL.pdf




    Best Regards

    mseberg
  • 4. Re: failover
    Repos Newbie
    Currently Being Moderated
    HI mseberg
    Thanks for the information , but I am talking about UnPlanned failover
    Regards
  • 5. Re: failover
    Acooper Explorer
    Currently Being Moderated
    What is a "Planned failover" ? This would be a switchover in most shops.

    Maybe you should read about the differences.
  • 6. Re: failover
    Repos Newbie
    Currently Being Moderated
    HI
    I am not asking about switcover (Planned) , I am asking about unplanned failover.
    In the second method , resetlogs option is used automatically if dataguard is monitored
    by Broker.
    Is there is a way to avid this resetlogs option.
    For example:
    Unpalnned failover using shutdwon abort on primary database.

    Thanks
    repos

Legend

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