Shulou(Shulou.com)06/01 Report--

In a charging system, the monitoring alarm shows that the ogg process is abnormal. Colleagues log in to the system to check to confirm that the ogg process stopped abnormally.

Check ggserr.log and find that there is an alarm for undo tablespace, followed by an abnormal stop of ABENDING

2017-07-05 10:28:27 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rep1upay.prm: Repositioning to rba 19306043 in seqno 110291.

2017-07-05 10:28:28 ERROR OGG-00868 Oracle GoldenGate Delivery for Oracle, rep3upay.prm: OCI Error ORA-30036: unable to extend segment by 8 in undo tab

Lespace 'UNDOTBS1' (status = 30036). Updating checkpoint table ggs.rep3upay, group 'REP3UPAY', key 666611345 (0x27bbae91), SQL.

2017-07-05 10:28:28 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep3upay.prm: PROCESS ABENDING.

2017-07-05 10:41:17 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep7upay.prm: PROCESS ABENDING.

The error is so weird that there is only one wrong message. There is no other useful information.

It is true that the undo tablespace has been utilized at 100%. Add

Wed Jul 05 10:59:12 CST 2017

Alter tablespace UNDOTBS1 add datafile'/ ora/npf/undotbs01_03.dbf' size 10g autoextend off

Restart the replication process, but still can't get up, it seems that there are some things that need to be skipped

GGSCI (npfdb1) 2 > info rep7upay

REPLICAT REP7UPAY Last Started 2017-07-05 11:00 Status ABENDED

Checkpoint Lag 00:00:25 (updated 02:27:08 ago)

Log Read Checkpoint File. / dirdat/rt110273

2017-07-05 0840 RBA 51.937520

You can see that the current queue file is 110273

GGSCI (npfdb1) 3 > view param rep7upay

REPLICAT rep7upay

SETENV (NLS_LANG = "American_America.ZHS16GBK")

USERID ggs,PASSWORD ggs2013

REPORTCOUNT EVERY 30 MINUTES, RATE

REPERROR DEFAULT, ABEND

Numfiles 5000

HANDLECOLLISIONS

Assumetargetdefs

DISCARDFILE. / dirrpt/rep7upay.dsc, APPEND, MEGABYTES 1000

ALLOWNOOPUPDATES

Map UCR_TRADE_02.TD_O_SYNC_7, target UCR_TRADE_01.TD_O_SYNC_7

Map UCR_TRADE_01.TL_B_PAYLOG_UNICARD, TARGET UCR_TRADE_01.TL_B_PAYLOG_UNICARD

Map UCR_TRADE_01.TF_F_CUSTOM, target UCR_TRADE_01.TF_F_CUSTOM

Map UCR_TRADE_01.TL_O_EMAILLOG, target UCR_TRADE_01.TL_O_EMAILLOG

Map UCR_TRADE_01.TL_R_CARDQUERYLOG, target UCR_TRADE_01.TL_R_CARDQUERYLOG

Map UCR_TRADE_02.TL_B_PAYLOG_UNICARD, TARGET UCR_TRADE_01.TL_B_PAYLOG_UNICARD

Map UCR_TRADE_02.TL_O_EMAILLOG, target UCR_TRADE_01.TL_O_EMAILLOG

Map UCR_TRADE_02.TL_R_CARDQUERYLOG, target UCR_TRADE_01.TL_R_CARDQUERYLOG

Map UCR_TRADE_02.TL_B_CHECK_OFFLINE_DATA, target UCR_TRADE_01.TL_B_CHECK_OFFLINE_DATA

Map UCR_TRADE_02.TL_B_OFFLINE_ORDER_REFUND, target UCR_TRADE_01.TL_B_OFFLINE_ORDER_REFUND

Map UCR_TRADE_02.TL_B_DELIVER_PRECISIONRATE, target UCR_TRADE_01.TL_B_DELIVER_PRECISIONRATE

