7 Replies Latest reply: Jun 11, 2014 6:44 AM by petra-K RSS

    RECOVERY MODE = MANAGED?

      Hi all,

       

      11.2.0.3

       

      I have configured/setup our dataguard physical standby.

      But when I check the RECOVERY_MODE from V$ARCHIVE_DEST_STATUS  the mode is "MANAGED".

       

      How do I changed it to "MANAGED REAL TIME APPLY"?

      What is the difference between "MANAGED" vs. "MANAGED REAL TIME APPLY"?

      What are the advantages or disadvantages?

       

      Thanks all,

      pK

        • 1. Re: RECOVERY MODE = MANAGED?
          Sunny kichloo

          Converting into real time apply:

           

          1) On the standby cancel out of the current managed recovery

          SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

           

           

          2)Open database in read only mode.

           

          SQL>ALTER DATABASE OPEN;

           

          3) Place it back in recovery with Real time apply

          SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT
          LOGFILE DISCONNECT;

           

           

          In real time any changes done on primary database comes in standby.

           

          For more details refer below mentioned link

           

          http://www.cnblogs.com/fangwenyu/archive/2012/05/09/2491468.html

          • 2. Re: RECOVERY MODE = MANAGED?

            Thanks Sunny,

             

            Does it affect performance? Usually "real" time connotes performance degradation?

            • 3. Re: RECOVERY MODE = MANAGED?
              Sunny kichloo

              Ultimately it comes out to network speed between primary and standby but not seen performance issue after enabling Real Time Apply

              • 4. Re: RECOVERY MODE = MANAGED?

                Hi All,

                 

                11.2.0.3

                I created by my standby db using >> duplicate target database for standby from active database spfile

                The physical standby was successfully created.

                 

                But when I compare the dbfs, there are missing files like temp01.dbf, redo01,02,03.

                Do I need to manually create these files?

                 

                At Primary:

                ========

                ls -l

                total 24019616

                -rw-r-----    1 oracle   dba         8110080 Jun 11 18:12 control01.ctl

                -rw-------    1 oracle   dba         8110080 Jun 11 18:12 control03.ctl

                -rw-r-----    1 oracle   dba        52429312 Jun 11 17:13 redo01.log

                -rw-r-----    1 oracle   dba        52429312 Jun 11 17:45 redo02.log

                -rw-r-----    1 oracle   dba        52429312 Jun 11 18:12 redo03.log

                -rw-r-----    1 oracle   dba       922755072 Jun 11 18:11 sysaux01.dbf

                -rw-r-----    1 oracle   dba       796925952 Jun 11 18:11 system01.dbf

                -rw-r-----    1 oracle   dba       550510592 Jun 11 14:40 temp01.dbf

                -rw-------    1 oracle   dba      2122326016 Jun 11 18:12 ts_enc.dbf

                -rw-r-----    1 oracle   dba      2128617472 Jun 11 18:12 undotbs01.dbf

                -rw-r-----    1 oracle   dba      5603336192 Jun 11 18:12 users01.dbf

                 

                 

                At Standby:

                =========

                ls -l

                total 22616592

                -rw-------    1 oracle   dba         8110080 Jun 11 17:32 control01.ctl

                -rw-------    1 oracle   dba         8110080 Jun 11 17:32 control03.ctl

                -rw-------    1 oracle   dba       912269312 Jun 11 17:07 sysaux01.dbf

                -rw-------    1 oracle   dba       796925952 Jun 11 17:11 system01.dbf

                -rw-------    1 oracle   dba      2122326016 Jun 11 17:03 ts_enc.dbf

                -rw-------    1 oracle   dba      2128617472 Jun 11 16:54 undotbs01.dbf

                -rw-------    1 oracle   dba      5603336192 Jun 11 16:45 users01.dbf

                 

                 

                Thanks,

                • 5. Re: RECOVERY MODE = MANAGED?
                  Sunny kichloo

                  And Do  close thread if your issue is resolved.

                  • 7. Re: RECOVERY MODE = MANAGED?

                    Thanksss Sunny, That is a very excellent post. To think that is it not from Oracle forums? I wonder why is it not documented clearly as that with the DG docs?