2 Replies Latest reply: Sep 29, 2012 4:45 PM by mseberg RSS

    Parameter changes


      I am going to change some parameters on primary database (db cache, java pool etc.). I am not sure, if the changes are automaticallly propagated to standby or if I have to make the changes manually on stanby site too? I couldn't find clear answer in documentation. Can you explain please how parameter changes work in dg physical configuration?

      Thank you,
        • 1. Re: Parameter changes
          if you do some alter system set command on your primary only this database will be changed. You have to do the some changes on your standby. Becuase this changes are made in the spfile and not in the redo stream they will not be send to the standby.

          Hope this helps
          • 2. Re: Parameter changes

            What I would do on the Standby is create a new pfile from spfile. The I would make the changes you desire in the new pfile.

            Then stop apply on the standby and shutdown the database.

            Start the standby NOMOUNT on the changed pfile and create a new spfile form it.

            The shutdown and start apply again.

            If you are using Data Guard Broker consider a different plan.

            Best Regards