归档日志损坏,splex无法读取归档应用日志

http://blog.csdn.net/xinxiangsui2008/article/details/26456641

环境：生产库11.2.0.3 rac + rac dg + shareplex同步数据到occ库 

主库alert报错如下：

Incomplete read from log member '+RECOVERYDG/stddb/archivelog/2014_05_20/thread_1_seq_107375.3227.848094297'. Trying next member.

splex报错日志如下：

Capture: Error reading block 18156704 from file +RECOVERYDG/stddb/archivelog/2014_05_20/thread_1_seq_107375.3227.848094297:   (capturing from stddb) [module oct]

Notice   2014-05-21 09:35:58.324405 50136118 1029 Capture: Using archive log +RECOVERYDG/stddb/archivelog/2014_05_20/thread_1_seq_107375.3227.848094297  (capturing from stddb) [module oct]

关闭splex: shutdown

主库端查询出错的归档：

select name From v$archived_log a where a.THREAD# = 1  and a.SEQUENCE# = 107375;  --主库端

备库端:

select name From v$archived_log a where a.THREAD# = 1  and a.SEQUENCE# = 107375; --备库端

+RECOVERYDG/prddb/archivelog/2014_05_20/thread_1_seq_107375.2183.848094325

备库端

ASMCMD> cp thread_1_seq_107375.2183.848094325 /tempfs/asmdir
copying +RECOVERYDG/prddb/archivelog/2014_05_20/thread_1_seq_107375.2183.848094325 -> /tempfs/asmdir/thread_1_seq_107375.2183.848094325

sftp到主库端PUT到/tempfs/grid_dir目录下

sftp> put thread_1_seq_107375.2183.848094325
Uploading thread_1_seq_107375.2183.848094325 to /tempfs/grid_dir/thread_1_seq_107375.2183.848094325
thread_1_seq_107375.2183.848094325  

主库端

$rman target /
RMAN> catalog archivelog "/tempfs/grid_dir/thread_1_seq_107375.2183.848094325";

cataloged archived log
archived log file name=/tempfs/grid_dir/thread_1_seq_107375.2183.848094325 RECID=283005 STAMP=848142741

RMAN> delete archivelog "+RECOVERYDG/stddb/archivelog/2014_05_20/thread_1_seq_107375.3227.848094297";

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=7927 instance=stddb2 device type=DISK
List of Archived Log Copies for database with db_unique_name STDDB
=====================================================================

Key     Thrd Seq     S Low Time 
------- ---- ------- - ---------
282846  1    107375  A 20-MAY-14
        Name: +RECOVERYDG/stddb/archivelog/2014_05_20/thread_1_seq_107375.3227.848094297


Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=+RECOVERYDG/stddb/archivelog/2014_05_20/thread_1_seq_107375.3227.848094297 RECID=282846 STAMP=848094360
Deleted 1 objects

RMAN>

重新开启splex

$/tempfs/splex/prodir/bin/sp_cop -u2200 &

此时，alert日志不再报错。