OGG: OGG-00446 Oracle GoldenGate Capture for Oracle, extdata.prm: No valid log files for current redo
如题所示的错误,发生在为Oracle RAC配置OGG的时候,启动源端(RAC)的抽取进程。
该错误的详细反馈如下:
1 2 3 4 5 |
[oracle@rac2 ogg_1]$ cat ggserr.log | grep --color "OGG-00446" 2016-03-30 11:14:05 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, extdata.prm: No valid log files for current redo sequence 8, thread 1, error retrieving redo file name for sequence 8, archived = 0, use_alternate = 0Not able to establish initial position for begin time 2016-03-30 11:10:12.000000. 2016-03-30 11:27:49 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, extdata.prm: No valid log files for current redo sequence 8, thread 1, error retrieving redo file name for sequence 8, archived = 0, use_alternate = 0Not able to establish initial position for begin time 2016-03-30 11:10:12.000000. 2016-03-30 11:31:23 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, extdata.prm: No valid log files for current redo sequence 8, thread 1, error retrieving redo file name for sequence 8, archived = 0, use_alternate = 0Not able to establish initial position for begin time 2016-03-30 11:30:22.000000. [oracle@rac2 ogg_1]$ |
造成该错误的原因是因为RAC的共享存储采用了ASM(自动存储管理),而OGG的抽取进程无法连接到ASM,[……]