Object documentationBRSPACE 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.

Structure

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

2011-08-01 10.36.14

BRSPACE action id (encoded timespace)

sehezzlu

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

2011-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

2011-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 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, sehezzlu.dbp – represents the name of the BRSPACE detail log.

End of the note.