Friday, May 24, 2013

How to re-configure dataguard broker


Sometimes there is some issue with dataguard broker configuration, you may want to re-configure it. Here are the steps

1, Stop dataguard brokers on both primary and standby database

alter system set dg_broker_start = false;

2, Remove the dataguard configure files on both primary and standby database from ASM or filesystem

3, Start dataguard brokers on both primary and standby database

alter system set dg_broker_start = true;

4, Re-create dataguard broker configuraation

DGMGRL> CONNECT sys;
Password: password
Connected.

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

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

DGMGRL> ENABLE CONFIGURATION;
Enabled.

DGMGRL> SHOW CONFIGURATION;


No comments:

Post a Comment