#=================================================================================================================================================================
# crontab for uks-odbnrgtst-02
# ----------------------------------------------------------------------------------------------------------------------------------------------------------------
# Richard Wilson - 20.04.2017 - RMAN Database Backups.
00 20   * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v32.ksh SYSTST3 7 INCR Wed) >> /home/oracle/Scripts/RMAN/logs/SYSTST3_INCR_history.log 2>&1
05 0-19 * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v32.ksh SYSTST3 3 ARCH)     >> /home/oracle/Scripts/RMAN/logs/SYSTST3_ARCH_history.log 2>&1
# 
30 20   * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v32.ksh SYSTST4 7 INCR Wed) >> /home/oracle/Scripts/RMAN/logs/SYSTST4_INCR_history.log 2>&1
20 1-19 * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v32.ksh SYSTST4 3 ARCH)     >> /home/oracle/Scripts/RMAN/logs/SYSTST4_ARCH_history.log 2>&1
# ----------------------------------------------------------------------------------------------------------------------------------------------------------------
## RW 00 20   * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v24.ksh SIT3    7 INCR Thu) >> /home/oracle/Scripts/RMAN/logs/SIT3_INCR_history.log 2>&1
## RW 05 1-19 * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v24.ksh SIT3    3 ARCH)     >> /home/oracle/Scripts/RMAN/logs/SIT3_ARCH_history.log 2>&1
#
30 20   * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v32.ksh SIT4    7 INCR Tue) >> /home/oracle/Scripts/RMAN/logs/SIT4_INCR_history.log 2>&1
20 1-19 * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v32.ksh SIT4    1 ARCH)     >> /home/oracle/Scripts/RMAN/logs/SIT4_ARCH_history.log 2>&1
# ----------------------------------------------------------------------------------------------------------------------------------------------------------------
00 20 * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v102.ksh GOLD3  7 INCR Sat CAT) >> /home/oracle/Scripts/RMAN/logs/GOLD3_INCR_history.log 2>&1
05 *  * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v102.ksh GOLD3  3 ARCH Sat CAT) >> /home/oracle/Scripts/RMAN/logs/GOLD3_ARCH_history.log 2>&1
#
30 20 * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v102.ksh GOLD4  7 INCR Sun CAT) >> /home/oracle/Scripts/RMAN/logs/GOLD4_INCR_history.log 2>&1
35 *  * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v102.ksh GOLD4  3 ARCH Sun CAT) >> /home/oracle/Scripts/RMAN/logs/GOLD4_ARCH_history.log 2>&1
# ----------------------------------------------------------------------------------------------------------------------------------------------------------------
## RW 00 20   * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v24.ksh UAT3    7 INCR Fri) >> /home/oracle/Scripts/RMAN/logs/UAT3_INCR_history.log 2>&1
## RW 05 1-19 * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v24.ksh UAT3    3 ARCH)     >> /home/oracle/Scripts/RMAN/logs/UAT3_ARCH_history.log 2>&1
#
30 20   * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v32.ksh UAT4    7 INCR Fri) >> /home/oracle/Scripts/RMAN/logs/UAT4_INCR_history.log 2>&1
20 1-18 * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v32.ksh UAT4    1 ARCH)     >> /home/oracle/Scripts/RMAN/logs/UAT4_ARCH_history.log 2>&1
# ----------------------------------------------------------------------------------------------------------------------------------------------------------------
## RW 00 20   * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v24.ksh TRAIN2  7 INCR Sat) >> /home/oracle/Scripts/RMAN/logs/TRAIN2_INCR_history.log 2>&1
## RW 05 1-19 * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v24.ksh TRAIN2  3 ARCH)     >> /home/oracle/Scripts/RMAN/logs/TRAIN2_ARCH_history.log 2>&1
# ----------------------------------------------------------------------------------------------------------------------------------------------------------------
00 20   * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v32.ksh DEV  	  7 INCR Sat) >> /home/oracle/Scripts/RMAN/logs/DEV_INCR_history.log 2>&1
05 1-19 * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v32.ksh DEV     3 ARCH)     >> /home/oracle/Scripts/RMAN/logs/DEV_ARCH_history.log 2>&1
#
00 20   * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v32.ksh DEVX    7 INCR Mon) >> /home/oracle/Scripts/RMAN/logs/DEVX_INCR_history.log 2>&1
05 1-19 * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v32.ksh DEVX    3 ARCH)     >> /home/oracle/Scripts/RMAN/logs/DEVX_ARCH_history.log 2>&1
# ----------------------------------------------------------------------------------------------------------------------------------------------------------------
30 20   * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v32.ksh PACK3   7 INCR Sat) >> /home/oracle/Scripts/RMAN/logs/PACK3_INCR_history.log 2>&1
20 1-19 * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v32.ksh PACK3   3 ARCH)     >> /home/oracle/Scripts/RMAN/logs/PACK3_ARCH_history.log 2>&1
#
40 20   * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v32.ksh PACK4   7 INCR Sun) >> /home/oracle/Scripts/RMAN/logs/PACK4_INCR_history.log 2>&1
20 1-19 * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Backup_v32.ksh PACK4   3 ARCH)     >> /home/oracle/Scripts/RMAN/logs/PACK4_ARCH_history.log 2>&1
# ----------------------------------------------------------------------------------------------------------------------------------------------------------------
# Databases we can no longer backup due to insufficient space.
00 02 * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Cleardown_v5.ksh SIT3   1) >> /home/oracle/Scripts/RMAN/logs/SIT3_DB_Cleardown_history.log 2>&1
00 03 * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Cleardown_v5.ksh UAT3   2) >> /home/oracle/Scripts/RMAN/logs/UAT3_DB_Cleardown_history.log 2>&1
00 04 * * * (/bin/date;/home/oracle/Scripts/RMAN/RMAN_DB_Cleardown_v5.ksh TRAIN2 5) >> /home/oracle/Scripts/RMAN/logs/TRAIN2_DB_Cleardown_history.log 2>&1
#----------------------------------------------------------------------------------------------------------------------------------------------------------------
# Richard Wilson - 07.06.2017 - Data Pump Database Backups.
00 20 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh SYSTST3	> /dev/null 2>&1
10 20 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh SYSTST4	> /dev/null 2>&1
20 20 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh SIT3 	> /dev/null 2>&1
30 20 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh SIT4 	> /dev/null 2>&1
40 20 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh UAT3 	> /dev/null 2>&1
50 20 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh UAT4 	> /dev/null 2>&1
00 21 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh GOLD3 	> /dev/null 2>&1
10 21 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh GOLD4 	> /dev/null 2>&1
20 21 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh TRAIN2 	> /dev/null 2>&1
30 21 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh PACK3 	> /dev/null 2>&1
40 21 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh PACK4   > /dev/null 2>&1
50 21 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh DEV     > /dev/null 2>&1
00 22 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh DEVX    > /dev/null 2>&1
#----------------------------------------------------------------------------------------------------------------------------------------------------------------
# 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 PACK3   >> /home/oracle/Scripts/soa_scripts/PACK3_soa_dehyd.log 2>&1
*/44 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh PACK4   >> /home/oracle/Scripts/soa_scripts/PACK4_soa_dehyd.log 2>&1
*/48 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh TRAIN2  >> /home/oracle/Scripts/soa_scripts/TRAIN2_soa_dehyd.log 2>&1
*/52 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh DEV     >> /home/oracle/Scripts/soa_scripts/DEV_soa_dehyd.log 2>&1
*/56 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh DEVX    >> /home/oracle/Scripts/soa_scripts/DEVX_soa_dehyd.log 2>&1
#------------------------------------------------------------------------------------------------------------------------------------------------
# Richard Wilson - 20.03.2017 - Purge old Audit Logs and Trace/Metadata Files.
10 */2 * * * find /u01/app/oracle/ -type f \( -name "*.trc" -o -name "*.trm" -o -name "*.aud" \) -ctime +28 -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
#================================================================================================================================================

