How to Complete Configuring and Integrating Your Standby Database

1. Register the new database and instances with Oracle Clusterware.

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

   oracle (phys-newyork-1)$ srvctl add database -d salesdr \ -r PHYSICAL_STANDBY -o $ORACLE_HOME -s mount; 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. Configure the Sun Cluster Oracle RAC manageability resources.

   Integrate the standby database with Sun Cluster. You can use either the Data Service configuration wizard that is available through the clsetup utility or the browser-based Sun Cluster Manager. By integrating the standby database, you allow the standby to be managed as the primary database is, should a failover or takeover be necessary.

   ---

   Note –

   The resource and resource group that you create are used by the Sun Cluster Geographic Edition Oracle Data Guard integration.

   ---

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

   You need to perform the following steps 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