GGSCI (WG-HOUBANK-DB02 DBLOGIN as root) 33> info ext1 detail
EXTRACTEXT1Last Started 2015-07-21 17:09 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:03 ago)
Process ID 20904
VAM Read Checkpoint2015-07-21 17:00:44.862024
Target Extract Trails:
Trail Name
SeqnoRBA Max MB Trail Type
/ggmysql/dirdat/mb
3 1352100 EXTTRAIL
Extract Source
Begin
End
Not Available
2015-07-21 17:002015-07-21 17:00
Not Available
2015-07-21 17:002015-07-21 17:00
Not Available
* Initialized * 2015-07-21 17:00
Current directory/ggmysql
Report file
/ggmysql/dirrpt/EXT1.rpt
Parameter file /ggmysql/dirprm/ext1.prm
Checkpoint file/ggmysql/dirchk/EXT1.cpe
Process file /ggmysql/dirpcs/EXT1.pce
Error log
/ggmysql/ggserr.log
本帖最后由 vicxu1985 于 2015-7-21 17:07 编辑
GGSCI (WG-HOUBANK-DB02 DBLOGIN as root) 23> info all
Program StatusGroup Lag at ChkptTime Since Chkpt
MANAGER RUNNING
GGSCI (WG-HOUBANK-DB02 DBLOGIN as root) 24>
GGSCI (WG-HOUBANK-DB02 DBLOGIN as root) 24> stats ext1
Sending STATS request to EXTRACT EXT1 ...
No active extraction maps.
GGSCI (WG-HOUBANK-DB02 DBLOGIN as root) 25> stats rep1
ERROR: Invalid command.
GGSCI (WG-HOUBANK-DB02 DBLOGIN as root) 26> stats dp1
Sending STATS request to EXTRACT DP1 ...
No active extraction maps.
GGSCI (WG-HOUBANK-DB02 DBLOGIN as root) 27>
target 端
GGSCI (WG-HOUBANK-DW01) 6> info all
Program StatusGroup Lag at ChkptTime Since Chkpt
MANAGER RUNNING
REPLICATRUNNING REP100:00:0000:00:01
GGSCI (WG-HOUBANK-DW01) 7> stats rep1
Sending STATS request to REPLICAT REP1 ...
No active replication maps.
GGSCI (WG-HOUBANK-DW01) 8> info rep1
REPLICAT REP1Last Started 2015-07-21 17:02 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:09 ago)
Process ID 29313
Log Read CheckpointFile /data/app/oracle/gg11/dirdat/mb000002
2015-07-21 17:01:45.707364RBA 1466
GGSCI (WG-HOUBANK-DW01) 9> info rep1 detail
REPLICAT REP1Last Started 2015-07-21 17:02 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:05 ago)
Process ID 29313
Log Read CheckpointFile /data/app/oracle/gg11/dirdat/mb000002
2015-07-21 17:01:45.707364RBA 1466
Current Log BSN value: (requires database login)
Last Committed Transaction CSN value: (requires database login)
Extract Source
Begin
End
/data/app/oracle/gg11/dirdat/mb000002 2015-07-20 20:162015-07-21 17:01
/data/app/oracle/gg11/dirdat/mb000000 * Initialized * 2015-07-20 20:16
/data/app/oracle/gg11/dirdat/mb000000 * Initialized * First Record
Current directory/data/app/oracle/gg11
Report file
/data/app/oracle/gg11/dirrpt/REP1.rpt
Parameter file /data/app/oracle/gg11/dirprm/rep1.prm
Checkpoint file/data/app/oracle/gg11/dirchk/REP1.cpr
Checkpoint table ogg.checkpointtab
Process file /data/app/oracle/gg11/dirpcs/REP1.pcr
Error log
/data/app/oracle/gg11/ggserr.log