Oracle GoldenGate has been set up from noarchivelog db to noarchivelog db which are DWH dbs.The purpose of this , is to transfer processed data from live system to Test in order to avoid to run same ETL process on Test system.
But there was a miss point that all source and target systems are in noarchive mode and no archive logs exist to read for extract process.Because of this, following error has been occured when log switch frequency increased while ETL process and GG extract was not able to capture transaction from old redo log .
By default GG reads online redo logs , but when they are all switched , GG can read from archive logs.
For noarchive mode database , my solution was increase of size of redo logs according to switch frequency. I have increased from 4GB to 16GB for each redo logs and i have not seen any error after this change.
Error :
OGG-01028 Oracle GoldenGate Capture for Oracle, efact.prm: Redo sequence 14368 no longer available in online logs for thread 1 without archiving enabled, SQL <SELECT MAX(sequence#) FROM v$log WHERE thread# = :ora_thread>, error retrieving redo file name for sequence 14368, archived = 1, use_alternate = 0.
But there was a miss point that all source and target systems are in noarchive mode and no archive logs exist to read for extract process.Because of this, following error has been occured when log switch frequency increased while ETL process and GG extract was not able to capture transaction from old redo log .
By default GG reads online redo logs , but when they are all switched , GG can read from archive logs.
For noarchive mode database , my solution was increase of size of redo logs according to switch frequency. I have increased from 4GB to 16GB for each redo logs and i have not seen any error after this change.
Error :
OGG-01028 Oracle GoldenGate Capture for Oracle, efact.prm: Redo sequence 14368 no longer available in online logs for thread 1 without archiving enabled, SQL <SELECT MAX(sequence#) FROM v$log WHERE thread# = :ora_thread>, error retrieving redo file name for sequence 14368, archived = 1, use_alternate = 0.
