oracledba.help
Scripts

DBA Script

<- Scripts

#!/bin/bash

# Cfg
me=$(basename ""$0"")
nRMAN=45;
nExports=30;

# Start
clear;printf "$me: Started $(date "+%Y-%m-%d %H:%M:%S")\n"

###########
# Exports #
#####################################################################################
printf "Sweeping Export Files...\n\n"
find /u01/datapump/dnaprod -maxdepth 1 -type f -name '*.dmp' -mtime +$nExports -delete


##############
# RMAN Files #
#####################################################################################
printf "Sweeping RMAN Files...\n\n"
find /u01/backup/autoprod -maxdepth 1 -type f -name '*.rman' -mtime +$nRMAN -delete
find /u01/backup/dnaprod  -maxdepth 1 -type f -name '*.rman' -mtime +$nRMAN -delete

# End
printf "$me: Ended $(date "+%Y-%m-%d %H:%M:%S")\n"