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

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;
Advertisements

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?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s