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
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):