目标效果：ogg源端ext1替换为e1,pum1替换为p1，目标端无需处理，数据不丢失，同步正常
主要步骤如下：
1.先增加推送和抽取进程：
参数参考源配置修改名称如下：
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 172> edit param e1
EXTRACT e1
USERIDALIAS jyc
TRANLOGOPTIONS MININGUSERALIAS mid
TRANLOGOPTIONS INTEGRATEDPARAMS (downstream_real_time_mine Y)
EXTTRAIL ./dirdat/e1
DBOPTIONS ALLOWUNUSEDCOLUMN
GETTRUNCATES
UPDATERECORDFORMAT FULL
fetchoptions nousesnapshot
fetchoptions fetchpkupdatecols
SOURCECATALOG jycdb
TABLE jyc.*;
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 173> edit param p1
extract p1
passthru
rmthost 192.168.207.156, mgrport 7809
dynamicresolution
rmttrail ./dirdat/p1
SOURCECATALOG jycdb
table jyc.*;
2.停止抽取和推送进程，并记录原ext1的scn和pum1的seqno,rba信息
stop ext1
stop pum1
info ext1
info pum1
3.根据原停止信息,修改新e1和p1的位置信息，并启动即可
alter extract e1,scn 2288186
alter extract p1,extseqno 6,extrba 1313
start e1
start p1
info e1
info p1
4.详细的替换处理过程如下：
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 119> DBLOGIN USERIDALIAS jyc
Successfully logged into database CDB$ROOT.
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 120> MININGDBLOGIN USERIDALIAS mid
Successfully logged into mining database.
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 121> register extract e1 database container(jycdb)
2023-06-20 20:19:28 INFO OGG-02003 Extract E1 successfully registered with database at SCN 2287221.
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 122> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED E1 00:00:00 00:03:48
EXTRACT STOPPED EXT1 00:00:00 00:05:07
EXTRACT STOPPED P1 00:00:00 00:05:19
EXTRACT STOPPED PUM1 00:00:00 00:05:04
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 123> start ext1
Sending START request to MANAGER ...
EXTRACT EXT1 starting
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 124> start pum1
Sending START request to MANAGER ...
EXTRACT PUM1 starting
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 125> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED E1 00:00:00 00:03:59
EXTRACT RUNNING EXT1 00:00:00 00:05:18
EXTRACT STOPPED P1 00:00:00 00:05:30
EXTRACT RUNNING PUM1 00:00:00 00:05:15
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 126> delete EXTRACT e1
Deleted EXTRACT E1.
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 127> delete EXTRACT p1
Deleted EXTRACT P1.
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 128> ADD EXTRACT e1, INTEGRATED TRANLOG, BEGIN NOW
EXTRACT (Integrated) added.
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 129> add exttrail ./dirdat/e1,extract e1, MEGABYTES 200
2023-06-20 20:21:45 WARNING OGG-08272 Trail file '/ogg/19c/dirdat/e1000000000' already exists.
EXTTRAIL added.
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 130> add extract p1, EXTTRAILSOURCE ./dirdat/e1
EXTRACT added.
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 131> add rmttrail ./dirdat/p1, ext p1, MEGABYTES 200
RMTTRAIL added.
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 132> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED E1 00:00:00 00:02:01
EXTRACT RUNNING EXT1 00:00:00 00:00:00
EXTRACT STOPPED P1 00:00:00 00:01:52
EXTRACT RUNNING PUM1 00:00:00 00:00:05
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 133> stop ext1
Sending STOP request to EXTRACT EXT1 ...
Request processed.
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 134> stop pum1
Sending STOP request to EXTRACT PUM1 ...
Request processed.
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 135> info ext1
EXTRACT EXT1 Last Started 2023-06-20 20:20 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:08 ago)
Log Read Checkpoint Oracle Integrated Redo Logs
2023-06-20 20:23:48
SCN 0.2288186 (2288186)
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 136> info pum1
EXTRACT PUM1 Last Started 2023-06-20 20:20 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:09 ago)
Log Read Checkpoint File /ogg/19c/dirdat/e1000000006
2023-06-20 20:20:57.547890 RBA 1313
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 137> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED E1 00:00:00 00:06:06
EXTRACT STOPPED EXT1 00:00:00 00:03:53
EXTRACT STOPPED P1 00:00:00 00:05:56
EXTRACT STOPPED PUM1 00:00:00 00:03:48
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 138> info pum1
EXTRACT PUM1 Last Started 2023-06-20 20:20 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:03:56 ago)
Log Read Checkpoint File /ogg/19c/dirdat/e1000000006
2023-06-20 20:20:57.547890 RBA 1313
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 139> info ext1
EXTRACT EXT1 Last Started 2023-06-20 20:20 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:04:03 ago)
Log Read Checkpoint Oracle Integrated Redo Logs
2023-06-20 20:23:48
SCN 0.2288186 (2288186)
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 140> alter extract e1,scn 2288186
EXTRACT altered.
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 141> info e1
EXTRACT E1 Initialized 2023-06-20 20:28 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:02 ago)
Log Read Checkpoint Oracle Integrated Redo Logs
First Record
SCN 0.2288186 (2288186)
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 142> info e1,showch detail
EXTRACT E1 Initialized 2023-06-20 20:28 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:18 ago)
Log Read Checkpoint Oracle Integrated Redo Logs
First Record
SCN 0.2288186 (2288186)
Target Extract Trails:
Trail Name Seqno RBA Max MB Trail Type
./dirdat/e1 0 0 200 EXTTRAIL
Integrated Extract outbound server first scn: 0.2286857 (2286857)
Integrated Extract outbound server filtering start scn: 0.2287221 (2287221)
Extract Source Begin End
Not Available * Initialized * First Record
Not Available * Initialized * 2023-06-20 20:21
Current directory /ogg/19c
Report file /ogg/19c/dirrpt/E1.rpt
Parameter file /ogg/19c/dirprm/e1.prm
Checkpoint file /ogg/19c/dirchk/E1.cpe
Process file
Error log /ogg/19c/ggserr.log
Current Checkpoint Detail:
Read Checkpoint #1
Oracle Integrated Redo Log
Startup Checkpoint (starting position in the data source):
Timestamp:
SCN: 0.2288186 (2288186)
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Timestamp:
SCN: 0.2288186 (2288186)
Current Checkpoint (position of last record read in the data source):
Timestamp:
SCN: 0.2288186 (2288186)
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 0
RBA: 0
Timestamp: 2023-06-20 20:21:45.164028
Extract Trail: ./dirdat/e1
Seqno Length: 6
Flip Seqno Length: Yes
Trail Type: EXTTRAIL
Header:
Version = 2
Record Source = U
Type = 13
# Input Checkpoints = 1
# Output Checkpoints = 1
Configuration:
Data Source = 3
Transaction Integrity = 1
Task Type = 0
Status:
Start Time = 2023-06-20 20:28:25
Last Update Time = 2023-06-20 20:28:25
Stop Status = G
Last Result = 0
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 143> info ext1,showch detail
EXTRACT EXT1 Last Started 2023-06-20 20:20 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:05:09 ago)
Log Read Checkpoint Oracle Integrated Redo Logs
2023-06-20 20:23:48
SCN 0.2288186 (2288186)
Target Extract Trails:
Trail Name Seqno RBA Max MB Trail Type
./dirdat/e1 6 1313 200 EXTTRAIL
Integrated Extract outbound server first scn: 0.2254762 (2254762)
Integrated Extract outbound server filtering start scn: 0.2255121 (2255121)
Extract Source Begin End
Not Available 2023-06-20 19:45 2023-06-20 20:23
Not Available 2023-06-20 19:45 2023-06-20 20:15
Not Available 2023-06-20 19:45 2023-06-20 20:15
Not Available 2023-06-20 19:45 2023-06-20 20:15
Not Available * Initialized * 2023-06-20 19:45
Not Available * Initialized * 2023-06-20 19:45
Not Available * Initialized * 2023-06-20 19:45
Not Available * Initialized * 2023-06-20 19:45
Not Available * Initialized * 2023-06-20 19:45
Not Available * Initialized * 2023-06-20 19:45
Not Available * Initialized * 2023-06-20 19:45
Not Available * Initialized * First Record
Not Available * Initialized * First Record
Not Available * Initialized * First Record
Not Available 2023-06-20 16:54 2023-06-20 19:29
Not Available 2023-06-20 16:54 2023-06-20 19:23
Not Available 2023-06-20 16:54 2023-06-20 19:23
Not Available 2023-06-20 16:54 2023-06-20 19:23
Not Available 2023-06-20 16:54 2023-06-20 17:12
Not Available 2023-06-20 16:54 2023-06-20 17:12
Not Available 2023-06-20 16:54 2023-06-20 17:12
Not Available * Initialized * 2023-06-20 16:54
Not Available * Initialized * 2023-06-20 16:54
Not Available * Initialized * 2023-06-20 16:54
Current directory /ogg/19c
Report file /ogg/19c/dirrpt/EXT1.rpt
Parameter file /ogg/19c/dirprm/ext1.prm
Checkpoint file /ogg/19c/dirchk/EXT1.cpe
Process file
Error log /ogg/19c/ggserr.log
Current Checkpoint Detail:
Read Checkpoint #1
Oracle Integrated Redo Log
Startup Checkpoint (starting position in the data source):
Timestamp: 2023-06-20 19:45:33.000000
SCN: 0.0 (0)
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Timestamp: 2023-06-20 20:23:48.000000
SCN: 0.2288186 (2288186)
Current Checkpoint (position of last record read in the data source):
Timestamp: 2023-06-20 20:23:48.000000
SCN: 0.2288186 (2288186)
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 6
RBA: 1313
Timestamp: 2023-06-20 20:23:52.762241
Extract Trail: ./dirdat/e1
Seqno Length: 9
Flip Seqno Length: No
Trail Type: EXTTRAIL
Header:
Version = 2
Record Source = A
Type = 18
# Input Checkpoints = 1
# Output Checkpoints = 1
Configuration:
Data Source = 3
Transaction Integrity = 1
Task Type = 0
Status:
Start Time = 2023-06-20 20:20:57
Last Update Time = 2023-06-20 20:23:52
Stop Status = G
Last Result = 400
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 144>
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 144> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED E1 00:00:00 00:01:54
EXTRACT STOPPED EXT1 00:00:00 00:06:26
EXTRACT STOPPED P1 00:00:00 00:08:29
EXTRACT STOPPED PUM1 00:00:00 00:06:21
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 145> start e1
Sending START request to MANAGER ...
EXTRACT E1 starting
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 146> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING E1 00:00:00 00:02:00
EXTRACT STOPPED EXT1 00:00:00 00:06:32
EXTRACT STOPPED P1 00:00:00 00:08:36
EXTRACT STOPPED PUM1 00:00:00 00:06:28
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 147> info e1
EXTRACT E1 Initialized 2023-06-20 20:28 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:02:04 ago)
Process ID 29448
Log Read Checkpoint Oracle Integrated Redo Logs
First Record
SCN 0.2288186 (2288186)
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 148> info e1
EXTRACT E1 Last Started 2023-06-20 20:30 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:02 ago)
Process ID 29448
Log Read Checkpoint Oracle Integrated Redo Logs
2023-06-20 20:30:36
SCN 0.2289452 (2289452)
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 149> info e1,showch detail
EXTRACT E1 Last Started 2023-06-20 20:30 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:05 ago)
Process ID 29448
Log Read Checkpoint Oracle Integrated Redo Logs
2023-06-20 20:30:47
SCN 0.2289488 (2289488)
Target Extract Trails:
Trail Name Seqno RBA Max MB Trail Type
./dirdat/e1 7 1923 200 EXTTRAIL
Integrated Extract outbound server first scn: 0.2286857 (2286857)
Integrated Extract outbound server filtering start scn: 0.2287221 (2287221)
Extract Source Begin End
Not Available * Initialized * 2023-06-20 20:30
Not Available * Initialized * First Record
Not Available * Initialized * First Record
Not Available * Initialized * First Record
Not Available * Initialized * 2023-06-20 20:21
Current directory /ogg/19c
Report file /ogg/19c/dirrpt/E1.rpt
Parameter file /ogg/19c/dirprm/e1.prm
Checkpoint file /ogg/19c/dirchk/E1.cpe
Process file
Error log /ogg/19c/ggserr.log
Current Checkpoint Detail:
Read Checkpoint #1
Oracle Integrated Redo Log
Startup Checkpoint (starting position in the data source):
Timestamp:
SCN: 0.2288186 (2288186)
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Timestamp: 2023-06-20 20:30:47.000000
SCN: 0.2289488 (2289488)
Current Checkpoint (position of last record read in the data source):
Timestamp: 2023-06-20 20:30:47.000000
SCN: 0.2289488 (2289488)
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 7
RBA: 1923
Timestamp: 2023-06-20 20:30:50.484042
Extract Trail: ./dirdat/e1
Seqno Length: 9
Flip Seqno Length: No
Trail Type: EXTTRAIL
Header:
Version = 2
Record Source = A
Type = 18
# Input Checkpoints = 1
# Output Checkpoints = 1
Configuration:
Data Source = 3
Transaction Integrity = 1
Task Type = 0
Status:
Start Time = 2023-06-20 20:30:30
Last Update Time = 2023-06-20 20:30:50
Stop Status = A
Last Result = 400
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 150>
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 152> info pum1,showch detail
EXTRACT PUM1 Last Started 2023-06-20 20:20 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:07:50 ago)
Log Read Checkpoint File /ogg/19c/dirdat/e1000000006
2023-06-20 20:20:57.547890 RBA 1313
Target Extract Trails:
Trail Name Seqno RBA Max MB Trail Type
./dirdat/p1 1 1405 200 RMTTRAIL
Extract Source Begin End
/ogg/19c/dirdat/e1000000006 2023-06-20 19:50 2023-06-20 20:20
/ogg/19c/dirdat/e1000000005 * Initialized * 2023-06-20 19:50
./dirdat/e1000000000 * Initialized * First Record
Current directory /ogg/19c
Report file /ogg/19c/dirrpt/PUM1.rpt
Parameter file /ogg/19c/dirprm/pum1.prm
Checkpoint file /ogg/19c/dirchk/PUM1.cpe
Process file
Error log /ogg/19c/ggserr.log
Current Checkpoint Detail:
Read Checkpoint #1
GGS Log Trail
Startup Checkpoint (starting position in the data source):
Sequence #: 5
RBA: 1800
Timestamp: 2023-06-20 19:50:40.000000
Extract Trail: /ogg/19c/dirdat/e1
Seqno Length: 9
Current Checkpoint (position of last record read in the data source):
Sequence #: 6
RBA: 1313
Timestamp: 2023-06-20 20:20:57.547890
Extract Trail: /ogg/19c/dirdat/e1
Seqno Length: 9
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 1
RBA: 1405
Timestamp: 2023-06-20 20:23:57.628516
Extract Trail: ./dirdat/p1
Seqno Length: 9
Flip Seqno Length: No
Trail Type: RMTTRAIL
Header:
Version = 2
Record Source = A
Type = 1
# Input Checkpoints = 1
# Output Checkpoints = 1
Configuration:
Data Source = 0
Transaction Integrity = 1
Task Type = 0
Status:
Start Time = 2023-06-20 20:20:41
Last Update Time = 2023-06-20 20:23:57
Stop Status = G
Last Result = 400
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 153>
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 153> info pum1
EXTRACT PUM1 Last Started 2023-06-20 20:20 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:08:25 ago)
Log Read Checkpoint File /ogg/19c/dirdat/e1000000006
2023-06-20 20:20:57.547890 RBA 1313
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 154> info p1
EXTRACT P1 Initialized 2023-06-20 20:21 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:10:36 ago)
Log Read Checkpoint File ./dirdat/e1000000000
First Record RBA 0
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 157> alter extract p1,extseqno 6,extrba 1313
EXTRACT altered.
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 158> info p1
EXTRACT P1 Initialized 2023-06-20 20:33 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:05 ago)
Log Read Checkpoint File ./dirdat/e1000000006
First Record RBA 1313
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 159> info p1,showch detail
EXTRACT P1 Initialized 2023-06-20 20:33 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:19 ago)
Log Read Checkpoint File ./dirdat/e1000000006
First Record RBA 1313
Target Extract Trails:
Trail Name Seqno RBA Max MB Trail Type
./dirdat/p1 0 0 200 RMTTRAIL
Extract Source Begin End
./dirdat/e1000000006 * Initialized * First Record
./dirdat/e1000000000 * Initialized * First Record
Current directory /ogg/19c
Report file /ogg/19c/dirrpt/P1.rpt (does not yet exist)
Parameter file /ogg/19c/dirprm/p1.prm
Checkpoint file /ogg/19c/dirchk/P1.cpe
Process file
Error log /ogg/19c/ggserr.log
Current Checkpoint Detail:
Read Checkpoint #1
GGS Log Trail
Startup Checkpoint (starting position in the data source):
Sequence #: 6
RBA: 1313
Timestamp: Not Available
Extract Trail: ./dirdat/e1
Seqno Length: 9
Current Checkpoint (position of last record read in the data source):
Sequence #: 6
RBA: 1313
Timestamp: Not Available
Extract Trail: ./dirdat/e1
Seqno Length: 9
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 0
RBA: 0
Timestamp: 2023-06-20 20:21:55.196369
Extract Trail: ./dirdat/p1
Seqno Length: 6
Flip Seqno Length: Yes
Trail Type: RMTTRAIL
Header:
Version = 2
Record Source = U
Type = 1
# Input Checkpoints = 1
# Output Checkpoints = 1
Configuration:
Data Source = 0
Transaction Integrity = 1
Task Type = 0
Status:
Start Time = 2023-06-20 20:33:49
Last Update Time = 2023-06-20 20:33:49
Stop Status = G
Last Result = 0
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 160> start p1
Sending START request to MANAGER ...
EXTRACT P1 starting
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 161> info p1
EXTRACT P1 Last Started 2023-06-20 20:34 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:31 ago)
Process ID 29670
Log Read Checkpoint File /ogg/19c/dirdat/e1000000006
First Record RBA 1313
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 162> info p1
EXTRACT P1 Last Started 2023-06-20 20:34 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:04 ago)
Process ID 29670
Log Read Checkpoint File /ogg/19c/dirdat/e1000000006
First Record RBA 1313
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 163> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING E1 00:00:00 00:00:01
EXTRACT STOPPED EXT1 00:00:00 00:10:41
EXTRACT RUNNING P1 00:00:00 00:00:00
EXTRACT STOPPED PUM1 00:00:00 00:10:36
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 164> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING E1 00:00:00 00:00:03
EXTRACT STOPPED EXT1 00:00:00 00:11:34
EXTRACT RUNNING P1 00:00:00 00:00:04
EXTRACT STOPPED PUM1 00:00:00 00:11:29
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 165> info pum1
EXTRACT PUM1 Last Started 2023-06-20 20:20 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:12:00 ago)
Log Read Checkpoint File /ogg/19c/dirdat/e1000000006
2023-06-20 20:20:57.547890 RBA 1313
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 166> info p1
EXTRACT P1 Last Started 2023-06-20 20:34 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:09 ago)
Process ID 29670
Log Read Checkpoint File /ogg/19c/dirdat/e1000000007
2023-06-20 20:35:15.000000 RBA 2051
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 167> info e1
EXTRACT E1 Last Started 2023-06-20 20:30 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:00 ago)
Process ID 29448
Log Read Checkpoint Oracle Integrated Redo Logs
2023-06-20 20:36:02
SCN 0.2290208 (2290208)
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 168> info ext1
EXTRACT EXT1 Last Started 2023-06-20 20:20 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:12:16 ago)
Log Read Checkpoint Oracle Integrated Redo Logs
2023-06-20 20:23:48
SCN 0.2288186 (2288186)
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 169> delete pum1
Deleted EXTRACT PUM1.
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 170> delete ext1
Deleted EXTRACT EXT1.
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 171> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING E1 00:00:00 00:00:00
EXTRACT RUNNING P1 00:00:00 00:00:03
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 172>
相关参考：
https://blog.51cto.com/u_3557740/4843858
https://docs.oracle.com/goldengate/c1230/gg-winux/GGODB/configuring-downstream-mining-database.htm#GGODB-GUID-04B25BAE-9A99-416C-8778-20357138A732
https://www.cnblogs.com/zhugablog/p/8488081.html
最后修改时间：2023-06-21 12:40:27
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
