Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Golden Gate Integrated Extract won't start

User_C78QHJan 19 2018 — edited Jan 22 2018

Hi Experts,

I need help with getting an Oracle extract started.

It is an integrated extract running in a downstream database.

Due to missing archive log it was lagging behind. Yesterday I stopped the extracts/ replicats and sycned the source and destination databases using datapump flashback_scn.

After the sync is completed I am trying to start the extract from scn(flashback_scn) and it won't start.

alter extract ENDPRD_A scn 16421455756;

start extract ENDPRD_A ;

Error

2018-01-19 09:34:52  ERROR   OGG-00868  Oracle GoldenGate Capture for Oracle, endprd_a.prm:  Error code 1291, error message: ORA-01291: missing logfile

(Missing Log File /u01/app/oraclegg/fast_recovery_area/DOWNSTREAM/archivelog/2017_12_07/o1_mf_2_19811_f2mf3wby_.arc. Read Position SCN: 3.3536553868 (16421455756)).

2018-01-19 09:34:52  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, endprd_a.prm:  PROCESS ABENDING

I am sure why it is looking at the old archive log which was missing since 07th of December. The scn -16421455756 is certainly latest and I validated in source database.

I even tried to start the extract from current and it is still failing

ALTER EXTRACT ENDPRD_A, BEGIN NOW

Even then it looks for the same missing archive log.

I am new to Golden Gate , please advise how do I force GG to just start moving forward .

Thanks

Aravind

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2018
Added on Jan 19 2018
3 comments
2,528 views