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