Hi All,
Facing this issue recently in my organization. Previously we were running classic capture. In case of classic capture if we ran into any issue due to which if capture was down we used to restore the archive from the time capture was abended and used to start the extract, which was working fine.
But post upgrading to integrated capture it looks like not easy to move capture back in point.
Current issue:
->Extract is abend with below error:
2022-01-13 06:01:01 ERROR OGG-02022 Logmining server does not exist on this Oracle database.
2022-01-13 06:01:01 ERROR OGG-01668 PROCESS ABENDING.
->In GGSCI error log at the time of extract abend:
2022-01-12T11:34:26.301-0500 ERROR OGG-00662 Oracle GoldenGate Capture for Oracle, EXTCAP.prm: OCI Error ORA-26939: GoldenGate capture "OGG$CAP_EXTCAP" is disabled.
(status = 26939).
2022-01-12T11:34:26.334-0500 ERROR OGG-02078 Oracle GoldenGate Capture for Oracle, EXTCAP.prm: Extract encountered a fatal error in a processing thread and is abending.
2022-01-12T11:34:26.344-0500 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, EXTCAP.prm: PROCESS ABENDING.
->With more investigation at DB level found that extract was dropped at DB level:
BEGIN DBMS_CAPTURE_ADM.DROP_CAPTURE('OGG$CAP_EXTCAP'); END;
->Dictionary was created long back(few months back), and we dont have any latest SCN dictionary to register/recreate extract from that time.
SYS@CP1558
2022-01-13 06:29:45 - SQL> SELECT TRIM(MAX(first_change#)) FROM v$archived_log WHERE dictionary_begin = 'YES';
TRIM(MAX(FIRST_CHANGE#))
----------------------------------------
Question:
Currently capture process is having 18 hrs lag, Is there a way I can start the capture process 18 hrs back .
Any suggestion how to deal with this error in future.
Ps:
GG version: 19
DB version: 19
Thanks,
Sid