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