Monday, June 8, 2020

How to disable Dataguard Broker

How to disable Dataguard Broker


On Primary:

Step.1

Verify Dataguard Configuration:

DGMGRL> show configuration
Configuration - dell
Protection Mode: MaxPerformance
Databases:
dell_live - Primary database
dell_stby - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS

Disable fast-start failover:

DGMGRL> DISABLE FAST_START FAILOVER;
Disabled.

Disable Configuration:

DGMGRL> DISABLE CONFIGURATION;
Disabled.

Re-Verify Configuration:

DGMGRL> show configuration;
Configuration - dell
Protection Mode: MaxPerformance
Databases:
dell_live - Primary database
dell_stby - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED

Step.2

Stop DG Broker on Primary:

SQL> select name,open_mode,database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
DELL      READ WRITE           PRIMARY

SQL> show parameter DG_BROKER_START
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start                      boolean     TRUE

SQL> ALTER SYSTEM SET DG_BROKER_START=FALSE;
System altered.

SQL> show parameter DG_BROKER_START
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start                      boolean     FALSE
SQL>

Step.3

Backup DB broker configuration files:

SQL> SHOW PARAMETER DG_BROKER
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1               string      /u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr1.dat
dg_broker_config_file2               string      /u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr2.dat
dg_broker_start                      boolean     FALSE

[oracle@rac1 dbs]$ cp dr1.dat dr1.dat_bkp
[oracle@rac1 dbs]$ cp dr2.dat dr2.dat_bkp

On standby:

Step.4

Stop DG Broker on Standby:

SQL> select name,open_mode,database_role from v$database;
NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
DELL      MOUNTED              PHYSICAL STANDBY

SQL> show parameter DG_BROKER_START
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start                      boolean     TRUE

SQL> ALTER SYSTEM SET DG_BROKER_START=FALSE;
System altered.

SQL> show parameter DG_BROKER_START
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start                      boolean     FALSE

Step.5

Backup DB Broker Configuration Files:

SQL> SHOW PARAMETER DG_BROKER
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1               string      /u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr1.dat
dg_broker_config_file2               string      /u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr2.dat
dg_broker_start                      boolean     FALSE

[oracle@rac2 dbs]$ cp dr1.dat dr1.dat_bkp
[oracle@rac2 dbs]$ cp dr2.dat dr2.dat_bkp



No comments:

Post a Comment