Startsida Utforska Hjälp
Registrera dig Logga in
neal
/
scripts
1
0
Fork 0
Filer Ärenden 0 Pull-förfrågningar 0 Wiki
Träd: 32e3985109
Grenar Taggar
scripts
/
LJCOPY
/
RMAN
/
fred

fred 9.7 KB
Historik Rå

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283 
  1. #=================================================================================================================================================================
    2. 

  2. # crontab for uks-odbnrgtst-02
    3. 

  3. # ----------------------------------------------------------------------------------------------------------------------------------------------------------------
    4. 

  4. # Richard Wilson - 20.04.2017 - RMAN Database Backups.
    5. 

  5. 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
    6. 

  6. 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
    7. 

  7. # 
    8. 

  8. 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
    9. 

  9. 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
    10. 

  10. # ----------------------------------------------------------------------------------------------------------------------------------------------------------------
    11. 

  11. ## 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
    12. 

  12. ## 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
    13. 

  13. #
    14. 

  14. 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
    15. 

  15. 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
    16. 

  16. # ----------------------------------------------------------------------------------------------------------------------------------------------------------------
    17. 

  17. 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
    18. 

  18. 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
    19. 

  19. #
    20. 

  20. 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
    21. 

  21. 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
    22. 

  22. # ----------------------------------------------------------------------------------------------------------------------------------------------------------------
    23. 

  23. ## 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
    24. 

  24. ## 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
    25. 

  25. #
    26. 

  26. 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
    27. 

  27. 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
    28. 

  28. # ----------------------------------------------------------------------------------------------------------------------------------------------------------------
    29. 

  29. ## 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
    30. 

  30. ## 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
    31. 

  31. # ----------------------------------------------------------------------------------------------------------------------------------------------------------------
    32. 

  32. 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
    33. 

  33. 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
    34. 

  34. #
    35. 

  35. 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
    36. 

  36. 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
    37. 

  37. # ----------------------------------------------------------------------------------------------------------------------------------------------------------------
    38. 

  38. 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
    39. 

  39. 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. 

  40. #
    41. 

  41. 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
    42. 

  42. 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
    43. 

  43. # ----------------------------------------------------------------------------------------------------------------------------------------------------------------
    44. 

  44. # Databases we can no longer backup due to insufficient space.
    45. 

  45. 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
    46. 

  46. 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
    47. 

  47. 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
    48. 

  48. #----------------------------------------------------------------------------------------------------------------------------------------------------------------
    49. 

  49. # Richard Wilson - 07.06.2017 - Data Pump Database Backups.
    50. 

  50. 00 20 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh SYSTST3	> /dev/null 2>&1
    51. 

  51. 10 20 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh SYSTST4	> /dev/null 2>&1
    52. 

  52. 20 20 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh SIT3 	> /dev/null 2>&1
    53. 

  53. 30 20 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh SIT4 	> /dev/null 2>&1
    54. 

  54. 40 20 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh UAT3 	> /dev/null 2>&1
    55. 

  55. 50 20 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh UAT4 	> /dev/null 2>&1
    56. 

  56. 00 21 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh GOLD3 	> /dev/null 2>&1
    57. 

  57. 10 21 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh GOLD4 	> /dev/null 2>&1
    58. 

  58. 20 21 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh TRAIN2 	> /dev/null 2>&1
    59. 

  59. 30 21 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh PACK3 	> /dev/null 2>&1
    60. 

  60. 40 21 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh PACK4   > /dev/null 2>&1
    61. 

  61. 50 21 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh DEV     > /dev/null 2>&1
    62. 

  62. 00 22 * * 5 /home/oracle/Scripts/DP/weekly_expdp_v1.ksh DEVX    > /dev/null 2>&1
    63. 

  63. #----------------------------------------------------------------------------------------------------------------------------------------------------------------
    64. 

  64. # Richard Wilson - 20.03.2017 - Dehydrate SOA instances.
    65. 

  65. */22 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh SYSTST3 >> /home/oracle/Scripts/soa_scripts/SYSTST3_soa_dehyd.log 2>&1
    66. 

  66. */25 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh SYSTST4 >> /home/oracle/Scripts/soa_scripts/SYSTST4_soa_dehyd.log 2>&1
    67. 

  67. */28 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh SIT3    >> /home/oracle/Scripts/soa_scripts/SIT3_soa_dehyd.log 2>&1
    68. 

  68. */31 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh SIT4    >> /home/oracle/Scripts/soa_scripts/SIT4_soa_dehyd.log 2>&1
    69. 

  69. */34 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh UAT3    >> /home/oracle/Scripts/soa_scripts/UAT3_soa_dehyd.log 2>&1
    70. 

  70. */37 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh UAT4    >> /home/oracle/Scripts/soa_scripts/UAT4_soa_dehyd.log 2>&1
    71. 

  71. */40 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh PACK3   >> /home/oracle/Scripts/soa_scripts/PACK3_soa_dehyd.log 2>&1
    72. 

  72. */44 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh PACK4   >> /home/oracle/Scripts/soa_scripts/PACK4_soa_dehyd.log 2>&1
    73. 

  73. */48 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh TRAIN2  >> /home/oracle/Scripts/soa_scripts/TRAIN2_soa_dehyd.log 2>&1
    74. 

  74. */52 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh DEV     >> /home/oracle/Scripts/soa_scripts/DEV_soa_dehyd.log 2>&1
    75. 

  75. */56 * * * * /home/oracle/Scripts/soa_scripts/soa_dehyd_v1.ksh DEVX    >> /home/oracle/Scripts/soa_scripts/DEVX_soa_dehyd.log 2>&1
    76. 

  76. #------------------------------------------------------------------------------------------------------------------------------------------------
    77. 

  77. # Richard Wilson - 20.03.2017 - Purge old Audit Logs and Trace/Metadata Files.
    78. 

  78. 10 */2 * * * find /u01/app/oracle/ -type f \( -name "*.trc" -o -name "*.trm" -o -name "*.aud" \) -ctime +28 -exec rm -f {} \;
    79. 

  79. #------------------------------------------------------------------------------------------------------------------------------------------------
    80. 

  80. # Richard Wilson - 30.03.2017 - Cleanup Automatic Diagnostics Repository.
    81. 

  81. 30 */4 * * * /home/oracle/Scripts/adr_cleanup.ksh > /home/oracle/Scripts/logs/adr_cleanup.log 2>&1
    82. 

  82. #================================================================================================================================================
    83. 

  83.