Oracle^® Solaris Cluster Geographic Edition Data Replication Guide for Oracle Data Guard

How to Complete Configuring and Integrating Your Standby Oracle Database

1. If you are using Oracle Clusterware, register the new database.

   ---

   Note - Oracle Clusterware is a component of Oracle Grid Infrastructure.

   ---

   Place the standby database under Oracle Clusterware control and configure it to open when Oracle Clusterware starts.

   • For a single-instance database, run the following command:

     oracle (phys-newyork-1)$ srvctl add database -d salesdr \
     -r PHYSICAL_STANDBY -o $ORACLE_HOME -s open;

   • For Oracle RAC, run the following commands:

     oracle (phys-newyork-1)$ srvctl add database -d salesdr \
     -r PHYSICAL_STANDBY -o $ORACLE_HOME -s open;
     oracle (phys-newyork-1)$ srvctl add instance -d salesdr \
     -i salesdr1 -n $phys-newyork-1;
     oracle (phys-newyork-1)$ srvctl add instance -d salesdr \
     -i salesdr2 -n $phys-newyork-2;

2. Enable Oracle Data Guard on both the primary and standby databases.

   Perform the following commands on only one node in each cluster (cluster-paris and cluster-newyork).

   oracle (phys-newyork-1)$ sqlplus '/ as sysdba'
   SQL> alter system set dg_broker_start=true scope=both sid='*';
   SQL> quit
   
   oracle (phys-paris-1)$ sqlplus '/ as sysdba'
   SQL> alter system set dg_broker_start=true scope=both sid='*';
   SQL> quit