Oracle 11g Data Guard Broker Configuration

Oracle 11g Data Guard Broker Configuration

Oracle Server - Enterprise Edition - Version 11.2.0.2

Goal

Step By Step How to create Dataguard Broker Configuration.

Fix

Step 1. Start broker in both of primary and standby (in all instances in case of RAC):

SQL>ALTER SYSTEM SET DG_BROKER_START=TRUE;

Step 2. Connect to DGMGRL on primary: (from instance one in case of RAC) 

$dgmgrl
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>;
Connected.

Step 3. Create configuration on primary:

DGMGRL> CREATE CONFIGURATION 'MY_CONFIGURATION' AS PRIMARY DATABASE IS 'PRIMARY' CONNECT IDENTIFIER IS primary;

Configuration "MY_CONFIGURATION" created with primary database "PRIMARY"

Step 4. Add standby in the configuration:

DGMGRL> ADD DATABASE 'STANDBY' AS CONNECT IDENTIFIER IS STANDBY MAINTAINED AS PHYSICAL;

Database "STANDBY" added

Step 5. Enable Configuration:

DGMGRL> ENABLE CONFIGURATION;
Enabled.

Use the SHOW command to verify that the configuration and its databases were successfully enabled and brought online:

DGMGRL> SHOW CONFIGURATION;

Configuration
Name: MY_CONFIGURATION

Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED

Databases:
PRIMARY - Primary database
STANDBY - Physical standby database

Current status for "MY_CONFIGURATION"
SUCCESS