|
ew report ext1
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:42:16
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Starting at 2015-03-03 21:20:41
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Wed Jun 13 18:24:36 EDT 2012, Release 2.6.32-279.el6.x86_64
Node: zbdba1
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 1839
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2015-03-03 21:20:41 INFO OGG-03035 Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
EXTRACT EXT1
setenv ( NLS_LANG = AMERICAN_AMERICA.ZHS16GBK )
Set environment variable (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
USERID ogg,PASSWORD ***
DDL INCLUDE MAPPED OBJTYPE 'TABLE' INCLUDE MAPPED OBJTYPE 'IDNEX' INCLUDE MAPPED OBJTYPE 'SEQUENCE' INCLUDE MAPPED OBJTYPE 'VIEW' INCLUDE MAPPED OBJTYPE 'PROCEDURE' IN
CLUDE MAPPED OBJTYPE 'FUNCTION' INCLUDE MAPPED OBJTYPE 'PACKAGE' INCLUDE MAPPED OBJTYPE 'MATERIALIZED VIEW' EXCLUDE OPTYPE COMMENT
DDLOPTIONS ADDTRANDATA NOCROSSRENAME REPORT
GGSCI (zbdba1) 47> send mgr childstatus
Sending CHILDSTATUS request to MANAGER ...
Child Process Status - 2 Entries
ID Group Process Retry Retry Time Start Time
---- -------- --------- ----- ------------------- -------------------
0 EXT1 1839 0 None 2015/03/03 21:19:38
1 EXT2 1848 0 None 2015/03/03 21:20:56
GGSCI (zbdba1) 48> info extract ext1,showch
EXTRACT EXT1 Last Started 2015-03-03 21:20 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:04 ago)
Log Read Checkpoint Oracle Redo Logs
2015-03-03 21:45:44 Seqno 48, RBA 22211584
SCN 0.1296506 (1296506)
Current Checkpoint Detail:
Read Checkpoint #1
Oracle Redo Log
Startup Checkpoint (starting position in the data source):
Thread #: 1
Sequence #: 47
RBA: 33336336
Timestamp: 2015-03-03 21:20:22.000000
SCN: Not available
Redo File:
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 1
Sequence #: 48
RBA: 22211088
Timestamp: 2015-03-03 21:45:44.000000
SCN: 0.1296506 (1296506)
Redo File: /opt/oracle/oradata/orcl11g/redo03.log
Current Checkpoint (position of last record read in the data source):
Thread #: 1
Sequence #: 48
RBA: 22211584
Timestamp: 2015-03-03 21:45:44.000000
SCN: 0.1296506 (1296506)
Redo File: /opt/oracle/oradata/orcl11g/redo03.log
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 0
RBA: 0
Timestamp: 2015-03-03 21:20:22.216536
Extract Trail: /ogg/dirdat/sa
Write Checkpoint #2
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 0
RBA: 54236007
Timestamp: 2015-03-03 21:46:38.082286
Extract Trail: ./dirdat/sa
CSN state information:
CRC: 43-DD-D5-AF
Latest CSN: 1296177
Latest TXN: 5.8.1011
Latest CSN of finished TXNs: 1296177
Completed TXNs: 5.8. |