ADG延迟（主库为RAC，备库为单节点）

huqianhao

环境：主库RAC，备库：单节点
版本：11.2.0.3

问题：备库有延迟。

SQL> select * from v$dataguard_stats;

NAME                             VALUE                                                            UNIT                           TIME_COMPUTED                  DATUM_TIME
-------------------------------- ---------------------------------------------------------------- ------------------------------ ------------------------------ ------------------------------
transport lag                    +00 04:15:06                                                     day(2) to second(0) interval   10/21/2013 23:05:09            10/21/2013 23:03:46
apply lag                        +00 04:15:06                                                     day(2) to second(0) interval   10/21/2013 23:05:09            10/21/2013 23:03:46
apply finish time                +00 00:01:17.013                                                 day(2) to second(3) interval   10/21/2013 23:05:09            
estimated startup time           22                                                               second                         10/21/2013 23:05:09            

SQL>

备库alert：
======备库==================
Mon Oct 21 19:21:47 2013
WARN: ARCH: Terminating pid 27322 hung on an I/O operation
krsv_proc_kill: Killing 1 processes (Process by index)
。。。。
Mon Oct 21 22:19:22 2013
RFS[798]: Assigned to RFS process 29869
RFS[798]: Opened log for thread 2 sequence 26456 dbid -1726806994 branch 804210317
Mon Oct 21 22:21:22 2013
CORRUPTION DETECTED: In redo blocks starting at block 65537count 2048 for thread 2 sequence 26456
RFS[798]: Possible network disconnect with primary database
Mon Oct 21 22:21:26 2013
FAL[client]: Failed to request gap sequence
GAP - thread 2 sequence 26456-26456
DBID 2568160302 branch 804210317
FAL[client]: All defined FAL servers have been attempted.
------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that's sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.
------------------------------------------------------------
Mon Oct 21 22:22:02 2013
RFS[799]: Assigned to RFS process 29916
RFS[799]: Opened log for thread 2 sequence 26456 dbid -1726806994 branch 804210317
Mon Oct 21 22:24:03 2013
Archived Log entry 55030 added for thread 1 sequence 35878 ID 0x9c68f61d dest 1:
Mon Oct 21 22:27:23 2013
Primary database is in MAXIMUM PERFORMANCE mode
Re-archiving standby log 45 thread 2 sequence 26522
RFS[800]: Assigned to RFS process 30009
RFS[800]: Selected log 46 for thread 2 sequence 26523 dbid -1726806994 branch 804210317
Mon Oct 21 22:27:24 2013
Archived Log entry 55031 added for thread 2 sequence 26522 ID 0x9c68f61d dest 1:
Mon Oct 21 22:28:19 2013
WARN: ARCH: Terminating pid 29916 hung on an I/O operation
krsv_proc_kill: Killing 1 processes (Process by index)
Mon Oct 21 22:28:24 2013
RFS[801]: Assigned to RFS process 30025
RFS[801]: Opened log for thread 2 sequence 26456 dbid -1726806994 branch 804210317


主库alert：
Mon Oct 21 22:18:59 2013
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
LNS: Standby redo logfile selected for thread 1 sequence 35879 for destination LOG_ARCHIVE_DEST_2
Mon Oct 21 22:19:15 2013
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance finance1 - Archival Error. Archiver continuing.
Mon Oct 21 22:28:18 2013
FAL[server, ARC2]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance finance1 - Archival Error. Archiver continuing.
Mon Oct 21 22:34:02 2013
Thread 1 advanced to log sequence 35880 (LGWR switch)
  Current log# 6 seq# 35880 mem# 0: +DATA/finance/onlinelog/redo06.log
  Current log# 6 seq# 35880 mem# 1: +FRA/finance/onlinelog/redo06_6.log
Mon Oct 21 22:34:02 2013
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************

Maclean Liu(刘相兵

是XD吗？

备机 的 /var/log/messages看下

WARN: ARCH: Terminating pid 27322 hung on an I/O operation
krsv_proc_kill: Killing 1 processes (Process by index)
。。。。
Mon Oct 21 22:19:22 2013
RFS[798]: Assigned to RFS process 29869
RFS[798]: Opened log for thread 2 sequence 26456 dbid -1726806994 branch 804210317
Mon Oct 21 22:21:22 2013
CORRUPTION DETECTED: In redo blocks starting at block 65537count 2048 for thread 2 sequence 26456



可能需要的数据 :最好有当时的OSW数据 ； 感觉你们的这个备机IO还是有问题，有机会的话建议找硬件工程师查一下

huqianhao

呵呵，搞定啦。gap问题。手动解决了一个gap，后面的就在慢慢同步啦

huqianhao

Maclean Liu(刘相兵 发表于 2013-10-22 00:13
是XD吗？

备机 的 /var/log/messages看下

不是XD。
奇怪，我昨晚看帖子的时候没看到你的回复。但我回复后发现我是3楼。就是看不到2楼的信息