Hi
I'm using
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401
I have searched for this error in the Oracle Community, before opening a new discussion.
I'm using INTEGRATED CAPTURE.
I have runned the suggested query:
SELECT r.CONSUMER_NAME,
r.SOURCE\_DATABASE,
r.SEQUENCE#,
r.NAME,
r.FIRST\_SCN,
r.NEXT\_SCN,
c.REQUIRED\_CHECKPOINT\_SCN
FROM DBA_REGISTERED_ARCHIVED_LOG r, DBA_CAPTURE c
WHERE r.CONSUMER_NAME = c.CAPTURE_NAME AND
r.NEXT\_SCN >= c.REQUIRED\_CHECKPOINT\_SCN;
My problem is that the required archivelogs were already deleted from system and I have no backup of them.
I only have archives from 2016-08-22 01:56 till today.
I have tried the command ALTER EXTRACT PEX00001, BEGIN 2016-08-22 01:56
It didn't work.
Then I have tried ALTER EXTRACT PEX00001, BEGIN NOW
But the report view and ggserr.log keeps notifying:
2016-08-24 09:11:04 ERROR OGG-00868 Oracle GoldenGate Capture for Oracle, PEX00001.prm: Error code 1291, error message: ORA-01291: missing logfile
(Missing Log File <unknown>. Read Position SCN: Unknown)
How can I restart by EXTRACT Process?
Thanks