In Dataguard , is there any way to avoid this rebuild physical standby database again and again afte
I have question related to Dataguard in RAC.
I get 2 to 4 times request in a month to refresh Oracle Production Database to UAT Database.
Production and UAT both databases are on 11g R2 version.
Production Database Setup is 4 Node RAC i.e. 2 Node Primary and 2 Node Physical Standby.
UAT Database Setup is 4 Node RAC i.e. 2 Node Primary and 2 Node Physical Standby.
My Question:
Every time if refresh Production database to UAT , and since every time incarnation gets changed in UAT after refresh from production database.
Due to this my current UAT Physical standby database is of no use as it goes out of sync.