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