ogg查看源端trail文件位置的方法
(1)> info extfull showch
(2)> view params extfull
GGSCI (rac1) 7> info extfull showch
EXTRACT EXTFULL Last Started 2018-01-14 12:16 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:06 ago)
Log Read Checkpoint Oracle Redo Logs
2018-01-15 11:01:36 Thread 1, Seqno 39, RBA 38766080
SCN 0.1778948 (1778948)
Log Read Checkpoint Oracle Redo Logs
2018-01-13 15:33:00 Thread 2, Seqno 0, RBA 0
SCN 0.0 (0)
Current Checkpoint Detail:
Read Checkpoint #1
Oracle Threaded Redo Log
Startup Checkpoint (starting position in the data source):
Thread #: 1
Sequence #: 35
RBA: 33646608
Timestamp: 2018-01-14 12:03:26.000000
SCN: 0.1669222 (1669222)
Redo File: +DATA/orcl/onlinelog/group_1.261.964904849
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 1
Sequence #: 39
RBA: 38765584
Timestamp: 2018-01-15 11:01:36.000000
SCN: 0.1778948 (1778948)
Redo File: +DATA/orcl/onlinelog/group_1.261.964904849
Current Checkpoint (position of last record read in the data source):
Thread #: 1
Sequence #: 39
RBA: 38766080
Timestamp: 2018-01-15 11:01:36.000000
SCN: 0.1778948 (1778948)
Redo File: +DATA/orcl/onlinelog/group_1.261.964904849
BR Previous Recovery Checkpoint:
Thread #: 1
Sequence #: 0
RBA: 0
Timestamp: 2018-01-14 12:16:21.340292
SCN: Not available
Redo File:
BR Begin Recovery Checkpoint:
Thread #: 1
Sequence #: 39
RBA: 28401664
Timestamp: 2018-01-15 08:16:44.000000
SCN: 0.1767630 (1767630)
Redo File:
BR End Recovery Checkpoint:
Thread #: 1
Sequence #: 39
RBA: 28401664
Timestamp: 2018-01-15 08:16:44.000000
SCN: 0.1767630 (1767630)
Redo File:
Read Checkpoint #2
Oracle Threaded Redo Log
Startup Checkpoint (starting position in the data source):
Thread #: 2
Sequence #: 0
RBA: 0
Timestamp: 2018-01-13 15:33:00.000000
SCN: Not available
Redo File:
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 2
Sequence #: 0
RBA: 0
Timestamp: 2018-01-13 15:33:00.000000
SCN: Not available
Redo File:
Current Checkpoint (position of last record read in the data source):
Thread #: 2
Sequence #: 0
RBA: 0
Timestamp: 2018-01-13 15:33:00.000000
SCN: Not available
Redo File:
BR Previous Recovery Checkpoint:
Thread #: 2
Sequence #: 0
RBA: 0
Timestamp: 2018-01-14 12:16:21.340292
SCN: Not available
Redo File:
BR Begin Recovery Checkpoint:
Thread #: 2
Sequence #: 0
RBA: 0
Timestamp:
SCN: Not available
Redo File:
BR End Recovery Checkpoint:
Thread #: 2
Sequence #: 0
RBA: 0
Timestamp:
SCN: Not available
Redo File:
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 8
RBA: 12230
Timestamp: 2018-01-15 11:01:38.766557
Extract Trail: /ogg/dirdat/sd
Trail Type: EXTTRAIL
Header:
Version = 2
Record Source = A
Type = 11
# Input Checkpoints = 2
# Output Checkpoints = 1
File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 4096
Current Offset = 0
Configuration:
Data Source = 3
Transaction Integrity = 1
Task Type = 0
Status:
Start Time = 2018-01-14 12:16:24
Last Update Time = 2018-01-15 11:01:38
Stop Status = A
Last Result = 400
或者直接查看参数文件:
GGSCI (rac1) 8> view params extfull
extract extfull
setenv ( NLS_LANG = " AMERICAN_AMERICA.ZHS16GBK " )
TRANLOGOPTIONS ASMUSER SYS@ASM1, ASMPASSWORD oracle
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 80000 IOLATENCY 160000
DBOPTIONS ALLOWUNUSEDCOLUMN
userid goldengate, password oracleoracle
ddl include mapped
ddloptions addtrandata RETRYOP MAXRETRIES 1000 RETRYDELAY 10, REPORT
WARNLONGTRANS 1h, CHECKINTERVAL 5m
exttrail /ogg/dirdat/sd
gettruncates
dynamicresolution
table TEST.a;
table TEST.b;
sequence TEST.seq3;
从源端确认目标端的trail文件位置:
GGSCI (rac1) 9> view params dpfull
extract dpfull
passthru
rmthost 192.168.80.242, mgrport 7809
rmttrail /ogg/dirdat/td
gettruncates
table TEST.a;
table TEST.b;
sequence TEST.seq3;
(1)> info extfull showch
(2)> view params extfull
GGSCI (rac1) 7> info extfull showch
EXTRACT EXTFULL Last Started 2018-01-14 12:16 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:06 ago)
Log Read Checkpoint Oracle Redo Logs
2018-01-15 11:01:36 Thread 1, Seqno 39, RBA 38766080
SCN 0.1778948 (1778948)
Log Read Checkpoint Oracle Redo Logs
2018-01-13 15:33:00 Thread 2, Seqno 0, RBA 0
SCN 0.0 (0)
Current Checkpoint Detail:
Read Checkpoint #1
Oracle Threaded Redo Log
Startup Checkpoint (starting position in the data source):
Thread #: 1
Sequence #: 35
RBA: 33646608
Timestamp: 2018-01-14 12:03:26.000000
SCN: 0.1669222 (1669222)
Redo File: +DATA/orcl/onlinelog/group_1.261.964904849
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 1
Sequence #: 39
RBA: 38765584
Timestamp: 2018-01-15 11:01:36.000000
SCN: 0.1778948 (1778948)
Redo File: +DATA/orcl/onlinelog/group_1.261.964904849
Current Checkpoint (position of last record read in the data source):
Thread #: 1
Sequence #: 39
RBA: 38766080
Timestamp: 2018-01-15 11:01:36.000000
SCN: 0.1778948 (1778948)
Redo File: +DATA/orcl/onlinelog/group_1.261.964904849
BR Previous Recovery Checkpoint:
Thread #: 1
Sequence #: 0
RBA: 0
Timestamp: 2018-01-14 12:16:21.340292
SCN: Not available
Redo File:
BR Begin Recovery Checkpoint:
Thread #: 1
Sequence #: 39
RBA: 28401664
Timestamp: 2018-01-15 08:16:44.000000
SCN: 0.1767630 (1767630)
Redo File:
BR End Recovery Checkpoint:
Thread #: 1
Sequence #: 39
RBA: 28401664
Timestamp: 2018-01-15 08:16:44.000000
SCN: 0.1767630 (1767630)
Redo File:
Read Checkpoint #2
Oracle Threaded Redo Log
Startup Checkpoint (starting position in the data source):
Thread #: 2
Sequence #: 0
RBA: 0
Timestamp: 2018-01-13 15:33:00.000000
SCN: Not available
Redo File:
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 2
Sequence #: 0
RBA: 0
Timestamp: 2018-01-13 15:33:00.000000
SCN: Not available
Redo File:
Current Checkpoint (position of last record read in the data source):
Thread #: 2
Sequence #: 0
RBA: 0
Timestamp: 2018-01-13 15:33:00.000000
SCN: Not available
Redo File:
BR Previous Recovery Checkpoint:
Thread #: 2
Sequence #: 0
RBA: 0
Timestamp: 2018-01-14 12:16:21.340292
SCN: Not available
Redo File:
BR Begin Recovery Checkpoint:
Thread #: 2
Sequence #: 0
RBA: 0
Timestamp:
SCN: Not available
Redo File:
BR End Recovery Checkpoint:
Thread #: 2
Sequence #: 0
RBA: 0
Timestamp:
SCN: Not available
Redo File:
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 8
RBA: 12230
Timestamp: 2018-01-15 11:01:38.766557
Extract Trail: /ogg/dirdat/sd
Trail Type: EXTTRAIL
Header:
Version = 2
Record Source = A
Type = 11
# Input Checkpoints = 2
# Output Checkpoints = 1
File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 4096
Current Offset = 0
Configuration:
Data Source = 3
Transaction Integrity = 1
Task Type = 0
Status:
Start Time = 2018-01-14 12:16:24
Last Update Time = 2018-01-15 11:01:38
Stop Status = A
Last Result = 400
或者直接查看参数文件:
GGSCI (rac1) 8> view params extfull
extract extfull
setenv ( NLS_LANG = " AMERICAN_AMERICA.ZHS16GBK " )
TRANLOGOPTIONS ASMUSER SYS@ASM1, ASMPASSWORD oracle
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 80000 IOLATENCY 160000
DBOPTIONS ALLOWUNUSEDCOLUMN
userid goldengate, password oracleoracle
ddl include mapped
ddloptions addtrandata RETRYOP MAXRETRIES 1000 RETRYDELAY 10, REPORT
WARNLONGTRANS 1h, CHECKINTERVAL 5m
exttrail /ogg/dirdat/sd
gettruncates
dynamicresolution
table TEST.a;
table TEST.b;
sequence TEST.seq3;
从源端确认目标端的trail文件位置:
GGSCI (rac1) 9> view params dpfull
extract dpfull
passthru
rmthost 192.168.80.242, mgrport 7809
rmttrail /ogg/dirdat/td
gettruncates
table TEST.a;
table TEST.b;
sequence TEST.seq3;