Difference between Recovery Checkpoint and Current Checkpoint
edited Jul 25, 2013 9:18AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered ✓
Hi,
When I use INFO <Extract Name> SHOWCH, the Recovery Checkpoint and Current Checkpoint values are the same:
GGSCI (DevServ64-1) 6> info e000001a showchEXTRACT E000001A Last Started 2013-07-23 16:14 Status STOPPEDCheckpoint Lag 00:00:00 (updated 00:14:41 ago)Log Read Checkpoint Oracle Redo Logs2013-07-24 13:35:11 Seqno 201512, RBA 2655232SCN 27.2766446061 (118730563053)Current Checkpoint Detail:Read Checkpoint #1Oracle Redo LogStartup Checkpoint (starting position in the data source):Thread #: 1Sequence #: 200826RBA: 1485840Timestamp: 2013-07-23 15:25:05.000000SCN: 27.2759149410 (118723266402)Redo File: \MYDB\DATABASE\GRP5LOG1.LOGRecovery Checkpoint (position of oldest unprocessed transaction in the data source):Thread #: 1Sequence #: 201512RBA: 2654736Timestamp: 2013-07-24 13:35:11.000000SCN: 27.2766446061 (118730563053)Redo File: \MYDB
0