Sam Mathews, October 02, 2016 - 12:27 pm UTC
Due to some reasons, there is a scheduled job on source database which performs the backup of source database in every 5 hours and deletes the archived logs which can not be changed. Is there any other solution?
October 03, 2016 - 12:02 am UTC
"Due to some reasons" is tyically the phrase used by DBA's when they dont want to change their processes :-)
Because "which can not be changed" is of course fiction. It's not like we ship the database to you with an delete-5hrs process built in :-)
The problem is pretty simple - you want resource "X", and someone else is deleting resource "X" before you used it.
Why archivelogs are need for extract process.
vinodh, May 25, 2017 - 3:28 pm UTC
Hi As the gg extract process looking for transaction from redo logs why archive logs are need ?
Is it due to long running transaction?
Thanks,
Vinodh G R
May 30, 2017 - 1:40 pm UTC
Thanks for asking.
Oracle GoldenGate will read the redo logs to capture data for committed transactions. The archive logs are needed for various reasons, but the three most common are:
1. Long running transaction
2. The capture process has been stopped and the SCN has moved into the archive logs, upon recovery or restart
3. The capture process has been setup as a mining server, which requires archive logs.
When you see the error:
"OGG-00446 Oracle Golden Gate Capture for Oracle, ext1.prm: Could not find archived log for sequence xx"
This is due to one of two reasons:
1. The stopping point of the capture process moving into archive logs and the required archive log is missing
2. On restart/recovery of the capture process the archive log is not available due to an RMAN backup or access to the directory where archive logs are is not available.