The error messages manual states:
OGG-02037: Failed to retrieve the name of a missing Oracle redo log.
Cause: An error occurred when Extract tried to retrieve the name of a missing Oracle
redo log.
Action: Fix the error, and then retry the operation.
Thanks, that is so helpful!
As noted extract is reporting missing an archived log file when it is started.
How to fix the error:
ggsi > info myext showch
Read Checkpoint #1
Oracle Integrated Redo Log
….etc…….
Recovery Checkpoint (position of oldest
unprocessed transaction in the data source):
Timestamp: 2017-11-14 16:14:50.000000
SCN:35.2512296532 (52836151892)
Current Checkpoint (position of last record read in the data source):
Timestamp: 2017-11-18 17:18:43.000000
SCN: 35.2950275190 (153274130550)
……etc………..
The archived log containing the recovery checkpoint SCN is the start of the first missing logs. You need to restored all missing logs up to the current redo.
The database alert log will also show it attempt to mine from this scn.
LOGMINER: summary for session# = 3
LOGMINER:
StartScn: 52836151891 (0x0023.95be9a53)
LOGMINER: EndScn: 0
LOGMINER:
HighConsumedScn: 52836151891 (0x0023.95be9a53)
LOGMINER: session_flag: 0x4f0
Run this select to determine the archived log sequence of all the threads if this is a RAC.
select name, thread#, sequence#, status, first_time, next_time, first_change#, next_change# from v$archived_log
where 52836151892 between first_change# and next_change#;
NAME THREAD# SEQUENCE# S FIRST_TIM NEXT_TIME FIRST_CHANGE# NEXT_CHANGE#
------------------------------------------------------------------------------------------------------------------------------------
2 20361 D 14-NOV-17 14-NOV-17 52835801111 52836174287
1 17099 D 14-NOV-17 14-NOV-17 52835982551 52836324779
Status D indicates that the archived log was deleted.
Cheers
Kee Gan