OGG-00446 No valid log files for current redo sequence

goldengate 从oracle asm 中增量同步数据时，出现下述错误.

 ERROR   OGG-00446  No valid log files for current redo sequence 367, thread 1, error retrieving redo file name
for sequence 367, archived = 0, use_alternate = 0Not able to establish initial position for begin time 2013-03-27 15:32:46.

 ERROR   OGG-01668  PROCESS ABENDING.

在抽取进程的参数文件中加入TRANLOGOPTIONS DBLOGREADER即可。

 

参考：Extract fail due to an ASM connection configuration issue [ID 1061093.1]

Applies to:

Oracle GoldenGate - Version 11.1.1.0.0 and later
Information in this document applies to any platform.

Goal

To show how to recover from an extract failure when your Archive or Redo files are stored under ASM
and you see one of the following messages

ERROR 118 No Valid Log File For Current Redo Sequence Xxxx, Thread Y

ERROR 500 No valid log files for current redo sequence X, thread Y, error retrieving redo file name for sequence X, archived = 0, use_alternate = 0 Not able to establish initial position for begin time YYYY-MM-DD HH:MI:SS

ERROR OGG-00446  error 2 (No such file or directory) opening redo log <log file name>.dbf for sequence ####
Not able to establish initial position for begin time YYYY-MM-DD HH:MI:SS

Fix

If you are running Oracle ASM, the problem may be that the ASM connection is either not defined or is incorrectly defined or TRANSLOGOPTINS DBLOGREADER needs to be added.   If your archive files are ONLY under ASM and extract receives an error 500, extract may have run successfully until the process needed to read from the ARCHIVES instead of the REDO. Once it needs to read from archive, the extract will fail.

Please Add the following line, or correct it in your Extract parameter file, if you are On Oracle 11.2.0.2 or better,  or 10.2.0.5 or better and using OGG 11.x 

TRANLOGOPTIONS DBLOGREADER

If the above version  of Oracle or OGG doesn't apply to you specifying a user that can connect to the ASM instance and restart your Extract:

TRANLOGOPTIONS ASMUSER <user>@<ASM_instance_name>,
ASMPASSWORD <password>