175
1 - Checking if the broker is being used.sqlplus / as sysdbashow 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 50000set linesize 800SELECT db_unique_name, database_role, open_mode, protection_mode from v$database;SQL> show parameter DG_BROKER_STARTSQL> ALTER SYSTEM SET DG_BROKER_START=FALSE;SQL> show parameter DG_BROKER_START4 - Copy if you want to save the broker configuration files.SQL> show parameter DG_BROKER_STARTcopy...5 - Dataguard standby server.set pagesize 50000set linesize 800SELECT db_unique_name, database_role, open_mode, protection_mode from v$database;SQL> show parameter DG_BROKER_STARTSQL> ALTER SYSTEM SET DG_BROKER_START=FALSE;SQL> show parameter DG_BROKER_START6 - Copy if you want to save the broker configuration files in standby server.SQL> SHOW PARAMETER DG_BROKERcopy..7 - Remove broker settings in production and standby.dgmgrl /DGMGRL> REMOVE CONFIGURATION;8 - Drop standby redologs.SET LINESIZE 150 COLUMN member FORMAT A50COLUMN first_change# FORMAT 99999999999999999999COLUMN next_change# FORMAT 99999999999999999999SELECT 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; |
