Oracle Data Guard 主从切换 状态.docVIP

Oracle Data Guard 主从切换 状态 SQL SELECT SWITCHOVER_STATUS FROM V$DATABASE; SWITCHOVER_STATUS -------------------- UNRESOLVABLE GAP 问下主库是这种模式可以进行切换吗 --------------------------------------------------------------------------------------------------------------------------------- SQL select * from v$version where rownum2; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production 11g进行主备库切换的时候要先检查主备库的切换状态： primary： SQL select switchover_status from v$database; SWITCHOVER_STATUS ------------------------------------------------------------ UNRESOLVABLE GAP standby： SQL select switchover_status from v$database; SWITCHOVER_STATUS ------------------------------------------------------------ RECOVERY NEEDED 但是主备库之间是通的，也就是主库切换一个日志可以传输到备库上，但是没有应用 查看日志应用情况 SQL SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#; SEQUENCE# APPLIED ---------- --------------------------- 1360 NO 1361 NO 1362 NO 1363 NO 1364 NO 1365 NO 1366 NO 1367 NO 1368 NO 1369 NO 为什么没有应用？？？ 查看备库的应用进程的情况 SQL select process,status from v$managed_standby; PROCESS STATUS --------------------------- ------------------------------------ ARCH CONNECTED ARCH CONNECTED ARCH CONNECTED ARCH CONNECTED RFS IDLE RFS IDLE RFS IDLE RFS IDLE MRP0 WAIT_FOR_GAP----------------等待gap 那到底在等待那些gap？ SQL select * from v$archive_gap; THREAD# LOW_SEQUENCE# HIGH_SEQUENCE# ---------- ------------- -------------- 1 1358 1359 可以发现此时等待gap并没有传输到备库上，而备库接受的最低seq是1360，因为1359丢失导致后面的log并没有被应用 此时去查看主库的rman备份策略 RMAN show all; using target database c