1 Reply Latest reply on Apr 3, 2012 4:51 PM by Mark Malakanov (user11181920)

    Can the source DB for Data Guard be the Target DB for Streams ?

      We have to migrate our DB to another server. For this purpose, we are planning to use Data Guard and create a physical standby database with Active Data Guard. On the day of the migration we will switch over to the Standby Database.

      The DB to be migrated is the target database for streams replication. We are replicating about 200 plus tables into this database using streams replication.

      All the databases are Oracle 11gR2.

      Can we create a physical standby database where the source DB has some tables getting replicated using streams Replication ? Due to the lack of hardware resources I can't try this out in any of our environments.

      Any additional information that might be relevant would be greatly appreciated.

      Thanks in advance,

      - Sanjay