Capture errors out with "Warning: Detect compressed redo-log/archive-log"
説明
Capture stops with the following error:
Process launched: sp_ocap (for o.SID) [pid = 26558] Notice: FioSetEnsure: set redolog_ensure to 1 [sp_ocap/26558] Notice: Oracle env - SID:/dba76/p001/app/oracle/SID/9.2.0 [sp_ocap(pdb)/26558] Notice: status = OPEN [sp_ocap(osp)/26558] Notice: db_block_size 8192. [sp_ocap(osp)/26558] Notice: The SharePlex supplemental logging state is: Disabled [sp_ocap/26558] Notice: The database supplemental logging state is: Disabled [sp_ocap/26558] Notice: ocm set upgrade version from 0 to 50 [sp_ocap/26558] Notice: Oracle env - SID:/dba76/p001/app/oracle/SID/9.2.0 [sp_cnc(pdb)/26503] Notice: Oracle version 92 [sp_ocap(osp)/26558] Notice: Using archive log /dba76/p090/arch/SID/log_305285.log.Z [sp_ocap/26558] Warning: Detect compressed redo-log/archive-log [sp_ocap/26558] Process exited sp_ocap (for o.SID) [pid = 26558] - exit(1)
原因
Archive logs are compressed and capture can not read it
対策
Sometimes Capture may fall behind for any reasons, like Capture down for long time, heavy batch job executed on source, etc. During that time it is possible that the archive logs have been compressed so when Capture eventually catches up and tries to read the logs, it is not able to do so.
RESOLUTION:
1. sp_ctrl> stop Capture 2. Un-compress all logs starting with the problem log 3. sp_ctrl> start Capture.
