ORA10G DATAGUARD--Managing a Physical Standby Database

1>. Starting Up a Physical Standby Database
       ¡½ The STARTUP statement starts the database, mounts the database as a physical standby database, and opens the database for read-only access.
       ¡½ The STARTUP MOUNT statement starts and mounts the database as a physical standby database, but does not open the database.

    1. Start and mount the physical standby database:
          SQL> STARTUP MOUNT;
          Opening a Standby Database for Read-Only or Read/Write Access
 
    2. Start Redo Apply or real-time apply:
          To start Redo Apply, issue the following statement:
          SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE  DISCONNECT FROM SESSION;

2>. Shutting Down a Physical Standby Database
database and perform. a log switch before shutting down the standby database.To stop Redo Apply before shutting down the database, use the following steps:

         1. 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;

         2. If Redo Apply is running, cancel it as shown in the following example:
            SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

         3. Shut down the standby database.
            SQL> SHUTDOWN IMMEDIATE;

3>.Opening a Physical Standby Database for Read-Only Access
         1.To open a standby database for read-only access when it is currently shut
down:
             SQL> STARTUP;
         
         2.To open a standby database for read-only access when it is currently
performing Redo Apply:
             a. Cancel Redo Apply:
                 SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
             b. Open the database for read-only access:
                 SQL> ALTER DATABASE OPEN;

4>.To change the standby database from being open for read-only access to
performing Redo Apply:
           a. Terminate all active user sessions on the standby database.

           b. Restart Redo Apply. To start Redo Apply, issue the following statement:
                   SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE
                         2> DISCONNECT FROM SESSION;
               To enable real-time apply, include the USING CURRENT LOGFILE clause:
                   SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE
                         2> USING CURRENT LOGFILE;

V$DATAGUARD_STATUS
V$ARCHIVED_LOG
V$ARCHIVE_GAP
V$MANAGED_STANDBY