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