#取消以下参数
alter system reset LOG_ARCHIVE_CONFIG scope=spfile sid='*';
alter system reset DB_FILE_NAME_CONVERT scope=spfile sid='*';
alter system reset LOG_FILE_NAME_CONVERT scope=spfile sid='*';
alter system reset LOG_ARCHIVE_DEST_STATE_2 scope=spfile sid='*';
alter system reset STANDBY_FILE_MANAGEMENT scope=spfile sid='*';
alter system reset FAL_SERVER scope=spfile sid='*';
alter system reset FAL_CLIENT scope=spfile sid='*';
###启动数据库脱离dg环境
SQL>  ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE;
SQL>  SHUTDOWN IMMEDIATE;
SQL>  STARTUP
SQL> select database_role,switchover_status,open_mode from v$database;

DATABASE_ROLE    SWITCHOVER_STATUS    OPEN_MODE
---------------- -------------------- --------------------
PRIMARY          NOT ALLOWED          READ WRITE

#查询确认主库是否是最大性能模式,如果不是最大性能模式，需要使用命令修改
SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;
#移除(S)PFILE 参数文件dg参数
alter system reset LOG_ARCHIVE_CONFIG scope=spfile sid='*';
alter system reset DB_FILE_NAME_CONVERT scope=spfile sid='*';
alter system reset LOG_FILE_NAME_CONVERT scope=spfile sid='*';
#alter system reset LOG_ARCHIVE_DEST_1 scope=spfile sid='*';
#LOG_ARCHIVE_DEST_n pointing to the Standby Database and valid for STANDBY_LOGFILES
#LOG_ARCHIVE_DEST_STATE_n 
alter system reset LOG_ARCHIVE_DEST_2 scope=spfile sid='*';
alter system reset DG_BROKER_START scope=spfile sid='*';
alter system reset DG_BROKER_CONFIG_FILE1 scope=spfile sid='*';
alter system reset DG_BROKER_CONFIG_FILE2 scope=spfile sid='*';
alter system reset STANDBY_ARCHIVE_DEST scope=spfile sid='*';
alter system reset STANDBY_FILE_MANAGEMENT scope=spfile sid='*';
alter system reset FAL_SERVER scope=spfile sid='*';
alter system reset FAL_CLIENTscope=spfile sid='*';
##删除主库所有的Standby Redolog Groups
SQL> SELECT GROUP# FROM V$STANDBY_LOG;
SQL> alter database drop standby logfile group 3;
##删除 Data Guard Broker Configuration 配置文件
SQL> show parameter DG_BROKER_CONFIG;

$ORACLE_HOME/dbs/dr1<ORACLE_SID>.dat and 
$ORACLE_HOME/dbs/dr2<ORACLE_SID>.dat