Cleaning Up DBA Logs and Tables with BR*Tools

Prerequisites

Make sure you have set the necessary BRCONNECT parameters in the initialization profile init<DBSID>.sap, because BRTOOLS uses these when it calls BRCONNECT.
The database must be open.

This BR*Tools function helps you to free disk space used by old DBA logs and protects your database against unnecessary growth of the DBA tables.

Set the required options:

Menu Entry	Equivalent BRCONNECT Command Option
BRCONNECT profile (profile)	-p\|-profile
Database user/password (user)	-u\|-user
Database owner for cleanup (owner)	-f cleanup -o\|-owner
BRBACKUP logs (backup)	-f cleanup -b\|-backup
BRARCHIVE logs (archive)	-f cleanup -a\|archive
BRRESTORE logs (restore)	-f cleanup -r\|-restore
BRRECOVER logs (recover)	-f cleanup -v\|-recover
BRCONNECT logs (connect)	-f cleanup -c\|-connect
BRSPACE log (space)	-f cleanup -s\|-space
BRBACKUP disk backups (diskback)	-f cleanup -k\|-diskback
BRARCHIVE disk backups (diskarch)	-f cleanup -i\|-diskarch
BRSPACE export dumps (expdump)	-f cleanup -e\|-expdump
Oracle trace files (trace)	-f cleanup -t\|-trace
Database logs in SDBAH and SDBAD (dblog)	-f cleanup -d\|-dblog
XDB logs in DBA tables (xdblog)	-f cleanup -x\|-xdblog
Check messages in DBMSGORA (checkmsg)	-f cleanup -m\|-checkmsg
Confirmation mode (confirm)	-c\|-confirm
Query mode (query)	-q\|-query
Clean up selected logs only (limit)	-f cleanup -l\|-limit
Extended output (output)	-o\|-output
Message language (language)	-l\|-language
BRCONNECT command line (command)	This shows you the BRCONNECT -f cleanup command that is to be executed using the current settings.

To start processing with the selected options, choose Continue.
Check the results in the BRCONNECT logs.
- The summary log conn<DBSID>.log displays the return code.
- The detail log c<encoded timestamp>.cln displays the progress.
For more information on how to view the logs with BR*Tools, see Showing Profiles and Logs with BR*Tools.