This discussion is archived
2 Replies Latest reply: Dec 3, 2013 5:40 AM by mseberg RSS

Database shutdowns in Maximum Protection mode

007 Newbie
Currently Being Moderated

Hi,

 

I am using oracle dataguard 11g(11.2.0.1.0) on OEL5. My dataguard is working fine in MAXIMUM PERFORMANCE mode. But when i try to put my database mode in MAXIMUM PROTECTION MODE my database gets shutdown.What could be the possible reason for this????

 

Regards,

007

  • 1. Re: Database shutdowns in Maximum Protection mode
    Abufazal Journeyer
    Currently Being Moderated

    Please refer

    Configuring Oracle Data Guard

     

    Verify the staus of the corresponding standby database.

    if it is not acknowleding redo from primary, there is a chance that your primary database will stall or go down to ensure there is no data loss.

  • 2. Re: Database shutdowns in Maximum Protection mode
    mseberg Guru
    Currently Being Moderated

    Hello;

     

    Quote  "To ensure that data loss cannot occur, the primary database will shut down, rather than continue processing transactions, if it cannot write its redo stream to at least one synchronized standby database"

     

    Section - 1.4 Data Guard Protection Modes - Data Guard Concepts and Administration 11g Release 2 (11.2) E10700-02

     

    From section 5.1 of the same document ( Maximum Protection )

     

     

    "Oracle recommends that a minimum of two standby databases be used to

    protect a primary database that runs in maximum protection mode to prevent a single

    standby database failure from causing the primary database to shut down."

     

     

    Best Regards

     

    mseberg

Legend

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