环境:生产库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日志不再报错。