Recently i was asked how to know if my extract is classic extract or integrated extract, here is how we can know about it
If below output is Oracle Integrated Redo Logs for Log Read Checkpoint then it is integrated extract
GGSCI (node7.example.com as gguser@orcl) 78> info extract extcap
EXTRACT extcap Last Started 2016-06-01 23:39 Status STOPPED
Checkpoint Lag 00:00:04 (updated 00:05:43 ago)
Log Read Checkpoint Oracle Integrated Redo Logs
2016-06-02 00:47:48
SCN 0.2037575 (2037575)
If below output if it is Oracle Redo Logs for Log Read Checkpoint then it is classic extract
GGSCI (node7.example.com as gguser@orcl) 79> info ext2
EXTRACT EXT2 Last Started 2016-06-02 00:50 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:05 ago)
Process ID 14091
Log Read Checkpoint Oracle Redo Logs
2016-06-02 00:53:10 Seqno 35, RBA 10232832
SCN 0.2038468 (2038468)
No comments:
Post a Comment