fred 5.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162
  1. #========================================================================================================================================
  2. # crontab for uks-odbnrgtst-02
  3. # ---------------------------------------------------------------------------------------------------------------------------------------
  4. # Richard Wilson - 20.03.2017 - Database Backups.
  5. 00 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh SYSTST3 8 INCR Wed > /dev/null 2>&1
  6. 05 0-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh SYSTST3 5 ARCH > /dev/null 2>&1
  7. #
  8. 30 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh SYSTST4 8 INCR Wed > /dev/null 2>&1
  9. 20 1-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh SYSTST4 5 ARCH > /dev/null 2>&1
  10. # ---
  11. # 00 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh SIT3 8 INCR Thu > /dev/null 2>&1
  12. # 05 1-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh SIT3 5 ARCH > /dev/null 2>&1
  13. #
  14. 30 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh SIT4 8 INCR Thu > /dev/null 2>&1
  15. 20 1-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh SIT4 5 ARCH > /dev/null 2>&1
  16. # ---
  17. 00 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh GOLD3 8 INCR Sun > /dev/null 2>&1
  18. 05 1-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh GOLD3 5 ARCH > /dev/null 2>&1
  19. #
  20. 30 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh GOLD4 8 INCR Sun > /dev/null 2>&1
  21. 20 1-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh GOLD4 5 ARCH > /dev/null 2>&1
  22. # ---
  23. 00 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh UAT3 8 INCR Fri > /dev/null 2>&1
  24. 05 1-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh UAT3 5 ARCH > /dev/null 2>&1
  25. #
  26. 30 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh UAT4 8 INCR Fri > /dev/null 2>&1
  27. 20 1-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh UAT4 5 ARCH > /dev/null 2>&1
  28. # ---
  29. 00 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh TRAIN2 8 INCR Sat > /dev/null 2>&1
  30. 05 1-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh TRAIN2 5 ARCH > /dev/null 2>&1
  31. #
  32. 30 20 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh PACK3 8 INCR Sat > /dev/null 2>&1
  33. 20 1-19 * * * /home/oracle/Scripts/RMAN/RMAN_DB_Backup_v17.ksh PACK3 5 ARCH > /dev/null 2>&1
  34. #----------------------------------------------------------------------------------------------------------------------------------------
  35. # Richard Wilson - 29.04.2017 - Database Backups......principally to backup middleware schemas.
  36. 00 20 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh SYSTST3
  37. 10 20 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh SYSTST4
  38. # 20 20 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh SIT3
  39. 30 20 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh SIT4
  40. 40 20 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh UAT3
  41. 50 20 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh UAT4
  42. 00 21 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh GOLD3
  43. 10 21 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh GOLD4
  44. 20 21 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh TRAIN2
  45. 30 21 * * 5 /home/oracle/Scripts/DP/daily_expdp_v6.ksh PACK3
  46. #----------------------------------------------------------------------------------------------------------------------------------------
  47. # Richard Wilson - 20.03.2017 - Dehydrate SOA instances.
  48. */22 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh SYSTST3 >> /home/oracle/Scripts/soa_scripts/SYSTST3_soa_dehyd.log 2>&1
  49. */25 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh SYSTST4 >> /home/oracle/Scripts/soa_scripts/SYSTST4_soa_dehyd.log 2>&1
  50. # */28 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh SIT3 >> /home/oracle/Scripts/soa_scripts/SIT3_soa_dehyd.log 2>&1
  51. */31 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh SIT4 >> /home/oracle/Scripts/soa_scripts/SIT4_soa_dehyd.log 2>&1
  52. */34 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh UAT3 >> /home/oracle/Scripts/soa_scripts/UAT3_soa_dehyd.log 2>&1
  53. */37 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh UAT4 >> /home/oracle/Scripts/soa_scripts/UAT4_soa_dehyd.log 2>&1
  54. */40 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh TRAIN2 >> /home/oracle/Scripts/soa_scripts/TRAIN2_soa_dehyd.log 2>&1
  55. #----------------------------------------------------------------------------------------------------------------------------------------
  56. # Richard Wilson - 20.03.2017 - Purge old Audit Logs and Trace/Metadata Files.
  57. 00 * * * * find /u01/app/oracle/ -type f \( -name "*.trc" -o -name "*.trm" -o -name "*.aud" \) -ctime +14 -exec rm -f {} \;
  58. #----------------------------------------------------------------------------------------------------------------------------------------
  59. # Richard Wilson - 30.03.2017 - Cleanup Automatic Diagnostics Repository.
  60. 30 */4 * * * /home/oracle/Scripts/adr_cleanup.ksh > /home/oracle/Scripts/logs/adr_cleanup.log 2>&1
  61. #========================================================================================================================================