4 Replies Latest reply: May 6, 2013 9:30 AM by gopal RSS

    Howto properly change db_file_name_convert in a dg broker environment

    Orna Weisman
      Hi

      I have a 10.2.0.4 RAC database with a single isntance physical standby.

      I now need to make a change to the db_file_name_convert and log_file_name_convert on the primary , without restarting ( its a production database ) .

      The problem I am facing is that any change I am making , be that via the broker or via alter system ( to the spfile ) I end up with a Warning status in the broker - that the parameters are inconsistent with the database settings.

      Am I doing something wrong ?
      what is the correct way to change these parameter and still maintain 'SUCCESS' status to the 'show configuration' ?

      Is bouncing the primary my only option ?

      thanks
      Orna