Cleaning Up DBA Logs and Tables with BR*Tools 

Use

You can clean up the DBA logs and tables for your Oracle database with BR*Tools.

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

For more information, see Clean Up Old Logs and Trace Files with BRCONNECT.

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.

Procedure

...

       1.      Start BRGUI or BRTOOLS.

       2.      Choose Additional functions → Clean up DBA logs and tables.

       3.      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-function cleanup -t|-trace
Database logs in SDBAH and SDBAD (dblog)	-f-function cleanup -d|-dblog
XDB logs in DBA tables (xdblog)	-f-function cleanup -x|-xdblog
Check messages in DBCHECKORA (checkmsg)	-f-function cleanup -m|-checkmsg
Confirmation mode (confirm)	-c|-confirm
Query mode (query)	-q|-query
Clean up selected logs only (limit)	-f-function 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.

       4.      To start processing with the selected options, choose Continue.

       5.      Check the results in the BRCONNECT logs.

¡        The summary log conn<DBSID>.logdisplays 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 Logs with BR*Tools.