Oracle Data Guard 11gR2 Administration Beginner's Guide

Time for action – verifying the standby database configuration

Run the following actions to verify the standby database configuration and redo transport services:

1. Connect the standby database using SQL*Plus and check for the database role and status to ensure the database role is the physical standby.

   SQL> select db_unique_name,database_role,open_mode from v$database;
   DB_UNIQUE_NAME  DATABASE_ROLE    OPEN_MODE
   --------------- ---------------- --------------------
   india_un        PHYSICAL STANDBY MOUNTED
   

2. Check the standby database, SPFILE.

   SQL> show parameter spfile
   NAME   TYPE    VALUE
   ------ ------- --------------------------------------------------
   spfile string  /u01/app/oracle/product/11.2.0/db_1/dbs/spfileINDIA.ora
   

   Tip

   If you have started the standby instance ...