5 Replies Latest reply: Feb 25, 2013 12:58 AM by Sunny kichloo RSS

    Doubt regarding REAL time redo apply in Dataguard

    sandy121
      Friends, how to check whether 'REAL TIME REDO APPLY' is configured in my dataguard configuration. If it is not 'on' , how to enable 'REAL TIME REDO APPLY' on using dataguard broker.

      Thanks in advance.
        • 1. Re: Doubt regarding REAL time redo apply in Dataguard
          Sunny kichloo
          This will help

          http://aprakash.wordpress.com/2012/03/14/how-to-check-real-time-apply-is-enabled-on-standby-database/

          http://easyoradba.com/2011/01/10/real-time-apply-in-oracle-data-guard-10g/
          • 2. Re: Doubt regarding REAL time redo apply in Dataguard
            CKPT
            918868 wrote:
            Friends, how to check whether 'REAL TIME REDO APPLY' is configured in my dataguard configuration. If it is not 'on' , how to enable 'REAL TIME REDO APPLY' on using dataguard broker.

            Thanks in advance.
            You have to check the client process whether it is LGWR or ARCH process. The CLIENT PROCESS refers to corresponding primary database process.
            SQL> SELECT THREAD#,SEQUENCE#,PROCESS,CLIENT_PROCESS,STATUS,BLOCK#,BLOCKS FROM V$MANAGED_STANDBY;
               THREAD#  SEQUENCE# PROCESS   CLIENT_P STATUS           BLOCK#     BLOCKS
            ---------- ---------- --------- -------- ------------ ---------- ----------
                     0          0 ARCH      ARCH     CONNECTED             0          0
                     0          0 ARCH      ARCH     CONNECTED             0          0
                     0          0 ARCH      ARCH     CONNECTED             0          0
                     0          0 ARCH      ARCH     CONNECTED             0          0
                     1        149 ARCH      ARCH     CLOSING           61440       1244
                     0          0 RFS       N/A      IDLE                  0          0
                    "1        150 RFS       LGWR     IDLE               8910          1"
                     1        150 MRP0      N/A      APPLYING_LOG       8910     204800
            • 3. Re: Doubt regarding REAL time redo apply in Dataguard
              Jos van den Oord
              This can be found in the query "select recovery_mode from v$archive_dest_status" this give than the following output "MANAGED REAL TIME APPLY"

              Cheers [http://joordsblog.vandenoord.eu/|Jos van den Oord]
              • 4. Re: Doubt regarding REAL time redo apply in Dataguard
                992918
                Hi,

                Please try as follow on your standby database.

                select open_mode from V$database;

                if the value is Read Only then the real time apply is not enabled. you can also have more information on by querying V$archive_dest and V$managed_standby views.

                Hopes this will help.
                • 5. Re: Doubt regarding REAL time redo apply in Dataguard
                  Sunny kichloo
                  If your issue is resolved you can close this thread.It save time of users looking for open thread.