746 views
in Dataguard by
closed by
closed with the note: closed

1 Answer

by
selected by
 
Best answer
To stop Redo Apply before shutting down the database, use the following steps:

    Issue the following query to find out if the standby database is performing Redo Apply or real-time apply.
    If the MRP0 or MRP process exists, then the standby database is applying redo.

    SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;

    If Redo Apply is running, cancel it as shown in the following example:

    SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

    Shut down the standby database.

    SQL> SHUTDOWN IMMEDIATE;

Categories

...