ADG switch over(主备切换)
1:准备工作
1.1检查ADG状态是否正常
Standby
Sql>select process,status fromv$managed_standby;
Note:RFS为idle。MRP0为APPLYING_LOG。
Primary
Sql>SELECT RECOVERY_MODE FROMV$ARCHIVE_DEST_STATUS WHERE DEST_ID=2;
Note:RECOVERY_MODE为MANAGED REAL TIME APPLY
1.2 检查是否有gap
Sql>select * from v$archive_gap
Note:如果存在gap,可以从主库复制传输缺失的归档文件到备库,并注册
1.3停掉job(primary)
主库停止运行的JOB,并设置参数:
Sql>Alter system set job_queue_processing=0 scope=both;
Sql>Alter system set AQ_TM_PROCESSES=0 scope=both;
Note:切换完成在开启
1.4