24^th SEP 2014

DataGuard Broker :-- Switchover and failover physical standby

Definition DG :-- The data guard broker is a framework for monitoring Data Guard configurations.

DG (Data Guard) Configuration

On both Primary and standby sites , change the initialization parameter in the spfile to enable the data guard broker

sql > alter system set dg_broker_start=TRUE scope=both

Execute

dgmgrl

DGMGRL>

Now connect to the primary database

DGMGRL> connect sys/<password>@to_primary

connected

Create broker configuration

DGMGRL> create configuration 'broker1' as primary database is 'primary' connect identifier is 'primary';

'primary' is connect identified is the service name through which the broker is connected to the PRIMARY database)

Add standby database to the above configuration

DGMGRL>Add database 'standby' as connect identifier is to_standby maintained as physical;

("to_standby" in connect identifier is the serivce name through which broker is connected to the STANDBY database)

See the configuration

DGMGRL> show configuration

It will show current status as DISABLE

We need to enable the configuration

DGMGRL> enable configuration;

DGMGRL> show configuration

Current status will be shown as SUCCESS

SWITCHOVER :

Now we are ready to switch over the primary database role to standby database role

DGMGRL > switchover to 'Standby';

Primary database successfully converted to physical standby

DGMGRL> switchover to 'primary';

standby database is successfully converted to primary database

Failover :

DGMGRL>failover to 'standby';

DGMGRL> failover to 'Primary';