The detail log file contains full information about what happened during the BRSPACE function.
The file displays information about the:
Relevant parameters from the initialization profile init<DBSID>.sapthat were set during the BRSPACE run
Function name
Menus that were displayed and the options that you chose
BRSPACE commands and results
BRSPACE detail logs have names of the following form:
s<encoded timestamp>.<ext>
The logs are stored in the sapreorg directory.
The name consists of:
Action ID
This consists of the fixed character s and the <encoded time> that the function was performed.
Function ID
The suffix <ext> indicates the function type:
dbr: start up database
dbs : shut down database
dba : alter database instance
dbp : alter database parameter
dbc: recreate database
dbw: show database information (default)
tse: extend tablespace
tsc: create tablespace
tsd: drop tablespace
tsa: alter tablespace
dfa: alter data file
dfm: move data file
tbr: reorganize tables
idr: rebuild indexes
tbe: export tables
tbi: import tables
tba: alter tables
ida: alter indexes
mst: manage database statistics
mfb: manage flashback database
This is an example of the start of a BRSPACE detail log for the function show database information:
BR1001I BRSPACE 6.40 (0)
BR1002I Start of BRSPACE processing: sdljsvqc.dbw 2003-08-26 10.23.50
BR0101I Parameters
Name Value
oracle_sid GC2
oracle_home /oracle/GC2
oracle_profile /oracle/GC2/dbs/initGC2.ora
sapdata_home /oracle/GC2
sap_profile /oracle/GC2/dbs/initGC2.sap
space_function dbshow
space_copy_dir /oracle/GC2/sapreorg
scroll_lines 20
system_info oragc2/oragc2 uw1030 SunOS 5.8 Generic_108528-15 sun4u
oracle_info GC2 9.2.0.1.0 8192 8856 17005445
sap_info 620 SAPR3
make_info sun OCI_901 Aug 26 2003
command_line brspace -f dbshow -c dbparam -l
BR0280I BRSPACE time stamp: 2003-08-26 10.23.50
BR1009I Name of database instance: GC2
BR1010I BRSPACE action ID: sdljsvqc
BR1011I BRSPACE function ID: dbw
BR1012I BRSPACE function: dbshow
BR1034I Class of information to be shown: dbparam
BR0280I BRSPACE time stamp: 2003-08-26 10.23.51
BR0659I List menu 257 + you can select one or more entries
--------------------------------------------------------------------
List of database parameters
Pos. Parameter Modif. Inst. Value
1 - active_instance_count spfile * <null>
2 - aq_tm_processes both * 1
3 - archive_lag_target both * 0
4 - audit_file_dest spfile * ?/saptrace/audit
5 - audit_sys_operations spfile * FALSE
6 - audit_trail spfile * NONE
7 - background_core_dump spfile * partial
8 - background_dump_dest both * /oracle/GC2/saptrace/bdump
9 - backup_tape_io_slaves both * FALSE
10 - bitmap_merge_area_size spfile * 1048576