BRSPACE Parameter Change Log

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

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

The file is called param<DBSID>.log and 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>]`
	Note The value `[null]` means that Oracle now takes the default value for the parameter. End of the note.
`#COMMENT`(optional)	Your comment	`For incremental backups`

Note Note

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

End of the note.

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