Administering Standby Databases

Following are the steps required performing standard maintenance actions on the databases that are part of the Data Guard configuration, including startup and shutdown operations.

Startup and Shutdown of Physical Standby Databases

When you start up a physical standby database, you should start the redo apply process. First, mount the database then start redo apply process:

SQL> STARTUP MOUNT;

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

To shut down the standby database, you should first stop the Log Apply Services

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> SHUTDOWN IMMEDIATE;

Opening Physical Standby Databases in Read-Only Mode

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> ALTER DATABASE OPEN;

Startup and Shutdown of Logical Standby Databases

Stop logical standby database and shutdown;

SQL> ALTER DATABASE STOP LOGICAL STANDBY APPLY;
SQL> SHUTDOWN IMMEDIATE;

Start logical standby database and start redo apply service

SQL> STARTUP;
SQL> ALTER DATABASE START LOGICAL STANDBY IMMEDIATE;