这个需求比较特别,由于用户空间及存储性能的问题,希望将物理备库直接转变称主库,原备库退出DG环境。
Oracle提供了相对较为简单的方法,供参考:
1. Confirm Primary Database in Maximum Performance Mode
2. Remove Data Guard Broker Configuration
DGMGRL> REMOVE CONFIGURATION;
3. Unset Data Guard-specific Initialization Parameters //此处前提安装了配置了DG Broker
Unset/Remove following Initialization Parameters from the (S)PFILE of the Primary Database:
LOG_ARCHIVE_CONFIG
DB_FILE_NAME_CONVERT
LOG_FILE_NAME_CONVERT
LOG_ARCHIVE_DEST_n pointing to the Standby Database and valid for STANDBY_LOGFILES
LOG_ARCHIVE_DEST_STATE_n
DG_BROKER_START
DG_BROKER_CONFIG_FILE1
DG_BROKER_CONFIG_FILE2
STANDBY_ARCHIVE_DEST
STANDBY_FILE_MANAGEMENT
FAL_SERVER
FAL_CLIEN