#======================================================================================================================================== # crontab for uks-odbnrgtst-02 # --------------------------------------------------------------------------------------------------------------------------------------- # Richard Wilson - 20.03.2017 - Database Backups. 00 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh SYSTST3 8 INCR Wed > /dev/null 2>&1 05 0-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh SYSTST3 5 ARCH > /dev/null 2>&1 # 30 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh SYSTST4 8 INCR Wed > /dev/null 2>&1 20 1-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh SYSTST4 5 ARCH > /dev/null 2>&1 # --- # 00 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh SIT3 8 INCR Thu > /dev/null 2>&1 # 05 1-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh SIT3 5 ARCH > /dev/null 2>&1 # 30 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh SIT4 8 INCR Thu > /dev/null 2>&1 20 1-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh SIT4 5 ARCH > /dev/null 2>&1 # --- 00 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh GOLD3 8 INCR Sun > /dev/null 2>&1 05 1-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh GOLD3 5 ARCH > /dev/null 2>&1 # 30 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh GOLD4 8 INCR Sun > /dev/null 2>&1 20 1-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh GOLD4 5 ARCH > /dev/null 2>&1 # --- 00 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh UAT3 8 INCR Fri > /dev/null 2>&1 05 1-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh UAT3 5 ARCH > /dev/null 2>&1 # 30 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh UAT4 8 INCR Fri > /dev/null 2>&1 20 1-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh UAT4 5 ARCH > /dev/null 2>&1 # --- 00 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh TRAIN2 8 INCR Sat > /dev/null 2>&1 05 1-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh TRAIN2 5 ARCH > /dev/null 2>&1 # 30 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh PACK3 8 INCR Sat > /dev/null 2>&1 20 1-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh PACK3 5 ARCH > /dev/null 2>&1 #---------------------------------------------------------------------------------------------------------------------------------------- # Richard Wilson - 29.04.2017 - Database Backups......principally to backup middleware schemas. 00 20 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh SYSTST3 10 20 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh SYSTST4 # 20 20 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh SIT3 30 20 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh SIT4 40 20 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh UAT3 50 20 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh UAT4 00 21 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh GOLD3 10 21 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh GOLD4 20 21 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh TRAIN2 30 21 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh PACK3 #---------------------------------------------------------------------------------------------------------------------------------------- # Richard Wilson - 20.03.2017 - Dehydrate SOA instances. */22 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh SYSTST3 >> /home/oracle/Scripts/soa_scripts/SYSTST3_soa_dehyd.log 2>&1 */25 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh SYSTST4 >> /home/oracle/Scripts/soa_scripts/SYSTST4_soa_dehyd.log 2>&1 # */28 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh SIT3 >> /home/oracle/Scripts/soa_scripts/SIT3_soa_dehyd.log 2>&1 */31 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh SIT4 >> /home/oracle/Scripts/soa_scripts/SIT4_soa_dehyd.log 2>&1 */34 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh UAT3 >> /home/oracle/Scripts/soa_scripts/UAT3_soa_dehyd.log 2>&1 */37 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh UAT4 >> /home/oracle/Scripts/soa_scripts/UAT4_soa_dehyd.log 2>&1 */40 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh TRAIN2 >> /home/oracle/Scripts/soa_scripts/TRAIN2_soa_dehyd.log 2>&1 #---------------------------------------------------------------------------------------------------------------------------------------- # Richard Wilson - 20.03.2017 - Purge old Audit Logs and Trace/Metadata Files. 00 * * * * find /u01/app/oracle/ -type f \( -name "*.trc" -o -name "*.trm" -o -name "*.aud" \) -ctime +14 -exec rm -f {} \; #---------------------------------------------------------------------------------------------------------------------------------------- # Richard Wilson - 30.03.2017 - Cleanup Automatic Diagnostics Repository. 30 */4 * * * /home/oracle/Scripts/adr_cleanup.ksh > /home/oracle/Scripts/logs/adr_cleanup.log 2>&1 #========================================================================================================================================