Forum Stats

  • 3,769,805 Users
  • 2,253,023 Discussions
  • 7,875,211 Comments

Discussions

Configuring Downstream Capture on SingleNode Primary Standby env which will be switched frequently

user8860934
user8860934 Member Posts: 64 Blue Ribbon

Environment:

Oracle Database Version: 12.1.0.2

Single Node Primary Database &

Single Node Physical Standby Database


We switch Primary Standby roles every month...


Right now we are working on a Data Mart Database, which needs to replicate data from Primary/Standby depends on its role.

I am reading an OGG document that says as follows

"Only one source database can be configured for real-time mine in the downstream mining database."

Does this mean Primary and Standby databases are considered as two different source databases and when we switch OGG will not work because it has to read from the online redo log?

Answers