2 Replies Latest reply: Apr 2, 2013 6:33 AM by Mahir M. Quluzade RSS

    Couple of Standby questions

    1000337
      Hi,

      DB Version is 11.2.0.2 & OS Version RHEL 5

      1) What init.ora parameters need to be synchronized between the primary and standby databases?

      2) How does the primary database detect standby database problems or failure?

      Regards
        • 1. Re: Couple of Standby questions
          Mihael
          DB Version is 11.2.0.2 & OS Version RHEL 5

          1) What init.ora parameters need to be synchronized between the primary and standby databases?
          see 10g docs: http://docs.oracle.com/cd/B19306_01/server.102/b14239/create_ps.htm#i68626
          2) How does the primary database detect standby database problems or failure?
          When there are problems in transfer of redo data to standby destination.
          • 2. Re: Couple of Standby questions
            Mahir M. Quluzade
            997334 wrote:
            Hi,

            DB Version is 11.2.0.2 & OS Version RHEL 5

            1) What init.ora parameters need to be synchronized between the primary and standby databases?
            What is means synchronized. If your means SYNC transport, then stanbyd service log_archive_dest_n parameter require contains
            SYNC AFFIRM for data protection mode MAX PROTECTION and MAX AVAILABILITY.

            2) How does the primary database detect standby database problems or failure?
            You can found v$archive_dest view column ERROR.
            If have any problem on standby you can get error on primary side.
            Transport is stopping when there have any error on archive destination.
            >
            Regards
            Mahir M. Quluzade
            http://www.mahir-quluzade.com