Disabling and removing dataguard using broker.

1 – Checking if the broker is being used.

sqlplus / as sysdba
show parameter dg_broker;
show parameter dg_broker_start;
select name, value from v$parameter where name = 'dg_broker_start';

SQL

2 – On the primary productive server, disable DG Broker.

SQL> alter system set LOG_ARCHIVE_CONFIG=NODG_CONFIG scope=both sid='*';
 
dgmgrl /
DGMGRL> DISABLE FAST_START FAILOVER;
DGMGRL> disable configuration;
DGMGRL> SHOW CONFIGURATION;

SQL

3 – On the primary productive server, stop DG Broker.

set pagesize 50000
set linesize 800
SELECT db_unique_name, database_role, open_mode, protection_mode from v$database;

SQL> show parameter DG_BROKER_START
SQL> ALTER SYSTEM SET DG_BROKER_START=FALSE;
SQL> show parameter DG_BROKER_START

SQL

4 – Copy if you want to save the broker configuration files.

SQL> show parameter DG_BROKER_START
copy...

SQL

5 – Dataguard standby server.

set pagesize 50000
set linesize 800
SELECT db_unique_name, database_role, open_mode, protection_mode from v$database;
 
SQL> show parameter DG_BROKER_START
SQL> ALTER SYSTEM SET DG_BROKER_START=FALSE;
SQL> show parameter DG_BROKER_START

SQL

6 – Copy if you want to save the broker configuration files in standby server.

SQL> SHOW PARAMETER DG_BROKER
copy..

SQL

7 – Remove broker settings in production and standby.

dgmgrl /
DGMGRL> REMOVE CONFIGURATION;

SQL

8 – Drop standby redologs.

SET LINESIZE 150 
COLUMN member FORMAT A50
COLUMN first_change# FORMAT 99999999999999999999
COLUMN next_change# FORMAT 99999999999999999999
SELECT l.thread#,
       lf.group#,
       lf.member,
       TRUNC(l.bytes/1024/1024) AS size_mb,
       l.status,
       l.archived,
       lf.type--,
       --lf.is_recovery_dest_file AS rdf,
       --l.sequence#,
       --l.first_change#,
       --l.next_change#   
FROM   gv$logfile lf
       JOIN gv$log l ON l.group# = lf.group#
ORDER BY l.thread#,lf.group#, lf.member;
SET LINESIZE 150  
 
SQL> alter database drop standby logfile group 3;
SQL> alter database drop standby logfile group 4;

SQL

Leave a Reply Cancel reply