This content has been marked as final. Show 10 replies
SQL> SELECT database_role, open_mode FROM v$database;
SQL> alter database recover managed standby database cancel;
SQL> alter database open;
SQL> alter database recover managed standby database disconnect from session;
SQL> select process,status,sequence# from v$managed_standby;
If you have Data Guard Broker setup then
DGMGRL > edit database physt set state=apply-off; SYS@physt > alter database open read only; DGMGRL > edit database physt set state=apply-on;
Edited by: mseberg on Oct 3, 2012 3:12 PM
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.
"Don't believe it, test it!"