Show TOC Start of Content Area

Syntax documentation -f cleanup  Locate the document in its SAP Library structure

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

Function options:

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

Input syntax: -a|-archive <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|-backup <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|-connect <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|-dblog <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 BRSPACE export dumps and scripts

Input syntax: -e|-expdump <days>

Default: 30

This option controls which directories and their contents for BRSPACE export dumps and parameter files 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|-diskarch <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|-diskback <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|-limit

Default: Clean up all database logs

·        -m|-checkmsg: 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.

Input syntax: -m|-checkmsg <days>

Default: 100

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|-owner <owner1>[,<owner2>,...]

Default: SAPR3/SAP<SAPSID> 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|-restore <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|-space: Defines the retention period in days for BRSPACE log files

Input syntax: -s|-space <days>

Default: 30

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

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

Input syntax: -t|-trace <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.

·        -v|-recover: Defines the retention period in days for BRRECOVER detail log files

Input syntax: -v|-recover <days>

Default: 30

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

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

Input syntax: -x|-xdb <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.

 

End of Content Area