ERROR -OGG-00446 -Oracle GoldenGate Capture for Oracle: No valid log files for current redo sequence XXX, thread X

Posted on by Anand

I was trying to setup Oracle GoldenGate (OGG) on my test box having 11gR2 database with ASM. On starting the extract process on the source showed –

GGSCI (anand-lab) 6> START EXTRACT ext1

Sending START request to MANAGER ...
EXTRACT EXT1 starting


GGSCI (anand-lab) 7> INFO EXTRACT ext1

EXTRACT    EXT1      Initialized   2011-07-17 14:22   Status STOPPED
Checkpoint Lag       00:00:00 (updated 01:22:49 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2011-07-17 14:22:50  Seqno 0, RBA 0

The extract process stopped.Checked the log which showed 

2011-07-17 15:44:35  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, MGR.prm:  EXTRACT EXT1 starting.
2011-07-17 15:44:36  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, EXT1.prm:  EXTRACT EXT1 starting.
2011-07-17 15:44:36  INFO    OGG-01635  Oracle GoldenGate Capture for Oracle, EXT1.prm:  BOUNDED RECOVERY: reset to initial or altered checkpoint.
2011-07-17 15:44:39  INFO    OGG-01515  Oracle GoldenGate Capture for Oracle, EXT1.prm:  Positioning to begin time Jul 17, 2011 2:22:50 PM.
2011-07-17 15:45:00  ERROR   OGG-00446  Oracle GoldenGate Capture for Oracle, EXT1.prm:  No valid log files for current redo sequence 140, thread 1, error retrieving redo file name for sequence 140, archived = 0, use_alternate = 0Not able to establish initial position for begin time 2011-07-17 14:22:50.
2011-07-17 15:45:00  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, EXT1.prm:  PROCESS ABENDING.

The parameter file for the Online Extract group ext1 

EXTRACT ext1
USERID gg_owner, PASSWORD gg123
RMTHOST anand-lab, MGRPORT 7809
RMTTRAIL /media/sf_database/gg/dirdat/rt
TABLE hr.jobs;
TABLE scott.emp;

As the redo log file was stored under ASM, the process was unable to connect to ASM leading to the error.So, for the Extract process to run successfully, specify a user that can connect to the ASM instance using the below in Extract Parameter file –

TRANLOGOPTIONS ASMUSER {user}@{ASM_TNS_ALIAS} ASMPASSWORD {password}

Edited my Extract Parameter with the required parameter and Extract started running with errors –

EXTRACT ext1
USERID gg_owner, PASSWORD gg123
TRANLOGOPTIONS ASMUSER sys@ASM ASMPASSWORD sysasm123
RMTHOST anand-lab, MGRPORT 7809
RMTTRAIL /media/sf_database/gg/dirdat/rt
TABLE hr.jobs;
TABLE scott.emp;

2 thoughts on “ERROR -OGG-00446 -Oracle GoldenGate Capture for Oracle: No valid log files for current redo sequence XXX, thread X”

  1. I have a question about Flashback Data Archive tables in Goldengate replication. Are these tables usually excluded in an extract like “TABLEEXCLUDE .SYS_FBA_*”?
    What is the approach for replicating and initial load of Flash Back Data Archive tables?
    Here is my problem. I exported a user schema using Oracle DataPump, imported into destination database. GoldenGate abended saying some tables dont exist on dest. I checked tables and there were about 200 tables that were not exported because they are FBDA tables and DataPump just ignores them. So, I recreated them on source with scripts.
    So, how is this done? Source and destination have their own FBDA and these tables should not be neither recreated with scripts on dest or replicated? Or they have to be replicated with contents?

    Reply

Leave a comment