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.