This content has been marked as final. Show 4 replies
Based on your requirement i think you have to test a failover in Oracle Dataguard
Thanks sunny for your reply
But i do not have a requirement to test on production.we just want to show the customer the standby database.
Like i want to show that suppose at a point my data is upto level A ON MY PRIMARY now i open my standby database and do some transactions now my standby is corrupted fine but i want my primary database to be as it was on same point with level A data
The moment you activate the standby database there DR relation will be over.
Once you test your standby database in read-write mode you can again convert it back in to standby database with the hep of Primary database backup.
Also there will be no effect on data of Primary during this Operations.
you can convert a read/write opened standby datase back to a standby database, if you have opened it as a Snapshot Standby. This reduces the need to have a full primary db backup at hand (and the long time needed to recreate the standby):