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)