#!/bin/bash
#
# Purpose: This script will help in deleting the audit, trace and xml files which are older than 7 days for Database, ASM and Listeners 
# Note: This script is written in consideration of RAC node1 and database Name - CDBDB
# AUTHOR: Mallikarjun Ramadurg
# SCRIPT Name: delete_aud_node1.sh
# Usage: Run this script at OS level using shell execution
# Example: sh delete_aud_node1.sh
#

#delete database audit files from RAC node1
find /u01/app/oracle/admin/CDBDB/adump -type f -mtime +7 -name '*.aud' -exec rm -f {} \;

#diag or trace or xml
#delete database xml, trc files from RAC node1
find /u01/app/oracle/diag/rdbms/cdbdb/CDBDB1/trace -type f -mtime +7 -name '*.trc' -exec rm -f {} \;
find /u01/app/oracle/diag/rdbms/cdbdb/CDBDB1/trace -type f -mtime +7 -name '*.trm' -exec rm -f {} \;
find /u01/app/oracle/diag/rdbms/cdbdb/CDBDB1/alert -type f -mtime +7 -name '*.xml' -exec rm -f {} \;
find /u01/app/oracle/diag/rdbms/cdbdb/CDBDB1/incident -type d -mtime +7 -name 'incdir_*' -exec rm -rf {} \;

#ASM
#delete ASM & Listener xml, trc files from RAC node1
find /u01/app/oracle/diag/crs/node1/crs/trace -type f -mtime +7 -name '*.trc' -exec rm -f {} \;
find /u01/app/oracle/diag/crs/node1/crs/trace -type f -mtime +7 -name '*.trm' -exec rm -f {} \;
find /u01/app/oracle/diag/crs/node1/crs/trace -type f -mtime +7 -name 'alert.log' -exec rm -f {} \;
find /u01/app/oracle/diag/tnslsnr/node1/asmnet1lsnr_asm/trace -type f -mtime +7 -name 'asmnet1lsnr_asm_*.log' -exec rm -f {} \;
find /u01/app/oracle/diag/tnslsnr/node1/asmnet1lsnr_asm/alert -type f -mtime +7 -name 'log_*.xml' -exec rm -f {} \;
find /u01/app/oracle/diag/tnslsnr/node1/listener/trace -type f -mtime +7 -name 'listener_*.log' -exec rm -f {} \;
find /u01/app/oracle/diag/tnslsnr/node1/listener/alert -type f -mtime +7 -name 'log_*.xml' -exec rm -f {} \;
find /u01/app/oracle/diag/tnslsnr/node1/listener_scan1/alert -type f -mtime +7 -name 'log_*.xml' -exec rm -f {} \;
find /u01/app/oracle/diag/tnslsnr/node1/listener_scan1/trace -type f -mtime +7 -name 'listener_scan1_*.log' -exec rm -f {} \;
find /u01/app/oracle/diag/tnslsnr/node1/listener_scan2/alert -type f -mtime +7 -name 'log_*.xml' -exec rm -f {} \;
find /u01/app/oracle/diag/tnslsnr/node1/listener_scan2/trace -type f -mtime +7 -name 'listener_scan2_*.log' -exec rm -f {} \;
find /u01/app/oracle/diag/tnslsnr/node1/listener_scan3/alert -type f -mtime +7 -name 'log_*.xml' -exec rm -f {} \;
find /u01/app/oracle/diag/tnslsnr/node1/listener_scan3/trace -type f -mtime +7 -name 'listener_scan3_*.log' -exec rm -f {} \;