current setup
[oracle@ol6-112-dr-rac1 admin]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/oracle@TROY_DR
Connected.
DGMGRL> show configuration
Configuration - broker_config
Protection Mode: MaxPerformance
Databases:
TROY_DR - Primary database
TROY - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESSfrom primary
TROY1@ol6-112-dr-rac1 > set lines 300
TROY1@ol6-112-dr-rac1 > col DESTINATION for a30
TROY1@ol6-112-dr-rac1 > select dest_id,destination,status from v$archive_dest where target='STANDBY';
DEST_ID DESTINATION STATUS
---------- ------------------------------ ---------
2 troy VALIDremove configuration (Check the archive log destination in primary database. After removing the configuration it will clear automatically) . I you do not want to add dgmgrl back you can skip this step and follow remaining steps.
[oracle@ol6-112-dr-rac1 admin]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/oracle@TROY_DR
Connected.
DGMGRL> remove configuration;
Removed configuration
DGMGRL> show configuration
ORA-16532: Data Guard broker configuration does not exist
Configuration details cannot be determined by DGMGRL
from primary db
TROY1@ol6-112-dr-rac1 > show parameter dg_broker
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1 string +DATA/troy_dr/dataguardconfig/
dgb_config01.ora
dg_broker_config_file2 string +DATA/troy_dr/dataguardconfig/
dgb_config02.ora
dg_broker_start boolean TRUE
TROY1@ol6-112-dr-rac1 > alter system set dg_broker_start=false scope=both sid='*';
System altered.
TROY1@ol6-112-dr-rac1 > show parameter dg_broker
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1 string +DATA/troy_dr/dataguardconfig/
dgb_config01.ora
dg_broker_config_file2 string +DATA/troy_dr/dataguardconfig/
dgb_config02.ora
dg_broker_start boolean FALSE
TROY1@ol6-112-dr-rac1 > select dest_id,destination,status from v$archive_dest where target='STANDBY';
no rows selected
Check the archive log destination in primary database. After removing the configuration it will clear automatically.
TROY1@ol6-112-dr-rac1 > sho parameter dest_2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_online_log_dest_2 string
log_archive_dest_2 string
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_29 string
remove files from asm
ASMCMD> cd +DATA/troy_dr/dataguardconfig/
ASMCMD> ls
TROY_DR.326.1041699601
TROY_DR.329.1041699695
dgb_config01.ora
dgb_config02.ora
ASMCMD> rm -rf *
on DR side
TROY1@ol6-112-rac1 > show parameter dg_broker
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1 string +DATA/troy/dataguardconfig/dgb
rk_config01.ora
dg_broker_config_file2 string +DATA/troy/dataguardconfig/dgb
rk_config02.ora
dg_broker_start boolean TRUE
TROY1@ol6-112-rac1 > alter system set dg_broker_start=false scope=both sid='*';
System altered.
TROY1@ol6-112-rac1 > sho parameter dest_2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_online_log_dest_2 string
log_archive_dest_2 string service="troy_dr", LGWR ASYNC
NOAFFIRM delay=0 optional comp
ression=disable max_failure=0
max_connections=1 reopen=300 d
b_unique_name="TROY_DR" net_ti
meout=30, valid_for=(all_logfi
les,primary_role)
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
TROY1@ol6-112-rac1 > show parameter dg_broker
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1 string +DATA/troy/dataguardconfig/dgb
rk_config01.ora
dg_broker_config_file2 string +DATA/troy/dataguardconfig/dgb
rk_config02.ora
dg_broker_start boolean FALSE
remove from asm
ASMCMD> cd +DATA/troy/dataguardconfig/
ASMCMD> ls
TROY.386.1041699463
TROY.387.1041699481
dgbrk_config01.ora
dgbrk_config02.ora
ASMCMD> rm -rf *adding back the configuration
primary side
TROY1@ol6-112-dr-rac1 > ALTER SYSTEM SET DG_BROKER_CONFIG_FILE1='+DATA/TROY_DR/DATAGUARDCONFIG/dgb_config01.ora' SCOPE=BOTH sid='*';
System altered.
TROY1@ol6-112-dr-rac1 > ALTER SYSTEM SET DG_BROKER_CONFIG_FILE2='+DATA/TROY_DR/DATAGUARDCONFIG/dgb_config02.ora' SCOPE=BOTH sid='*';
System altered.
TROY1@ol6-112-dr-rac1 > ALTER SYSTEM SET dg_broker_start=true scope=both sid='*';
System altered.
standby side
TROY1@ol6-112-rac1 > ALTER SYSTEM SET DG_BROKER_CONFIG_FILE1='+DATA/TROY/DATAGUARDCONFIG/dgbrk_config01.ora' SCOPE=BOTH sid='*';
System altered.
TROY1@ol6-112-rac1 > ALTER SYSTEM SET DG_BROKER_CONFIG_FILE2='+DATA/TROY/DATAGUARDCONFIG/dgbrk_config02.ora' SCOPE=BOTH sid='*';
System altered.
TROY1@ol6-112-rac1 > ALTER SYSTEM SET dg_broker_start=true scope=both sid='*';
System altered.add and enable configuration
[oracle@ol6-112-dr-rac1 admin]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/oracle@TROY_DR
Connected.
DGMGRL> show configuration;
ORA-16532: Data Guard broker configuration does not exist
Configuration details cannot be determined by DGMGRL
DGMGRL> create configuration 'broker_config' as primary database is 'TROY_DR' connect identifier is TROY_DR;
Configuration "broker_config" created with primary database "TROY_DR"
DGMGRL> show configuration;
Configuration - broker_config
Protection Mode: MaxPerformance
Databases:
TROY_DR - Primary database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
DGMGRL> ADD DATABASE 'TROY' AS CONNECT IDENTIFIER IS TROY;
Database "TROY" added
DGMGRL> show configuration;
Configuration - broker_config
Protection Mode: MaxPerformance
Databases:
TROY_DR - Primary database
TROY - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
DGMGRL> enable configuration;
Enabled.
DGMGRL> show configuration;
Configuration - broker_config
Protection Mode: MaxPerformance
Databases:
TROY_DR - Primary database
TROY - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DBATracker 