1 Reply Latest reply on Apr 9, 2013 2:37 PM by Sunny kichloo

    Few questions

    1002008
      1) If i do changes in table on primary database and if i open standby database in Read-Only mode, i can see those changes immediately only if Real Time Apply is enabled. Am i correct? Database version is 10.2.0.4

      2) From 11g, It is possible to apply redo while the standby is open in read only mode. prior to 11g, it was not possible. Right?

      3) Should I first cancel Managed Recovery prior to issuing “ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY”?
        • 1. Re: Few questions
          Sunny kichloo
          1) If i do changes in table on primary database and if i open standby database in Read-Only mode, i can see those changes immediately only if Real Time Apply is enabled. Am i correct? Database version is 10.2.0.4
          Yes in Active Dataguard its possible.
          2) From 11g, It is possible to apply redo while the standby is open in read only mode. prior to 11g, it was not possible. Right?
          Yes Active Dataguard comes from 11g onwards.

          http://www.oracle.com/technetwork/database/features/availability/maa-wp-11gr1-activedataguard-1-128199.pdf
          3) Should I first cancel Managed Recovery prior to issuing “ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY”?
          Yes.