O'Reilly logo

Oracle Data Guard 11gR2 Administration Beginner's Guide by Nassyam Basha, Emre Baransel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required