OGG extract process checkpoint time point back to 1988-01-0100:00:00 troubleshooting

The Extract process (SEXTR01) status is running, but LagatChkpt has reached more than five hours, and the time has been increasing. No new logs are extracted. The status information is as follows:

The Extract process (SEXTR01) status is running, but the Lag at Chkpt has reached more than five hours, and the time has been increasing. No new logs are extracted. The status information is as follows:

1. Fault
The Extract process (SEXTR01) status is running, but the Lag at Chkpt has reached more than five hours, and the time has been increasing. No new logs are extracted. The status information is as follows:

GGSCI (caXXadgdb) 21> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

Extract running dpeywgl 00:00:00 00:00:04

Extract running SEXTR01 05:14:58 00:00:03

2. Fault Analysis
2.1 debug process status information
GGSCI (caXXadgdb) 23> info sextr01, showch debug

EXTRACT SEXTR01 Last Started Status RUNNING

Checkpoint Lag 05:21:26 (updated 00:00:04 ago)

Log Read Checkpoint Oracle Redo Logs

18:05:16 Thread 1, Seqno 5554, RBA 611373536

SCN 3126.136656462 (13426204423758)

Log Read Checkpoint Oracle Redo Logs

00:00:00 Thread 2, Seqno 4016, RBA 1024

SCN 44527.110828288 (191242119617280)

Current Checkpoint Detail:

Read Checkpoint #1

......

Read Checkpoint #2

Oracle Threaded Redo Log

Startup Checkpoint (starting position in the data source ):

Thread #: 2

Sequence #: 4015

RBA: 640984080

Timestamp: 18:03:51. 000000

SCN: 3126.136602577 (13426204369873)

Redo File: + DGROUP1/caXXdb/onlinelog/group_15.267.799671_1

Recovery Checkpoint (position of oldest unprocessed transaction in the data source ):

Thread #: 2

Sequence #: 4015

RBA: 640984080

Timestamp: 18:03:51. 000000

SCN: 3126.136602577 (13426204369873)

Redo File: + DGROUP1/caXXdb/onlinelog/group_15.267.799671_1

Current Checkpoint (position of last record read in the data source ):

Thread #: 2

Sequence #: 4016

RBA: 1024

Timestamp: 1988-01-01 00:00:00. 000000

SCN: 44527.110828288 (191242119617280)

Redo File: + DGROUP1/caXXdb/onlinelog/group_16.266.799671_3

......

An incredible problem is found here:

Thread #: The timestamp of the current checkpoint of 2 is 1988-01-0100:00:00. 000000, and the number of SCN decimal digits is 191242119617280, which is far greater than the SCN of the current database and has one more digit.

Time regresses. Instead, the SCN is surging, and the time is so personalized. This question is quite interesting.

2.2 view the report of the extract Process
View report sextr01 is used to view the process report, prompting that there is an ERROR. thread #2 4016 archive log cannot be opened. (Because I did not copy the information, the current status can only be described in this way), but the actual physical file of archivelog No. 4016 exists, and the permissions are normal.

2.3 stop the process and showch its status.
GGSCI (calladgdb) 24> stop sextr01

GGSCI (calladgdb) 25> info SEXTR01, showch

EXTRACT SEXTR01 Last Started Status STOPPED

Checkpoint Lag 06:56:55 (updated 00:00:58 ago)

Log Read Checkpoint Oracle Redo Logs

18:05:16 Thread 1, Seqno 5554, RBA 611373536

SCN 3126.136656462 (13426204423758)

Log Read Checkpoint Oracle Redo Logs

00:00:00 Thread 2, Seqno 4016, RBA 1024

SCN 44527.110828288 (191242119617280)

Current Checkpoint Detail:

Read Checkpoint #1

......

Read Checkpoint #2

Oracle Threaded Redo Log

Startup Checkpoint (starting position in the data source ):

Thread #: 2

Sequence #: 4015

RBA: 640984080

Timestamp: 18:03:51. 000000

SCN: 3126.136602577 (13426204369873)

Redo File: + DGROUP1/caXXdb/onlinelog/group_15.267.799671_1

Recovery Checkpoint (position of oldest unprocessed transaction in the data source ):

Thread #: 2

Sequence #: 4015

RBA: 640984080

Timestamp: 18:03:51. 000000

SCN: 3126.136602577 (13426204369873)

Redo File: + DGROUP1/caXXdb/onlinelog/group_15.267.799671_1

Current Checkpoint (position of last record read in the data source ):

Thread #: 2

Sequence #: 4016

RBA: 1024

Timestamp: 1988-01-01 00:00:00. 000000

SCN: 44527.110828288 (191242119617280)

Redo File: + DGROUP1/caXXdb/onlinelog/group_16.266.799671_3

......