-f dbparam

This BRSPACE function changes the value of database parameters. For more information, see Altering Database Parameters with BR*Tools.

Function options:

• -a|-action: specifies the action to change the database parameter

  Syntax: -a|-action change|create|crfmem|reset

  • change changes a database parameter

  • create creates the init<DBSID>.ora file from the spfile

  • crfmem creates init<DBSID>.ora from memory

  • reset resets a database parameter

  Default: change database parameter

• -c|-comment: lets you enter a comment on the parameter change

  Default: No comment

• -i|-instance: defines for which database instance the parameter change is to apply

  Syntax: -i|-instance <instance>

  <instance> changes the parameter of the specified instance

  Default: changes the parameter for all instances

  Note

  You only need to specify database instances in an Oracle Real Application Cluster (RAC) system.

• -p|-parameter: defines which database parameter is to be changed

  Syntax: -p|-parameter <parameter>

  <parameter> changes the specified parameter

  Default: none, since you must always specify a parameter to change

  Note

  You must specify this option if you want to set a special parameter (that is, a “_” parameter). For more information, see SAP Note 744585.

• -s|-scope: defines the scope of the parameter change

  Syntax: -s |-scope memory|spfile|both

  • memory changes the parameter immediately for the specified running instances

  • spfile changes the parameter in the Oracle spfile for the specified instances, but this takes effect only after the instance has been restarted

  • both changes the parameter in both memory and spfile for the specified instances

  Default: both

• -v|-value: defines the new parameter value

  Syntax: -v|-value <value>

  <value> specifies the new parameter value

  Default: none, since you must always specify the new parameter value.