解除Oracle Dataguard复制关系.

将primary 数据库从 dataguard 复制关系中独立出来,作为standalone库运行.

1.Put primary database on maximum performance mode:
SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;
 
2. Remove below parameters from spfile of primary database:
FAL_SERVER
FAL_CLIENT
LOG_ARCHIVE_CONFIG
DB_FILE_NAME_CONVERT
LOG_FILE_NAME_CONVERT
LOG_ARCHIVE_DEST_n – pointing to standby database like _2 or _3
LOG_ARCHIVE_DEST_STATE_n
STANDBY_ARCHIVE_DEST
STANDBY_FILE_MANAGEMENT

SQL>alter system reset LOG_ARCHIVE_CONFIG scope=spfile;
SQL>alter system reset DB_FILE_NAME_CONVERT scope=spfile;
SQL>alter system reset LOG_FILE_NAME_CONVERT scope=spfile;
SQL>alter system reset STANDBY_FILE_MANAGEMENT scope=spfile;
SQL>alter system reset FAL_SERVER scope=spfile;
SQL>alter system reset FAL_CLIENT scope=spfile;
SQL>alter system reset LOG_ARCHIVE_DEST_STATE_2 scope=spfile;
SQL>alter system reset LOG_ARCHIVE_DEST_2 scope=spfile; --- destination pointing to standby
SQL>alter system reset STANDBY_ARCHIVE_DEST scope=spfile;
 

3. Drop all standby log files from primary:

SQL>SELECT GROUP# FROM V$STANDBY_LOG;
SQL>alter database drop standby logfile group 6;
SQL>alter database drop standby logfile group 7;
SQL>alter database drop standby logfile group 8;
SQL>alter database drop standby logfile group 9;
 

4. Restart the database to reflect the parameters

SQL>shutdown immediate;
SQL>startup
 

Now the standby database is completely separated from primary.

也可以将standby库从dataguard复制关系中独立出来独立运行,并修改dbid.详细参考连接.

 

 

参考 ：https://dbaclass.com/article/remove-dataguard-configuration-from-primary-database/

 

 

 

 

 

 

引用外部连接，如有侵权，请联系删除.