Oracle Database Discussions

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

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

Hi MK,

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

Regards,

Veera

Sent from Samsung Mobile

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

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.

Hi Maria,

Cool Not required.

Regards,

Veera