i have created a data guard in rac environment rac 2 node.Its successfully configured.Now i want to show a drill activity to customer.
But as its a production database i am avoiding the risk of showing switchover switchback.
Also the customer does not want to shutdown the database.So i want to know can i activate the standby database for testing.I know if i open it once it the standby database would be corrupted but it will be alright for me i would create it again.Also i dont want the transactions for which we test on standby to be there on primary.
I mean we just want to test the standby.
So if i defer the log_archive_dest2 parameter and open the standby and do some transactions on it.Would it be fine OR it would impact my primary database also and there may be some conflict.
Please clear what are the best ways for testing.
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):