#========================================================================================================================================
# 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
#========================================================================================================================================

