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>.sap that 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 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
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