This discussion is archived
2 Replies Latest reply: Sep 29, 2012 2:45 PM by mseberg RSS

Parameter changes

965243 Newbie
Currently Being Moderated

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
    phaeus Pro
    Currently Being Moderated
    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
    mseberg Guru
    Currently Being Moderated

    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



  • Correct Answers - 10 points
  • Helpful Answers - 5 points