Configure Data Guard

Step 1 Check parameter DG_BROKER_START on primary and standby side. If value show FALSE then set to TRUE.

Step 2 Define a service for the listener:
At Standby instance:

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = \oracle\product\10.2.0\db_1)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = prod_DGMGRL)

(ORACLE_HOME = \oracle\product\10.2.0\db_1)

(SID_NAME = standby)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = oprsms)(PORT = 1521))

)

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

)

At Primery Instance:

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = \oracle\product\10.2.0\db_1)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = prod_DGMGRL)

(ORACLE_HOME = \oracle\product\10.2.0\db_1)

(SID_NAME = prod)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = primery hostname)(PORT = 1521))

)

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

)

Note: GLOBAL_DBNAME should be set to <<db_unique_name>>_DGMGRL in listener.ora on all instances of both primary and standby. This is important otherwise you'll have TNS-12154 error during switchover operation.

Step 3 Now to create the data guard broker configurations:

$ dgmgrl
DGMGRL> connect /
Connected.
DGMGRL> create configuration 'TEST'
> as primary database is 'prod'
> connect identifier is prod;
Configuration "TEST" created with primary database "prod"
DGMGRL>

DGMGRL> show configuration

Configuration
Name: TEST
Enabled: NO
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
prod- Primary database

Current status for "TEST":
DISABLED

Step 4 Now add standby DB to the data broker configuration:

DGMGRL> add database 'standby' as
> connect identifier is standby
> maintained as physical;
Database "standby" added
DGMGRL>
DGMGRL> show configuration

Configuration
Name: TEST
Enabled: NO
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:

prod- Primary database
standby - Physical standby database

Current status for "TEST":
DISABLED

Step 5 Now enable the configurations:
DGMGRL> enable configuration
Enabled.
DGMGRL> show configuration

Configuration
Name: TEST
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
prod- Primary database
standby- Physical standby database

Current status for "TEST":

DGMGRL> show database verbose standby

Now your data guard has been configured successfully.