SETTING UP ACTIVE DATA GUARD ON RAC
--------------------------------------------
Created: Shaji Alex
Date: 12/1/12
Assumptions:
Two node RAC with oracle 11gR2
servers:
primary nodes: prim-serv1, prim-serv2
stadby nodes : stdby-serv1, stdby-serv2
scans: prim-scan-name
: stdby-scan-name
VIPs : prim-serv1-vip, prim-serv2-vip
: stdby-serv1-vip, stdby-serv2-vip
Primary DB: PRIM (PRIM1, PRIM2)
Standby DB: STDBY (STDBY1, STDBY2)
----------------------------------------------
--login to each nodes with your gid
--then su - syncrs
--edit listener.ora and add to SID_LIST
<prim-serv1>
cd /u01/app/grid/11.2.0.3/network/admin
cp listener.ora listener.ora.<yyyymmdd>
vi listener.ora
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=PRIM_DGMGRL)
(SID_NAME=prim1)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
)
)
lsnrctl reload
lsnrctl status
<prim-serv2>
cd /u01/app/grid/11.2.0.3/network/admin
cp listener.ora listener.ora.<yyyymmdd>
vi listener.ora
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=PRIM_DGMGRL)
(SID_NAME=PRIM2)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
)
)
lsnrctl reload
lsnrctl status