This discussion is archived
3 Replies Latest reply: Aug 24, 2012 7:32 AM by SPA2 RSS

MAA stop apply mode for instance

SPA2 Newbie
Currently Being Moderated
Hi all,
we need to restart one of the compute nodes.
On these nodes runs our physical Standby databases.

So we have two instances but only one is the applying instance.

What would you prefer?

Before reboot I would like to stop the APPLY Mode inside the dgmgrl by using
edit database 'xyz' set state = 'APPLY-OFF'.

Is it possible to stop the Apply mode for one instance?
I take a look to the edit daatabase command inside the dgmgrl but there is no syntax for stopping the Apply for one instance

Or did you have another tested solution?

kind regards
SPA2
  • 1. Re: MAA stop apply mode for instance
    damorgan Oracle ACE Director
    Currently Being Moderated
    Is this an Exadata? If so HP or Sun? Which O/S version?

    Again if Exadata did you blow away RAC and decide to use it as a stand-alone single instance server?

    A whole lot of explaining is required before I expect anyone is going to try to give specific advice: I know for sure I won't because what I just read doesn't compute.
  • 2. Re: MAA stop apply mode for instance
    SPA2 Newbie
    Currently Being Moderated
    Hi,
    yes, it is an Exadata. X2 Quarter Rack with 11.2.0.2 CRS and DB. (Primary and Standby)
    I think a little bit abot the whole task.
    For me it makes sense to do in the following way.

    While we have 4 Data guards an all applying instance are on instance 2 which means on the second db-node
    I would like to do the following.

    Double check the Apply Mode with dgmgrl

    Login as Grid Infrastructure user and stop the whole cluster node
    crsctl stop cluster -n hostdb02

    Then we can configure on the OS level and afterwards we do the reboot.

    Now all resources will be started automatically.

    Check as last task if the data guards works fine.

    regards
    SPA2
  • 3. Re: MAA stop apply mode for instance
    SPA2 Newbie
    Currently Being Moderated
    Hi all,
    I did the change today and it works as described before.

    Our MAA Exadata now again in SYNC. :-)

    regards
    SPA2

Legend

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