Show/Cleanup to Manage Logs and Profiles with SAPDBA (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Show/Cleanup to Manage Logs and Profiles with SAPDBA

Purpose

You manage the logs and profiles in your Oracle database with SAPDBA. You can display the logs and profiles, as well as delete them when no longer required.

Prerequisites

You need to know how to use SAPDBA and to have set it up correctly. Refer to Getting Started with SAPDBA.

Process Flow

You choose Show/Cleanup ® Show log files / profiles in SAPDBA to:

Show log files

SAPDBA log files

Logs generated by the commands sapdba -check, -checkopt, -analyze or –next . Refer to SAPDBA Command Mode.

Central Log reorg<DBSID>.log

Structure Log

BRBACKUP logs and BRARCHIVE logs

Show profiles:

Initialization Profile init<DBSID>.dba for SAPDBA

Initialization Profile init<DBSID>.sap for BRBACKUP, BRARCHIVE, and BRRESTORE

Oracle initialization profile init<DBSID>.ora

You choose Show/Cleanup ® Cleanup log files / directories to delete log, directory, audit, and trace files in SAPDBA as follows:

SAPDBA log files and directories

BRBACKUP logs and BRARCHIVE logs

Oracle trace files, audit logs

For an overview of the logs written by the SAP utilities, see SAPDBA log files and their contents and Logs for BRBACKUP, BRARCHIVE, BRRESTORE, and BRCONNECT.