#主库检查current sequence# SQL> select thread#,sequence#,status from v$log; #主库检查LNS进程正在写的sequence# SQL> select process,sequence#,status from v$managed_standby; #备库检查正在应用的sequence# SQL> SELECT PROCESS,THREAD#,SEQUENCE#,STATUS FROM V$MANAGED_STANDBY; #检查是否存在GAP SQL> SELECT THREAD#,LOW_SEQUENCE#,HIGH_SEQUENCE# FROM V$ARCHIVE_GAP; no rows selected (责任编辑:) |