BRTOOLS: Cleaning Up Oracle DBA Logs & Tables

You can clean up the DBA logs and tables for your Oracle database with BR*Tools. This function helps you to free disk space used by old DBA logs and protects your database against unnecessary growth of the DBA tables.

1. Login to your OS level and change to <SID>adm. Execute brtools command. Select 8 – Additional functions.

BR*Tools main menu

 1 = Instance management
 2 - Space management
 3 - Segment management
 4 - Backup and database copy
 5 - Restore and recovery
 6 - Check and verification
 7 - Database statistics
 8 - Additional functions
 9 - Exit program

2. Select 2 for Clean up DBA logs and tables.

Additional BR*Tools functions

 1 = Show profiles and logs
 2 - Clean up DBA logs and tables
 3 - Adapt NEXT extents
 4 - Change password of database user
 5 - Create/change synonyms for DBA tables
 6 - Reset program status

3. Press ‘c‘ to continue with the default settings.

BRCONNECT main options for cleanup of DBA logs (1)

 1 - BRCONNECT profile (profile) ........ [initTR3.sap]
 2 - Database user/password (user) ...... [/]
 3 ~ Database owner for cleanup (owner) . []
 4 ~ BRBACKUP logs (backup) ............. [30]
 5 ~ BRARCHIVE logs (archive) ........... [30]
 6 ~ BRRESTORE logs (restore) ........... [30]
 7 ~ BRRECOVER logs (recover) ........... [30]
 8 ~ BRCONNECT logs (connect) ........... [30]
 9 ~ BRSPACE logs (space) ............... [30]

 main options for cleanup of DBA logs (2)

 1 ~ BRBACKUP disk backups (diskback) ......... [30]
 2 ~ BRARCHIVE disk backups (diskarch) ........ [30]
 3 ~ BRSPACE export dumps (expdump) ........... [30]
 4 ~ Oracle trace files (trace) ............... [30]
 5 ~ Database logs in SDBAH and SDBAD (dblog) . [100]
 6 ~ XDB logs in DBA-tables (xdblog) .......... [100]
 7 ~ Check messages in DBCHECKORA (checkmsg) .. [100]

Additional BRCONNECT options for cleanup of DBA logs

 1 - Confirmation mode (confirm) ......... [yes]
 2 - Query mode (query) .................. [no]
 3 - Clean up selected logs only (limit) . [no]
 4 - Extended output (output) ............ [no]
 5 - Message language (language) ......... [E]
 6 - BRCONNECT command line (command) ....
     [-p initTR3.sap -l E -f cleanup -b 30 -m 100]

BR0291I BRCONNECT will be started with options
'-p initTR3.sap -l E -f cleanup -b 30 -m 100'

BR0280I BRCONNECT time stamp: 2011-04-08 21.24.36
BR0813I Schema owners found in database TR3: SAPSR3*, SAPSR3DB%

BR0280I BRCONNECT time stamp: 2011-04-08 21.24.36
BR0807I Name of database instance: TR3
BR0808I BRCONNECT action ID: cefptpod
BR0809I BRCONNECT function ID: cln
BR0810I BRCONNECT function: cleanup
..
...
.....

4. Press ‘c‘ again to continue performing the DBA clean ups. You will receive ” Execution of BRCONNECT finished with return code 0″ message when all the clean up process is done.

BR0280I BRCONNECT time stamp: 2011-04-08 21.25.27
BR0944I 0 backup/copy directories deleted (based on logs) from /oracle/TR3/sapbackup

BR0280I BRCONNECT time stamp: 2011-04-08 21.25.27
BR0946I 0 export directories deleted (based on logs) from /oracle/TR3/sapreorg

BR0280I BRCONNECT time stamp: 2011-04-08 21.25.27
BR0948I 0 rows deleted from table SAPSR3.DBADFL

..
...
....

BR0806I End of BRCONNECT processing: cefptpod.cln 2011-04-08 21.25.27
BR0280I BRCONNECT time stamp: 2011-04-08 21.25.27
BR0802I BRCONNECT completed successfully

###############################################################################

BR0292I Execution of BRCONNECT finished with return code 0