OS.....: CentOS 6.3
I have successfully configured a Dataguard on my test en using Oracle 12c. But now i want to use the Active Dataguard feature, specifically the Real-time Query feature. In 11g, i had to execute a few steps to be able to open a database READ-ONLY, but with the PDBs, i don't know if the procedure is the same.
For example, to set real-time Query in a 11g database, i would execute the following, via Broker:
|DGMGRL> edit database 'clonestb' set state='APPLY-OFF';|
DGMGRL> edit database 'clonestb' set state='READ-ONLY';
DGMGRL> edit database 'clonestb' set state='APPLY-ON';
... but how to do that in 12c? I thought at first, that just opening all my PDBs in the standby database in READ-ONLY mode would do the trick.
It's not clearly explained in the documentation.
Step 1 DGMGRL> EDIT DATABASE ‘PRODDB’ SET STATE=’APPLY-OFF’;
Step 2 SQL> alter database open read only;
Step 3 DGMGRL> EDIT DATABASE ‘PRODDB’ SET STATE=’APPLY-ON’;
Sorry I didn't not notice how old this was. Not sure how it got "Bumped" to the top again.