I have an Active DataGuard, Oracle version 126.96.36.199 and Solaris 10.
I have to do a test on the Active DataGuard environment, I want to open this database to run multiple scripts DML. At the end I must return to the DataGuard active as it was before the opening to continue with normal operation.
I appreciate the document indicate commands or procedure I should run to do this activity.
When I created this adg enviroment, I read a note indicating that he could open the database for testing and then return to the point before the opening to continue the active DataGuard. I want to do this test and do not remember the number of document information and commands.
Active Data Guard resp. Real-Time Query will never allow for DML on the Standby DB. Period.
You can open a Physical Standby Read-Write and do DML then, but it will no longer show the same state as the Primary. In other words: Real-Time Query is off then.
One convenient way to have a Physical Standby opened Read-Write, do anything and then reconvert it into Physical Standby is a Snapshot Standby Database.
There is no (direct) relation to Active Data Guard here, though.