Clean Up Old Logs and Traces with BRCONNECT (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Clean Up Old Logs and Traces with BRCONNECT

Use

You can use BRCONNECT to clean up old log files, disk backups, export files, trace files and database logs. The aim is to avoid unnecessary use of disk space by deleting files that are no longer required.

Recommendation

We strongly recommend you to use this BRCONNECT function rather than the equivalent SAPDBA one, sapdba -cleanup. The reason is that we will in future no longer develop the SAPDBA functions, whereas BRCONNECT functions will always be fully up-to-date.

Features

BRCONNECT cleans up the following files:

Detailed BRARCHIVE logs in the saparch directory

Detailed BRBACKUP logs in the sapbackup directory

Detailed BRCONNECT logs in the sapcheck directory

Detailed BRRESTORE logs in the sapbackup directory

Detailed SAPDBA logs in the sapreorg directory

BRBACKUP disk backups of the database files

BRARCHIVE disk backups of the offline redo log files

SAPDBA export dump and export script directories

Oracle trace and audit files

Log records in the SDBAH and SDBAD tables

Log records in the XDB tables

Database check results in DBMSGORA table

Activities

Using the cleanup parameters in the Initialization Profile init<DBSID>.sap you can determine how old the objects are before they are deleted. For example, see cleanup_brarchive_log.

For more information on the command line options for cleaning up the log files, see -f cleanup.