Saturday, July 18, 2009

Create a Dataguard Broker configuration

SID_LIST_LISTENER_PD01CFD_PROD-ORANODE-10 =
(SID_LIST =
(SID_DESC =
(SID_NAME = pd01cfd1)
(GLOBAL_DBNAME=pd01cfd_DGMGRL)
(ORACLE_HOME = /opt/oracle/product/10.2.0/db_2)
)
)


SYS AS SYSDBA@pd01cfd1> show parameter dg

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1 string +ASM_ORADATA11/pd01cfd/dr1pd01
cfd.dat
dg_broker_config_file2 string +ASM_ORADATA12/pd01cfd/dr2pd01
cfd.dat
dg_broker_start boolean TRUE


create configuration 'PROD_BKO' as PRIMARY DATABASE IS 'pd01bko' CONNECT IDENTIFIER IS pd01bko;
ADD DATABASE 'pl01bko' AS CONNECT IDENTIFIER IS pl01bko MAINTAINED AS PHYSICAL;
edit database pd01bko set property logxptmode='ASYNC';
edit database pl01bko set property logxptmode='ASYNC';
edit database pd01bko set property PreferredApplyInstance='pd01bko1';
edit database pl01bko set property PreferredApplyInstance='pl01bko1';
edit database pd01bko set property MaxFailure=15;
edit database pl01bko set property MaxFailure=15;
edit database pd01bko set property ReopenSecs=60;
edit database pl01bko set property ReopenSecs=60;
edit database pd01bko set property LogArchiveMaxProcesses=10;
edit database pl01bko set property LogArchiveMaxProcesses=10;
enable configuration;