GGSCI (npfdb1) 4 > exit

-bash-3.2$ logdump

Oracle GoldenGate Log File Dump Utility for Oracle

Version 11.2.1.0

. 1 OGGCORE_11.2.1.0

. 1_PLATFORMS_120423.0230

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

Logdump 323 > open. / dirdat/rt110273

Current LogTrail is / npf03/ggs/dirdat/rt110273

Logdump 324 > position 140305324

Reading forward from RBA 140305324

Logdump 325 > n

2017-07-05 08:40:51.937.520 Insert Len 571 RBA 140305324

Name: UCR_TRADE_02.TF_B_ORDER

After Image: Partition 4 G b

0000 0018 0000 0014 3137 3037 3035 3038 3430 3532 | .170705084052

3730 3933 3331 3235 0001 000a 0000 0000 0000 | 70933125.

0019 0002 0022 0000 001e 3130 3034 3031 3130 3930 |. 1004011090

3431 3730 3730 3530 3834 3035 3231 3131 3239 3631 | 41707050840521112961

0003 0004 0000 3034 0004 0005 0000 3031 3700 0500 | .04.017.

0500 0031 3631 0006 0004 ffff 0000 0007 0004 ffff |.

0000 0008 0015 0000 3230 3137 2d30 372d 3035 3a30 |. 2017-07-05:0

Logdump 326 > n

2017-07-05 08:40:51.937.520 Insert Len 433 RBA 140306034

Name: UCR_TRADE_02.TL_B_PAYLOG

After Image: Partition 4 G m

0000 0018 0000 0014 3137 3037 3035 3038 3430 3532 | .170705084052

3730 3933 3331 3237 0001 000a 0000 0000 0000 | 70933127.

001b 0002 0004 0000 3032 0003 0003 0000 3100 0400 | .02.1.

0300 0030 0005 000a ffff 0000 0000 0000 0006 |. 0.

0003 ffff 0000 0700 1500 0032 3031 372d 3037 2d30 | .2017-07-0

353a 3038 3a34 303a 3532 0008 0015 ffff 3139 3030 | 5 purl 08 purl 40 purl 52.1900

2d30 312d 3031 3a30 303a 3030 3a30 3000 0900 15ff |-01-01

Logdump 327 > exit

-bash-3.2$ ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0

. 1 OGGCORE_11.2.1.0

. 1_PLATFORMS_120423.0230_FBO

Solaris, sparc, 64bit (optimized), Oracle 10g on Apr 24 2012 09:06:57

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

GGSCI (npfdb1) 1 > alter rep7upay, extseqno 110273 extrba 140305324

REPLICAT altered.

Skip things with seqno 110273 seqno 140305324, because the UCR_TRADE_02.TF_B_ORDER and UCR_TRADE_02.TL_B_PAYLOG tables in the currently open queue file are not in the parameter file of rep7upay and the table is not synchronized.

GGSCI (npfdb1) 2 > start rep7upay

Sending START request to MANAGER...

REPLICAT REP7UPAY starting

GGSCI (npfdb1) 3 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNING REP1UPAY 00:00:03 00:00:00

REPLICAT RUNNING REP2UPAY 00:00:03 00:00:03

REPLICAT RUNNING REP3UPAY 00:00:02 00:00:00

REPLICAT RUNNING REP4UPAY 00:00:04 00:00:00

REPLICAT RUNNING REP5UPAY 00:00:03 00:00:04

REPLICAT RUNNING REP6UPAY 00:00:27 02:35:15

REPLICAT RUNNING REP7UPAY 02:28:31 00:00:03

REPLICAT ABENDED REPUPAY 00:00:30 01:13:54

The second scenario: if the rep7upay process still fails to start at this time, you can try to skip this useless thing (because the table we open in the queue file that is now synchronized is not within the scope of the synchronization table of our 7 parameter file), you can execute the following command to skip:

Alter rep7upay, extseqno 110273 extrba 140306034

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.