Skip to Main Content

Database Software

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!

Data replication using LogMiner - Only few tables

AzarulJan 27 2014 — edited Feb 3 2014

Hi All,

I've requirement to replicate data from few tables to target database. The data must be sync in every hour. Due to some budget constraint, I'm exploring standard database features that I can use for this purpose. The challenging here is because only certain table need to be sync and performance impact. I dont want to impact performance in Online database.

The situation is like this. I've application A running in Active Data Guard mode. So I've primary and Standby DB which Open Read Only. I need to replicate data for some tables from Source database(Application A) to target database. I want replication to be happened between Standby DB and Target database only without touching Primary DB because I dont want Primary DB performance impact.

I was thinking to use LogMiner because using LogMiner it can generate committed SQL and I can execute again in target DB.

1- I need some opinion if any of you have experience using LogMiner and how to avoid performance impact.

2- If you have experience using LogMiner in standby DB, please advice how to create dictionary file without open the database because standby database is read-only(Active Data Guard)

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 3 2014
Added on Jan 27 2014
1 comment
1,961 views