DG恢复进程一直卡在APPLYING_LOG

tei_2000

手动切换日志时：主库：
Thread 1 advanced to log sequence 84112
  Current log# 2 seq# 84112 mem# 0: /opt/app/oracle/oradata/ORCLDB/onlinelog/redo02.log
Wed Sep 11 11:10:38 2013
LNS: Standby redo logfile selected for thread 1 sequence 84112 for destination LOG_ARCHIVE_DEST_2
LNS1 started with pid=40, OS id=17034

tei_2000

备库：
Media Recovery Waiting for thread 1 sequence 84112 (in transit)
Wed Sep 11 11:03:41 2013
Recovery of Online Redo Log: Thread 1 Group 12 Seq 84112 Reading mem 0
  Mem# 0 errs 0: /opt/app/oracle/oradata/ORCLDB/standbylog/standbyredo12.log
Wed Sep 11 11:05:17 2013
RFS[2]: Possible network disconnect with primary database
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
........
Media Recovery Waiting for thread 1 sequence 84112
Fetching gap sequence in thread 1, gap sequence 84112-84112
Wed Sep 11 12:00:01 2013
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 84112-84112
FAL[client]: All defined FAL servers have been attempted.

tei_2000

主库：
Thread 1 advanced to log sequence 84112
  Current log# 2 seq# 84112 mem# 0: /opt/app/oracle/oradata/ORCLDB/onlinelog/redo02.log
Wed Sep 11 11:10:38 2013
LNS: Standby redo logfile selected for thread 1 sequence 84112 for destination LOG_ARCHIVE_DEST_2
LNS1 started with pid=40, OS id=17034

tei_2000

SQL> select error,dest_name from v$archive_dest;

ERROR                DEST_NAME
-------------------- --------------------
                     LOG_ARCHIVE_DEST_1
                     LOG_ARCHIVE_DEST_2
                     LOG_ARCHIVE_DEST_3
                     LOG_ARCHIVE_DEST_4
                     LOG_ARCHIVE_DEST_5
                     LOG_ARCHIVE_DEST_6
                     LOG_ARCHIVE_DEST_7
                     LOG_ARCHIVE_DEST_8
                     LOG_ARCHIVE_DEST_9
                     LOG_ARCHIVE_DEST_10

10 rows selected.

tei_2000

SQL> select error,dest_name from v$archive_dest where error is not null;

no rows selected

tei_2000

我粘贴多了就发不上去了，只能一点点发

iori809

Wed Sep 11 11:10:38 2013
LNS: Standby redo logfile selected for thread 1 sequence 84112 for destination LOG_ARCHIVE_DEST_
主库11点10分切换的~
备库那个时间的日志呢？
怎么从11点5分直接到12点了呢？

tei_2000

iori809 发表于 2013-9-11 14:56
Wed Sep 11 11:10:38 2013
LNS: Standby redo logfile selected for thread 1 sequence 84112 for destina ...

11点5分直接到12点那个就是备库的，因为中间没有报错，都很正常。
我就发这些，你看一下现在都已经给我删了。你得快点看，不然itpub很快就会把的发的删除了。这是什么情况？

tei_2000

iori809 发表于 2013-9-11 14:56
Wed Sep 11 11:10:38 2013
LNS: Standby redo logfile selected for thread 1 sequence 84112 for destina ...

主备差了几分钟，主库11点10分，对应的备库就是11点03-05那部分日志

tei_2000

备库：
Media Recovery Waiting for thread 1 sequence 84112 (in transit)
Wed Sep 11 11:03:41 2013
Recovery of Online Redo Log: Thread 1 Group 12 Seq 84112 Reading mem 0
  Mem# 0 errs 0: /opt/app/oracle/oradata/ORCLDB/standbylog/standbyredo12.log
Wed Sep 11 11:05:17 2013
RFS[2]: Possible network disconnect with primary database
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
........
Media Recovery Waiting for thread 1 sequence 84112
Fetching gap sequence in thread 1, gap sequence 84112-84112
Wed Sep 11 12:00:01 2013
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 84112-84112
DBID 22400843 branch 693024982
FAL[client]: All defined FAL servers have been attempted.