BRSPACE

BRSPACE??

* Instance management
------------------------------
- Start up database
- Shut down database
- Alter database instance
- Alter database parameters
- Show instance status
- Show database parameters

* Space management
----------- ----------------
- Extend tablespace
- Create tablespace
- Drop tablespace
- Alter tablespace
- Alter data file
- Move data file
- Show tablespaces
- Show data files
- Show redolog files
- Show control files
- Show diska volumes

* Segment management
------------------------------
- Reorganize tables (online)
- Rebuild indexes (online)
- Export tables- Import tables- Alter tables- Alter indexes
- Show tables
- Show indexes
- Show table partitions
- Show index partitions
- Show segments
- Show segment extents
- Show free extents

Checking BR*Tools Release Information

pat2036:oras94 4> brtools –V | brspace -V
BR0651I BRTOOLS 6.40 (40)
Patch Date Info

36 2006-01-11 Small functional enhancements in BR*Tools (note 914174)
38 2006-03-29 BR*Tools support for MDM databases (note 936665)
40 2006-08-30 Wrong message numbers in BR*Tools 6.40 (note 976755)

release note 680046
kernel release 640
patch date 2006-08-30
patch level 40
make platform rs6000_64
make mode OCI_920
make date Sep 5 2006
Summary of the BR Tools

What is BRBACKUP - Backs up data files, conrol files, and online redo log files of the database.
What is BRARCHIVE - Backs up offline redo log files
What is BRRESTORE - Restores data files, control files, and redo log files
What is BRRECOVER - Recovers database files and restores profiles and log files
What is BRSPACE - Manages the database instance, space, and segments (that is, tables and indexes)
What is BRCONNECT - Performs database administration tasks such as statistics update, check database system, adapt next extents, clean up logs and DBA tables. Functions as a help tool to monitor the database during a backup
What is BRTOOLS - Displays the menus from which the other BR programs are called. Functions as an internal help tool started by BRBACKUP, BRARCHIVE, and BRRESTORE.
What is BRGUI - Functions as a Java-based GUI, working as the front-end display program for BR*Tools
Initialization Profile BR* Tools uses the initialization profile init<SID>.sap as a input file.The following are the important parameters in the init<SID>.sap file Ø

exp_dump_dir
exp_table
Imp_table
rebuild_index
reorg_table
show_period
space_copy_dir

exp_dump_dir

This parameter specifies the directory of the export dump file

Syntax : exp_dump_dir = < directory name >
Default : $SAPDATA_HOME/sapreorg

exp_tableThis parameter specifies the table for an export
Syntax: exp_table = [<owner>.]<table> | (<table_list>)
Default : None
Eg:
exp_table= (SDBAH, SAPR3.SDBAH)

imp_tableThis parameter specifies the table for an import
Syntax: imp_table = [<owner>.]<table> | (<table_list>)
Default : None
Eg:
imp_table= (SDBAH, SAPR3.SDBAH)

rebuild_indexThis parameter specifies the database indexes for an index rebuild
Syntax: rebuild_index = [<owner>.]<index> | (<index_list>)
Default : None
Eg:
rebuild_index= (SDBAH`0, SAPR3.SDBAH`0)

reorg_tableThis parameter specifies the table for reorganization
Syntax: reorg_table = [<owner>.]<table> | (<table_list>)
Default : None
Eg:
reorg_table= (SDBAH, SAPR3.SDBAH)

show_TableThis parameter specifies the time period for which BRTOOLS display log files
Syntax : show_period = <days>
Default : 30
Possible values :
0 – Show all available log files
1 – Show logs created today
>1 – Show logs files created in the previous specified number of days

space_copy_dirThis parameter specifies the directory for file copies during space management.
Syntax : space_copy_dir = <directory name>
Default : $SAPDATA_HOME/sapreorg

Logs for BR*Tools

Logs are created for BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRCONNECT, and BRSPACE. These supply information about database operations and are useful for problem analysis.

The following types of logs are written: Ø
File System Logs
Database Logs in tables SDBAH and SDBAD


File System Logs

For more information, see:
· BRBACKUP Logs• Detail log - b<encoded timestamp>.<ext> ( eg: bdvecswx.anf ) • Summary log - back<DBSID>.log (eg: backS94.log )
Directory : /oracle/<SID>/sapbackup

· BRARCHIVE Logs• Detail log - a<encoded timestamp>.<ext> (eg: aduryokf.svd ) • Summary log - arch<DBSID>.log (eg: archS94.log )
Directory : /oracle/<SID>/saparch
· BRRESTORE Logs• Detail log - r<encoded timestamp>.<ext> (eg: rdvecswx.rsb ) • Summary log - rest<DBSID>.log ( eg: restS94.log )
Directory : /oracle/<SID>/sapbackup

BRRECOVER Logs• Detail log - v<encoded timestamp>.<ext>
• Summary log - recov<DBSID>.log ( eg: recovS94.log )
Directory : /oracle/<SID>/saparch
· BRSPACE Logs• Detail log - s<encoded timestamp>.<ext> ( eg: sduvytan.tse )
• Summary log - space<DBSID>.log (eg: spaceS94.log )Directory : /oracle/<SID>/sapreorg
· BRCONNECT Logs• Detail log - c<encoded timestamp>.<ext> (eg: cduxtdrn.chk)
• Summary log - conn<DBSID>.log ( eg: connS94.log )
Directory : /oracle/<SID>/sapcheck
Database Logs
The database logs of BRBACKUP, BRARCHIVE, and BRCONNECT are stored in tables SDBAH and SDBAD

SDBAH

This table contains information that refers to the backup as a whole:


Starting time of the backup or BRCONNECT processing
End time of the backup or BRCONNECT processing
BRBACKUP/BRARCHIVE/BRCONNECT return code
BRBACKUP/BRARCHIVE/BRCONNECT action ID (encoded timestamp of the file system log names)
BRBACKUP/BRARCHIVE/BRCONNECT function ID (extension of the file system log names)

SDBAD

This table contains information that refers to the backup of one file:

File name
· Oracle file ID or log group number
· End time of the backup of the file
· Name of the volume where the file was saved
· Position of the file on the volume
· Backup ID of the external backup program
· Compression rate of the software compression

In addition, table SDBAD contains internal BRBACKUP information about compression rates and backup durations for the individual database files. For BRCONNECT, SDBAD tables contain information on the total number of objects processed by BRCONNECT.