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';
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;
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
4 - Copy if you want to save the broker configuration files.
SQL> show parameter DG_BROKER_START
copy...
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
6 - Copy if you want to save the broker configuration files in standby server.
SQL> SHOW PARAMETER DG_BROKER
copy..
7 - Remove broker settings in production and standby.
dgmgrl /
DGMGRL> REMOVE CONFIGURATION;
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;