BRSPACE Parameter Change Log

Definition

The parameter change log contains a history of all database parameter changes that you perform with BRSPACE.

Use

The file helps you to keep track of database parameter changes.

Structure

The file is called param<DBSID>.logand is located in the $SAPDATA_HOME/sapreorg directory. It has the following structure:

Line

Entry

Example

#BRSRUN

Timestamp (date, time) for when you start BRSPACE for the parameter change

2003-08-01 10.36.14

BRSPACE action id (encoded timespace)

sdlezzlu

BRSPACE function ID

dbp

Function name (always dbparam)

dbparam

Effective and real user name

user=oragc2/oragc2

#PARCHNG

– change parameter
value

Timestamp (date, time) for when BRSPACE completes the parameter change

2003-08-01 10.36.14

Name of parameter changed

control_file_record_keep_time

Scope of change: in memory, spfile, or both

scope=both

#PARRST

– reset parameter value

Timestamp (date, time) for when BRSPACE completes the parameter reset

2003-08-01 11.03.10

Name of parameter changed

control_file_record_keep_time

Scope – in memory, spfile, or both

scope=both

#VALUE

New parameter value

30

Old value

ddval=[10]

Value in spfile

spfile=[<same>]

The value [null] means that Oracle now takes the default value for the parameter.

#COMMENT (optional)

Your comment

For incremental backups

The combination of action id and function id – in the above example, sdlezzlu.dbp – represents the name of the BRSPACE detail log.

Example

This is an example of part of a parameter change log:

#BRSRUN... 2003-08-01 10.36.14 sdlezzlu dbp func=dbparam user=oragc2/oragc2

#PARCHNG.. 2003-08-01 10.37.09 control_file_record_keep_time scope=both

#VALUE.... [32]  oldval=[30]  spfval=[<same>]

#

#BRSRUN... 2003-08-01 10.37.41 sdlezzpd dbp func=dbparam user=oragc2/oragc2

#PARRST... 2003-08-01 11.03.10 control_file_record_keep_time scope=both

#VALUE.... [null]  oldval=[32] spfval=[<same>]

#

#BRSRUN... 2003-08-01 11.03.35 sdlfabwx dbp func=dbparam user=oragc2/oragc2

#PARRST... 2003-08-01 11.05.30 control_file_record_keep_time  scope=both

#VALUE.... [null]  oldval=[32]

#

#BRSRUN... 2003-08-01 11.35.07 sdlfaerr dbp func=dbparam  ser=oragc2/oragc2

#PARCHNG.. 2003-08-01 11.35.39  control_file_record_keep_time  scope=both

#VALUE.... [33]  oldval=[32]

#

#BRSRUN... 2003-08-01 11.36.13 sdlfaeuf dbp func=dbparam  ser=oragc2/oragc2

#PARRST... 2003-08-01 11.38.26  control_file_record_keep_time  scope=both

#VALUE.... [null]  oldval=[33]  spfval=[<same>]

#

#BRSRUN... 2003-08-01 14.28.33 sdlfaubx dbp func=dbparam user=oragc2/oragc2

#PARCHNG.. 2003-08-01 14.29.15  control_file_record_keep_time  scope=both

#VALUE.... [30]  oldval=[7]

#COMMENT.. Activate incremental backups