Enterprise Manager Grid Control GUI or Command line interface can be used to configure Guard Broker. The following demonstration uses the command line version.
ASSUMPTION
There exists a function physical standby database ( i.e The redo log shipping/transport is happening and the transported logs are being applied to make the standby database in sync with the production.)
Primary Database: PROD
Standby Database: PRODSTDBY
STEP 1. ON BOTH THE PRIMARY AND STANDBY DATABASES START THE DATAGUARD BROKER PROCESS
SQL> ALTER SYSTEM SET DG_BROKER_START=TRUE SCOPE=BOTH;
System altered.
STEP 2. EDIT THE listener.ora ON BOTH THE PRIMARY AND STANDBY NODES TO CONTAIN THE STATIC ENTRY FOR DBMGRL
Ensure that the GLOBAL_DBNAME is set to db_unique_name_DGMGRL.db_domain
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = PROD_dgmgrl)
(ORACLE_HOME = /u01/oracle/product/11.2.0.3/db_1)
(SID_NAME = PROD)
)
)
STEP 3. CREATE THE CONFIGURATION
PROD:/u01/oracle$ dgmgrl
DGMGRL for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - 64bit Production
Copyright (c) 2000, 2005, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/xxxxxxx
Connected.
DGMGRL> CREATE CONFIGURATION 'ORIGINDR'
> AS
> PRIMARY DATABASE IS 'PROD'
> CONNECT IDENTIFIER IS 'PRODSTDBY'
> ;
Configuration "ORIGINDR" created with primary database "PROD"
STEP 4. ADD THE STANDBY DATABASE TO THE CONFIGURATION
DGMGRL> ADD DATABASE
> 'PRODSTDBY'
> AS
> CONNECT IDENTIFIER IS 'PRODSTDBY'
> ;
Database "PRODSTDBY" added
DGMGRL> SHOW CONFIGURATION
Configuration
Name: ORIGINDR
Enabled: NO
Protection Mode: MaxAvailability
Databases:
PROD - Primary database
PRODSTDBY - Physical standby database
Fast-Start Failover: DISABLED
Current status for "ORIGINDR":
DISABLED
STEP 5. ENABLE THE CONFIGURATION
DGMGRL> ENABLE CONFIGURATION
Enabled.
DGMGRL> SHOW CONFIGURATION
Configuration
Name: ORIGINDR
Enabled: YES
Protection Mode: MaxAvailability
Databases:
PROD - Primary database
PRODSTDBY - Physical standby database
Fast-Start Failover: DISABLED
Current status for "ORIGINDR":
SUCCESS
ASSUMPTION
There exists a function physical standby database ( i.e The redo log shipping/transport is happening and the transported logs are being applied to make the standby database in sync with the production.)
Primary Database: PROD
Standby Database: PRODSTDBY
STEP 1. ON BOTH THE PRIMARY AND STANDBY DATABASES START THE DATAGUARD BROKER PROCESS
SQL> ALTER SYSTEM SET DG_BROKER_START=TRUE SCOPE=BOTH;
System altered.
STEP 2. EDIT THE listener.ora ON BOTH THE PRIMARY AND STANDBY NODES TO CONTAIN THE STATIC ENTRY FOR DBMGRL
Ensure that the GLOBAL_DBNAME is set to db_unique_name_DGMGRL.db_domain
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = PROD_dgmgrl)
(ORACLE_HOME = /u01/oracle/product/11.2.0.3/db_1)
(SID_NAME = PROD)
)
)
STEP 3. CREATE THE CONFIGURATION
PROD:/u01/oracle$ dgmgrl
DGMGRL for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - 64bit Production
Copyright (c) 2000, 2005, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/xxxxxxx
Connected.
DGMGRL> CREATE CONFIGURATION 'ORIGINDR'
> AS
> PRIMARY DATABASE IS 'PROD'
> CONNECT IDENTIFIER IS 'PRODSTDBY'
> ;
Configuration "ORIGINDR" created with primary database "PROD"
STEP 4. ADD THE STANDBY DATABASE TO THE CONFIGURATION
DGMGRL> ADD DATABASE
> 'PRODSTDBY'
> AS
> CONNECT IDENTIFIER IS 'PRODSTDBY'
> ;
Database "PRODSTDBY" added
DGMGRL> SHOW CONFIGURATION
Configuration
Name: ORIGINDR
Enabled: NO
Protection Mode: MaxAvailability
Databases:
PROD - Primary database
PRODSTDBY - Physical standby database
Fast-Start Failover: DISABLED
Current status for "ORIGINDR":
DISABLED
STEP 5. ENABLE THE CONFIGURATION
DGMGRL> ENABLE CONFIGURATION
Enabled.
DGMGRL> SHOW CONFIGURATION
Configuration
Name: ORIGINDR
Enabled: YES
Protection Mode: MaxAvailability
Databases:
PROD - Primary database
PRODSTDBY - Physical standby database
Fast-Start Failover: DISABLED
Current status for "ORIGINDR":
SUCCESS
