Cleaning Up DBA Logs and Tables with BR*Tools

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.

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.

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.