The structure change log contains a history of all database structure changes that you perform with BRSPACE. Structure changes consist of the following functions:
Recreate database
Extend tablespace
Create tablespace
Drop tablespace
Alter tablespace (rename)
Alter datafile (rename, drop, change file size attributes)
Rename tablespace
Move datafile
The file helps you to keep track of database structure changes.
The file is called struc<DBSID>.log and is located in the $SAPDATA_HOME/sapreorg directory.
The first line is standard but the following lines vary according to the function.
Standard first line
Line |
Entry |
Example |
---|---|---|
#BRSRUN |
Timestamp (date, time) for when you start BRSPACE for the structure change |
2011-08-01 14.47.18 |
BRSPACE action id (encoded timespace) |
swhfavte |
|
BRSPACE function ID |
tse |
|
Function name |
tsextend |
|
Effective and real user name |
user=oragc2/oragc2 |
The combination of action id and function id - in the above example, sehfavte.tse - represents the name of the BRSPACE detail log.
Extend tablespace
Line |
Entry |
Example |
---|---|---|
#TSPEXT |
Timestamp (date, time) for when the structure change finished |
2011-08-01 14.47.27 |
Tablespace name |
PSAP2222 |
|
#FILEADD |
New datafile name |
/oracle/GC2/sapdata4/2222_6/2222.data6 |
Parameters for new datafile |
size=1M autoext=yes maxsize=10M incrsize=1M |
Create tablespace
Line |
Entry |
Example |
---|---|---|
#TSPCRT |
Timestamp (date, time) for when the structure change finished |
2011-08-01 14.50.35 |
Tablespace name |
PSAP3333D |
|
Parameters for new tablespace |
conts=data assm=auto data=table |
|
#FILEADD |
New datafile name |
/oracle/GC2/sapdata4/3333d/3333d.data1 |
Parameters for new datafile |
size=1M autoext=yes maxsize=10M incrsize=1M |
Drop tablespace
#TSPDROP |
Timestamp (date, time) for when the structure change finished |
2011-08-01 14.52.41 |
Tablespace name |
PSAP4444I |
|
Attributes of deleted tablespace |
files=2 size=2M |
|
#FILEDEL |
Deleted datafile name |
/oracle/GC2/sapdata4/4444i_1/4444i.data1 |
Datafile parameters |
size=1M |
Rename tablespace
#TSPREN |
Timestamp (date, time) for when the structure change finished |
2011-08-01 14.52.41 |
Old tablespace name |
PSAP4444I |
|
New tablespace name |
newname=PSAP5555I |
Alter datafile
Switch on autoextend
#FILEAUTO |
Datafile name |
/oracle/GC2/sapdata4/2222_1/2222.data1 |
Datafile parameters |
size=1M autoext=yes maxsize=22M incrsize=2M |
Switch off autoextend
#FILEFIX |
Datafile name |
/oracle/GC2/sapdata1/testd_5/ttttd.data5 |
Parameters to specify the affected datafile |
size=2M autoext=no |
Resize datafile
#FILESIZE |
Datafile name |
/oracle/GC2/sapdata6/testd_1/testd.data1 |
Parameters for new and old size of datafile |
size=8M oldsize=4M |
Move datafile
#TSP |
Timestamp (date, time) for the move |
2011-08-01 17.55.14 |
Tablespace |
PSAP1111D |
|
#FILEMOVE |
New datafile name |
/oracle/GC2/sapdata5/1111d_2/1111d.data2 |
Old datafile name |
oldfile=/oracle/GC2/sapdata2/1111d_3/1111d.data3 |
|
Datafile size |
size=3M |