Oracle单机Dataguard环境拆分

备库关机

主库执行操作：

//实时生效

alter system set LOG_ARCHIVE_CONFIG='' scope=both sid='*';

//确定归档目录

alter system set LOG_ARCHIVE_DEST_1='LOCATION=+ARCH' scope=both sid='*';

alter system set LOG_ARCHIVE_DEST_2='' scope=both sid='*';

alter system set fal_client='' scope=both sid='*';

alter system set FAL_SERVER='' scope=both sid='*';

alter system set standby_file_management=manual scope=both sid='*';

//重启生效

alter system reset DB_FILE_NAME_CONVERT scope=spfile sid='*';

alter system reset LOG_FILE_NAME_CONVERT scope=spfile sid='*';

//主要DB_FILE_NAME_CONVERT 和LOG_FILE_NAME_CONVERT 不用reset而是执行以下命令数据库会起不来：

alter system set DB_FILE_NAME_CONVERT=’’ scope=spfile sid='*';
alter system set LOG_FILE_NAME_CONVERT=’’ scope=spfile sid='*';