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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OGG-02870 missing log file waiting for redo

user10126973Oct 12 2024

Hello All,

I am getting the follwoing error for my OGG downstream setup.

ogg-02870 oracle goldengate capture for oracle extract missing log file waiting for redo file na thread 1 sequence 0 scn not available

I have used the follwoing step for downstream

source DB

=================
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=MINEDB ASYNC NOREGISTER VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=MINEDB';
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;
ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(PROD,MINEDB)';

Downstreams
=======================
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='LOCATION=/u01/oradata/minedb/arch_remote VALID_FOR=(STANDBY_LOGFILE,PRIMARY_ROLE);
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;
ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(PROD,MINEDB)';

Parameter file
===================
EXTRACT myext
USERID ggate@prod, PASSWORD ggate
TRANLOGOPTIONS MININGUSER ggate@minedb MININGPASSWORD ggate
TRANLOGOPTIONS INTEGRATEDPARAMS (downstream_real_time_mine Y)
EXTTRAIL /u01/app/oracle/product/gg19c/dirdat/ic
TABLE scott.emp;

Please share your thoughts how to reslove this iisue.

I deleted multiple times extract still I am getting an error;

Regards,

DR

Comments
Post Details
Added on Oct 12 2024
0 comments
32 views