9 Replies Latest reply: Apr 9, 2013 6:44 AM by 879152 RSS

    It is possible to apply redo while the standby is open in read only mode ?

    879152
      Hi,

      I am using Oracle 11g R2 (11.2.0.1.0)

      Step 1: Two node RAC is Configured.
      Step 2: One node Data Guard RAC is configured.( i,e Standby is one node RAC).

      Primary:

      SQL> select open_mode,database_role,PROTECTION_MODE,PROTECTION_LEVEL from v$database;

      OPEN_MODE DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL
      -------------------- ---------------- -------------------- --------------------
      READ WRITE PRIMARY MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY


      Standby:


      SQL> select open_mode,database_role,PROTECTION_MODE,PROTECTION_LEVEL from v$database;

      OPEN_MODE DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL
      -------------------- ---------------- -------------------- --------------------
      READ ONLY WITH APPLY PHYSICAL STANDBY MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY

      Question:

      I have not purchased active dataguard license.
      In my case In Data Guard RAC it is possible to apply redo while the database is open in read only mode?


      Thanks
      Solaiman