Removing Oracle Data Guard Configuration

Oracle Database Running With Three Data Guards one Physical standby and one logical standby. I am going to remove one physical standb database from current configuration.


Primary Database :PrimaryDB (orcl)
Standby Database :PhysicalDB,LogicalDB

Want to remove : LogicalDB

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; (LogicalBD)
shutdown immediate; (LogicalDB)

$ sqlplus /nolog
$ connect /as sysdba@primarydb

1. alter system set log_archive_dest_state_3=defer scope=both;
2. alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,physicaldb)' scope=both;
3. alter system set fal_server=orcl,physicaldb scope=both;

4.remove the log_archive_dest_n='service= ' in init.ora related to the standby database

5.remove the tnsnames in primary.


Remove Data Guard Broker (DGMGRL) configurationo

$DGMGRL
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/password
DGMGRL> disable configuration
DGMGRL> show configuration

Configuration
Name: dataguard
Enabled: NO
Protection Mode: MaxPerformance
Databases:
orcl - Primary database
physicaldb - Physical standby database
logicaldb - logical standby database

Fast-Start Failover: DISABLED

Current status for "dataguard":
DISABLED

DGMGRL> remove database logicaldb;
Removed database "logicaldb" from the configuration
DGMGRL> enable configuration
Enabled.
DGMGRL>