GGSCI (dbsrv1) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EPCS07 00:48:12 00:00:08
Failed to get next ts for EXTRACT PPCS07 (error 109, Invalid pointer retrieving GGS logtrail timestamp in )
GGSCI (ndhdbp4) 3> info *
EXTRACT EPCS07 Last Started 2013-08-20 14:05 Status RUNNING
Checkpoint Lag 00:57:05 (updated 00:00:10 ago)
Log Read Checkpoint Oracle Redo Logs
2013-08-20 14:19:58 Thread 1, Seqno 34114, RBA 1065005856
SCN 69.2532298994 (298885042418)
Log Read Checkpoint Oracle Redo Logs
2013-08-20 14:20:00 Thread 2, Seqno 33665, RBA 268387208
SCN 69.2532299819 (298885043243)
EXTRACT PPCS07 Last Started 2013-08-20 15:02 Status RUNNING
ERROR: Error retrieving current checkpoint timestamp.
That message keeps coming for every Extract process we run so thought of nailing it down to see whats causing this message to popup when the Extract and Pump process is running fine.
Well, the reason was simple:
When creating Pump process, we used "Threads 2" (just like for Extract process) and that "Threads 2" option is not valid with Pump process. Thats why we were getting this message.
As you see "info *" also errors out when it tries to show info for thread 2.
Recreate the pump process without this parameter and you wont see this coming up again...
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EPCS07 00:48:12 00:00:08
Failed to get next ts for EXTRACT PPCS07 (error 109, Invalid pointer retrieving GGS logtrail timestamp in )
GGSCI (ndhdbp4) 3> info *
EXTRACT EPCS07 Last Started 2013-08-20 14:05 Status RUNNING
Checkpoint Lag 00:57:05 (updated 00:00:10 ago)
Log Read Checkpoint Oracle Redo Logs
2013-08-20 14:19:58 Thread 1, Seqno 34114, RBA 1065005856
SCN 69.2532298994 (298885042418)
Log Read Checkpoint Oracle Redo Logs
2013-08-20 14:20:00 Thread 2, Seqno 33665, RBA 268387208
SCN 69.2532299819 (298885043243)
EXTRACT PPCS07 Last Started 2013-08-20 15:02 Status RUNNING
ERROR: Error retrieving current checkpoint timestamp.
Well, the reason was simple:
When creating Pump process, we used "Threads 2" (just like for Extract process) and that "Threads 2" option is not valid with Pump process. Thats why we were getting this message.
As you see "info *" also errors out when it tries to show info for thread 2.
Recreate the pump process without this parameter and you wont see this coming up again...
No comments:
Post a Comment