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!

SQL SERVER(Clone read only db) - ORACLE: CDC implementation

ApparaoAkki-OracleAug 27 2019 — edited Aug 28 2019

Hi,

I have a scenario where i suppose to setup Golden Gate CDC from SQL SERVER(cloned read only db) to Oracle.

Since the source database is on read-only mode, we are unable to enabling CDC and supplemental logging over the database, and also tried to use TRANLOGOPTIONS to read the data from (log shipping backup files(.trn extension)) but getting unrecognized keyword related issues.

summary:

data flow scenario:

1-PROD(sql server) to clone db(sql server) via log shipping for every 1 min

2-source GG setup has been done on clone db(read only). -- able to perform initial load.

3-target setup is on oracle.

Please help me to get out of this.

Thanks,

Apparao Akki

Added on Aug 27 2019

#goldengate

2 comments

496 views