Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OGG-01668 Oracle GoldenGate Capture for Oracle, zextr.prm: PROCESS ABENDING

unknown-2698904Jan 28 2015 — edited Jan 28 2015

Hi my dear friends Veera and all,

GG = 11.1

Db = 9.2.0.6

OS = OEL 5.3

We current GG replication setup made by previous dba.

I checked and startup extr but  extract processes keep on abending

GGSCI (oracle.local) 3> start ZEXTR

Sending START request to MANAGER ...

EXTRACT ZEXTR starting

GGSCI (oracle.local) 1> status all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING

EXTRACT     ABENDED     ZEXTR       00:00:00      1100:15:08

EXTRACT     RUNNING     ZPUMP       00:00:00      00:00:08

I checked the logs, and I saw these errors:

GGSCI (oracle.local) 4> view ggsevt

2015-01-28 06:32:48  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oratest): start ZEXTR.

2015-01-28 06:32:48  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host 192.168.0.192 (START EXTRACT ZEXTR ).

2015-01-28 06:32:48  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT ZEXTR starting.

2015-01-28 06:32:48  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, zextr.prm:  EXTRACT ZEXTR starting.

2015-01-28 06:32:48  INFO    OGG-01639  Oracle GoldenGate Capture for Oracle, zextr.prm:  BOUNDED RECOVERY:  ACTIVE: for object pool 1: p5490_extr.

2015-01-28 06:32:48  INFO    OGG-01640  Oracle GoldenGate Capture for Oracle, zextr.prm:  BOUNDED RECOVERY: recovery start XID: 6.35.2181861.

2015-01-28 06:32:48  INFO    OGG-01641  Oracle GoldenGate Capture for Oracle, zextr.prm:  BOUNDED RECOVERY: recovery start position: SeqNo: 280, RBA: 80565776, SCN: 1391.2351121844

(5976650630580), Timestamp: 2014-12-13 10:13:26.000000.

2015-01-28 06:32:48  INFO    OGG-01642  Oracle GoldenGate Capture for Oracle, zextr.prm:  BOUNDED RECOVERY: recovery end position: SeqNo: 280, RBA: 80638976, SCN: 1391.2351121984 (5

976650630720), Timestamp: 2014-12-13 10:13:37.000000.

2015-01-28 06:32:48  INFO    OGG-01643  Oracle GoldenGate Capture for Oracle, zextr.prm:  BOUNDED RECOVERY: CANCELED: for object pool 1: p5490_extr.

2015-01-28 06:32:48  INFO    OGG-01579  Oracle GoldenGate Capture for Oracle, zextr.prm:  BOUNDED RECOVERY: VALID BCP: CP.ZEXTR.000000046.

2015-01-28 06:32:48  INFO    OGG-01629  Oracle GoldenGate Capture for Oracle, zextr.prm:  BOUNDED RECOVERY: PERSISTED OBJECTS RECOVERED: <<NONE TO RECOVER>>.

2015-01-28 06:32:48  ERROR   OGG-00730  Oracle GoldenGate Capture for Oracle, zextr.prm:  No minimum supplemental logging is enabled. This may cause extract process to handle key up

date incorrectly if key column is not in first row piece.

2015-01-28 06:32:48  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, zextr.prm:  PROCESS ABENDING.

Please help.....

Thanks,

Comments

ORASCN

Hi MK,

Before starting the Extract process, you should add minimal supplemental logging in both database level and goldengate level.

Database - ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;


GoldenGate - ADD TRANDATA SCHEMA.*;


or for the particular name you should mention it as


ADD TRANDATA SCHEMA.TABLE_NAME;


Regards,

Veera

unknown-2698904

Thanks a lot Veera my friend,

Should I perform the above command at the source database only or both source and target?

How do I know which table was not added?

Actually I did run the following:

GG> add extract zextr, tranlog, begin 2014-12-02 11:00:00

GG> add exttrail /home/oratest/gg/dirdat/cx, extract zextr, megabytes 5

GG>  add trandata AP.AP_ACCOUNTING_EVENTS_ALL

GG>  add trandata AP.AP_AE_HEADERS_ALL

GG>  add trandata AP.AP_AE_LINES_ALL

GG>  add trandata AP.AP_AWT_GROUP_TAXES_ALL

GG>  add trandata AP.AP_AWT_TAX_RATES_ALL

GG>  add trandata AP.AP_BANK_ACCOUNTS_ALL

GG>  add trandata AP.AP_BANK_BRANCHES

GG>  add trandata AP.AP_CHECKS_ALL

GG>  add trandata AP.AP_INVOICE_DISTRIBUTIONS_ALL

GG>  add trandata AP.AP_INVOICE_PAYMENTS_ALL

GG>  add trandata AP.AP_INVOICES_ALL

GG>  add trandata AP.AP_PAYMENT_SCHEDULES_ALL

GG>  add trandata AP.AP_TAX_CODES_ALL

GG>  add trandata APPLSYS.FND_USER

GG>  add trandata APPS.XX_DISCRETE_JOB_INTERFACE

GG>  add trandata APPS.XX_PO_RECEIPT_INTERFACE

GG>  add trandata APPS.XX_SUBINVTR_INTERFACE_IN

GG>  add trandata AR.AR_CASH_RECEIPT_HISTORY_ALL

GG>  add trandata AR.AR_CASH_RECEIPTS_ALL

GG>  add trandata AR.AR_PAYMENT_SCHEDULES_ALL

GG>  add trandata AR.AR_RECEIVABLE_APPLICATIONS_ALL

GG>  add trandata WIP.WIP_DISCRETE_JOBS

GG>  add trandata WIP.WIP_ENTITIES

GG>  add trandata WSH.WSH_DELIVERY_ASSIGNMENTS

GG>  add trandata WSH.WSH_DELIVERY_DETAILS

ORASCN

Hi MK,

You should execute the commands in source database and source GoldenGate.

Regards,

Veera

Sent from Samsung Mobile

unknown-2698904

Hi my friend Veera,

Yes I saw in the docs provided by the previous dba who configured it that she had run those commands you mentioned as follows:

  1. 3.1  Switch the database to archivelog mode & enable logging:

SQL> shutdown immediate

SQL> startup mount

SQL> alter database archivelog;

SQL> alter database open;

SQL> alter database add supplemental log data;

SQL> alter system set recyclebin=off scope=both; ( not for 9i )



How do I know if  those commands you mentioned was not being run?


Anyways I rerun it again as follows:


        SQL>  alter database add supplemental log data;

        Database altered.



But still the status is abended



Please help....

Thanks


unknown-2698904

Hi dear friend Veera,

When I run again the command > alter database add supplemental log data;

The next morning I check the status and the extract is now good and running

Do I need to rerun this command on regular basis, like if we bounce the database?

Thanks a lot.

ORASCN

Hi Maria,

Cool Not required.

Regards,

Veera

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 25 2015
Added on Jan 28 2015
6 comments
6,317 views