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.