-f cleanup (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

-f cleanup

This BRCONNECT function cleans up the database logs. For more information, see Clean Up Old Logs and Traces.

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.

Function options:

-a|-archive: Defines the retention period in days for BRARCHIVE detail log files

Input syntax: -a <days>

Default: 30

This option controls which BRARCHIVE log files are deleted by the BRCONNECT cleanup function. It overrides the cleanup_brarchive_log parameter.

-b|backup: Defines the retention period in days for BRBACKUP detail log files

Input syntax: -b <days>

Default: 30

This option controls which BRBACKUP log files are deleted by the BRCONNECT cleanup function. It overrides the cleanup_brbackup_log parameter.

-c|-connect: Defines the retention period in days for BRCONNECT detail log files

Input syntax: -c <days>

Default: 30

This option controls which BRCONNECT log files are deleted by the BRCONNECT cleanup function. It overrides the cleanup_brconnect_log parameter

-d|-dblog: Defines the retention period in days for records in the tables SDBAH and SDBAD

Input syntax: -d <days>

Default: 100

This option controls which records in the tables SDBAH and SDBAD are deleted by the BRCONNECT cleanup function. It overrides the cleanup_db_log parameter.

-e|-expdump: Defines the retention period in days for SAPDBA export dumps and scripts

Input syntax: -e <days>

Default: 30

This option controls which directories and their contents for SAPDBA export dumps and scripts are deleted by the BRCONNECT cleanup function. It overrides the cleanup_exp_dump parameter.

-i|-diskarch: Defines the retention period for offline redo log files saved on disk.

Input syntax: -i <days>

Default: 30

This option controls which offline redo log files backed up on disk are deleted by the BRCONNECT cleanup function. It overrides the cleanup_disk_archive parameter.

-k|-diskback: Defines the retention period in days for database files saved on disk.

Input syntax: -k <days>

Default: 30

This option controls which database files backed up on disk are deleted by the BRCONNECT cleanup function. It overrides the cleanup_disk_backup parameter.

-l|-limit: Defines that only objects explicitly specified by other function options are to be cleaned up

Input syntax: -l

Default: Clean up all database logs

-m|-msg: This parameter defines the retention period in days for the alert messages from the database check runs. The messages are deleted from the DBMSGORA table when the retention period has expired.

This option overrides the cleanup_check_msg parameter.

-o|-owner: Defines the database owner of SDBAH, SDBA, DBMSGORA, and XDB tables to be processed by BRCONNECT cleanup function.

Input syntax: -o <owner1>[,<owner2>,...]

Default: SAPR3/SAP<SID> in a standard SAP database or all SAP owners in a multi-schema database

This option overrides the cleanup_owner parameter.

-r|-restore: Defines the retention period in days for BRRESTORE detail log files

Input syntax: -r <days>

Default: 30

This option controls which BRRESTORE log files are deleted by the BRCONNECT cleanup function. It overrides the cleanup_brrestore_log parameter.

-s|-sapdba: Defines the retention period in days for SAPDBA log files

Input syntax: -s <days>

Default: 30

This option controls which SAPDBA log files are deleted by the BRCONNECT cleanup function. It overrides the cleanup_sapdba_log parameter.

-t|-trace: Defines the retention period in days for Oracle trace and audit files

Input syntax: -t <days>

Default: 30

This option controls which Oracle trace and audit files are deleted by the BRCONNECT cleanup function. It overrides the cleanup_ora_trace parameter.

-x|-xdb: Defines the retention period in days for records in the XDB tables

Input syntax: -x <days>

Default: 100

This option controls which records in the XDB tables are deleted by the BRCONNECT cleanup function. It overrides the cleanup_xdb_log parameter.