Show TOC

Procedure documentationCleaning Up DBA Logs and Tables with BR*Tools Locate this document in the navigation structure

 

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

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

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.

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

    2. 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 Logs with BR*Tools.