1.切換到oracle用戶，進(jìn)入到goldengate的安裝目錄。

2.查看進(jìn)程的運行狀況：

GGSCI (pxpaddb1) 1> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING EXTRACT RUNNING DPEXPAD 00:00:00 00:00:08 EXTRACT RUNNING DPEXPAD2 00:00:00 00:00:04 --投遞進(jìn)程 EXTRACT RUNNING EXTXPAD 00:00:02 00:00:09 --抽取進(jìn)程 EXTRACT RUNNING EXTXPAD2 00:00:01 00:00:09 REPLICAT RUNNING REPRPT 00:00:00 00:00:04

3.查看進(jìn)程參數(shù)信息

GGSCI (pxpaddb1) 18> view params EXTXPAD --view params groupExtract extxpad USERID goldengate@XPADDB, PASSWORD goldengate warnlongtrans 12h, checkinterval 10m --tranlogoptions rawdeviceoffset 0 --TRANLOGOPTIONS CONVERTUCS2CLOBS --THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 3000 IOLATENCY 3000 --TranlogOptions ASMUSER sys@ASM, ASMPASSWORD Oracle123 TRANLOGOPTIONS DBLOGREADER--tranlogoptions altarchivelogdest primary instance XPADDB1 /arch, altarchivelogdest instance XPADDB1 /arch, altarchivelogdes t instance XPADDB2 /arch --tranlogoptions altarchivedlogformat instance XPADDB1 %t_%s_%r.dbf --tranlogoptions altarchivedlogformat instance XPADDB2 %t_%s_%r.dbf

4.查看進(jìn)程正在讀取的文件

GGSCI (pxpaddb1) 21> info extract EXTXPAD,showchEXTRACT EXTXPAD Last Started 2018-08-11 20:33 Status RUNNING Checkpoint Lag 00:00:01 (updated 00:00:07 ago) Process ID 27787578 Log Read Checkpoint Oracle Redo Logs2018-08-21 14:17:45 Thread 1, Seqno 51694, RBA 170517296SCN 1415.2876303350 (6080255027190) Log Read Checkpoint Oracle Redo Logs2018-08-21 14:17:46 Thread 2, Seqno 39994, RBA 532338192SCN 1415.2876305473 (6080255029313)Current Checkpoint Detail:Read Checkpoint #1Oracle Threaded Redo LogStartup Checkpoint (starting position in the data source):Thread #: 1Sequence #: 49829RBA: 237193232Timestamp: 2018-08-11 19:58:38.000000SCN: 1415.2182025043 (6079560748883)Redo File: +XPADDG/xpadadg/onlinelog/group_1.480.929619589Recovery Checkpoint (position of oldest unprocessed transaction in the data source):Thread #: 1Sequence #: 51691RBA: 196478480Timestamp: 2018-08-21 14:00:32.000000SCN: 1415.2874644065 (6080253367905)Redo File: Not AvailableCurrent Checkpoint (position of last record read in the data source):Thread #: 1Sequence #: 51694RBA: 170517296Timestamp: 2018-08-21 14:17:45.000000SCN: 1415.2876303350 (6080255027190)Redo File: Not AvailableBR Previous Recovery Checkpoint:Thread #: 1Sequence #: 0RBA: 0Timestamp: 2018-08-11 20:33:42.479286SCN: Not availableRedo File: BR Begin Recovery Checkpoint:Thread #: 1Sequence #: 51677RBA: 201504784Timestamp: 2018-08-21 11:49:55.000000SCN: 1415.2867329996 (6080246053836)Redo File: BR End Recovery Checkpoint:Thread #: 1Sequence #: 51687RBA: 40715468Timestamp: 2018-08-21 12:37:39.000000SCN: 1415.2870483139 (6080249206979)Redo File: Read Checkpoint #2Oracle Threaded Redo LogStartup Checkpoint (starting position in the data source):Thread #: 2Sequence #: 38987RBA: 12691984Timestamp: 2018-08-11 19:58:45.000000SCN: 1415.2182025469 (6079560749309)Redo File: +XPADDG/xpadadg/onlinelog/group_7.430.929619597Recovery Checkpoint (position of oldest unprocessed transaction in the data source):Thread #: 2Sequence #: 39908RBA: 237699088Timestamp: 2018-08-20 16:42:20.000000SCN: 1415.2804907070 (6080183630910)Redo File: Not AvailableCurrent Checkpoint (position of last record read in the data source):Thread #: 2Sequence #: 39994RBA: 532338192Timestamp: 2018-08-21 14:17:46.000000SCN: 1415.2876305473 (6080255029313)Redo File: +XPADDG/xpadadg/onlinelog/group_4.449.929619593BR Previous Recovery Checkpoint:Thread #: 2Sequence #: 0RBA: 0Timestamp: 2018-08-11 20:33:42.479286SCN: Not availableRedo File: BR Begin Recovery Checkpoint:Thread #: 2Sequence #: 39980RBA: 546082320Timestamp: 2018-08-21 10:53:04.000000SCN: 1415.2861763125 (6080240486965)Redo File: BR End Recovery Checkpoint:Thread #: 2Sequence #: 39990RBA: 469438992Timestamp: 2018-08-21 12:37:40.000000SCN: 1415.2870483300 (6080249207140)Redo File: Write Checkpoint #1GGS Log TrailCurrent Checkpoint (current write position):Sequence #: 10386RBA: 129905207Timestamp: 2018-08-21 14:17:47.557203Extract Trail: ./dirdat/xpSeqno Length: 6Flip Seqno Length: NoTrail Type: EXTTRAILHeader:Version = 2Record Source = AType = 11# Input Checkpoints = 2# Output Checkpoints = 1File Information:Block Size = 2048Max Blocks = 100Record Length = 4096Current Offset = 0Configuration:Data Source = 3Transaction Integrity = 1Task Type = 0Status:Start Time = 2018-08-11 20:33:44Last Update Time = 2018-08-21 14:17:47Stop Status = ALast Result = 0GGSCI (pxpaddb1) 22>

5.查看表上的事務(wù)統(tǒng)計信息

GSCI (pxpaddb1) 30> stats extract EXTXPAD2,table xpad.XPADC_CORP_DEALLOGSending STATS request to EXTRACT EXTXPAD2 ...Start of Statistics at 2018-08-21 15:24:13.Output to ./dirdat/ek:Extracting from XPAD.XPADC_CORP_DEALLOG to XPAD.XPADC_CORP_DEALLOG:*** Total statistics since 2018-08-11 20:38:50 ***Total inserts 1076.00Total updates 6324.00Total deletes 0.00Total discards 0.00Total operations 7400.00*** Daily statistics since 2018-08-21 00:00:00 ***Total inserts 136.00Total updates 608.00Total deletes 0.00Total discards 0.00Total operations 744.00*** Hourly statistics since 2018-08-21 15:00:00 ***Total inserts 17.00Total updates 141.00Total deletes 0.00Total discards 0.00Total operations 158.00*** Latest statistics since 2018-08-21 15:23:46 ***Total inserts 0.00Total updates 9.00Total deletes 0.00Total discards 0.00Total operations 9.00End of Statistics.

?

轉(zhuǎn)載于:https://www.cnblogs.com/dayu-liu/p/9521726.html

總結(jié)

以上是生活随笔為你收集整理的Ogg入门--基本命令的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。