1 Reply Latest reply: Aug 8, 2014 3:21 PM by mseberg RSS

    Oracle 12c and Active Data Guard

    Fabricio_Jorge

      Hi all,

       

         OS.....: CentOS 6.3

         RDBMS: 12.1.0.1

       

      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.

       

       

       

       

       

       

       

          
        • 1. Re: Oracle 12c and Active Data Guard
          mseberg

          Hello;

           

          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.

           

           

          Best Regards

           

          mseberg