|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|
Applies to:Oracle Server - Enterprise Edition - Version: 22.214.171.124 to 126.96.36.199 - Release: 9.2 to 11.2
Information in this document applies to any platform.
***Checked for relevance on 22-Mar-2011*** Step 1. Stop broker in both of primary and standby databases (in all instances in case of RAC):
Step 2. Drop old broker configuration files from both primary and standby:
Check the location of files using : "show parameter dg_broker_config_file"
By default the broker configuration files will be in "$ORACLE_HOME/dbs" in Unix and "$ORACLE_HOME/database" in Windows.
NAME TYPE VALUE
---------------------- ------ ----------------------------------------
dg_broker_config_file1 string \oracle\product\10.2.0\dbs\dr1PROD10G.dat
dg_broker_config_file2 string \oracle\product\10.2.0\dbs\dr2PROD10G.dat
Drop the files using ASMCMD if files are on ASM:
ASMCMD> rm dr1PROD10G.dat
ASMCMD> rm dr2PROD10G.dat
Drop the files using :
$ rm dr1PROD10G.dat
$ rm dr2PROD10G.dat
D:\oracle\product\10.2.0\db_2\database> del dr1PROD10G.dat
D:\oracle\product\10.2.0\db_2\database> del dr2PROD10G.dat
Step 3. Start broker in both of primary and standby (in all instances in case of RAC):
Step 4. Connect to DGMGRL on primary: (from instance one in case of RAC)
DGMGRL for Linux: Version 10.2.0.3.0 - Production
Copyright (c) 2000, 2005, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> CONNECT sys/<password>;
Step 5. Create configuration on primary:
Configuration "PRODCONF" created with primary database "PROD10G"
Step 6. Add standby in the configuration:
Database "STDBY10G" added
Step 7. Enable Configuration:
Use the SHOW command to verify that the configuration and its databases were successfully enabled and brought online:
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
PROD10G - Primary database
STDBY10G - Physical standby database
Current status for "PRODCONF"
NOTE:454418.1 - Unable To Recreate Data Guard Fast Start Failover Configuration With DGMGRL