# vmspd1 RMAN backup schedule 00 2 * * 0 $HOME/rman_scripts/run_rman_script $HOME/rman_scripts/12cR1_level0.rcv vmspd1 &> /dev/null 00 2 * * 1-6 $HOME/rman_scripts/run_rman_script $HOME/rman_scripts/12cR1_arclogs.rcv vmspd1 &> /dev/null # Datapipe tablespace monitor ticket TKT0206630 00,30 * * * * /home/oracle/dpmon/refresh_tablespace_chart.sh vmspd1 ePo1CuVaeE &> /dev/null # vmspvw1 RMAN backup schedule 00 3 * * 0 $HOME/rman_scripts/run_rman_script $HOME/rman_scripts/12cR1_level0.rcv vmspvw1 &> /dev/null 00 3 * * 1-6 $HOME/rman_scripts/run_rman_script $HOME/rman_scripts/12cR1_arclogs.rcv vmspvw1 &> /dev/null # vmssp1 RMAN backup schedule 00 4 * * 0 $HOME/rman_scripts/run_rman_script $HOME/rman_scripts/12cR1_level0.rcv vmssp1 &> /dev/null 00 4 * * 1-6 $HOME/rman_scripts/run_rman_script $HOME/rman_scripts/12cR1_arclogs.rcv vmssp1 &> /dev/null # vmscfg1 RMAN backup schedule 00 5 * * 0 $HOME/rman_scripts/run_rman_script $HOME/rman_scripts/12cR1_level0.rcv vmscfg1 &> /dev/null 00 5 * * 1-6 $HOME/rman_scripts/run_rman_script $HOME/rman_scripts/12cR1_arclogs.rcv vmscfg1 &> /dev/null #Tim Guinn Schedule Stats 5/19/2015 0 4 * * 6 $HOME/bin/gather_vmspd_stat.sh vmspd &> /dev/null #Weekly pscbo_stats - sync_schema_stats 0,30 22 * * * $HOME/bin/gather_vmspd_stat_daily.sh vmspd &> /dev/null #Daily pscbo_stats - sync_schema_stats # ticket 2274690 addm report for VMSPD # Comment due to script not found # 00 1 * * 0 $HOME/bin/send_addm.sh vmspd &> /dev/null # ticket 2274690 # Comment due to script not found # 02 18 * * * $HOME/bin/ts_report.sh vmspd &> /dev/null # ticket 1796114 40 2 * * * /u01/app/oracle/admin/vmspd/sql/psread_build.sh &>/dev/null 45 2 * * * /u01/app/oracle/admin/vmspd/sql/pswrite_build.sh &>/dev/null # TASK0026483 suspended RMAN Clone of VMSSP 5.13.2016 # resumed on 5.16.2016 # TASK0080186 suspend clone 3.16.2017 # resumed on 3.19.2017 # TASK0085834 suspend clone 4.13.2017 # resumed on 4.16.2017 # TASK0091773 suspend clone 5.11.2017 # resumed on 5.14.2017 # TASK0104032 suspend clone 7.14.2017 # resumed on 7.17.2017 # TASK0130445 suspend clone 11.16.2017 # resumed on 11.19.2017 # # TASK0163537 suspend the RMAN clone of vmspd to VMSSP scheduled for this Friday night 5/11/2018,enable the entry on 5/14/2018 00 22 * * 1,3,5 $HOME/bin/clone_vmspd_local_copy.sh vmssp &> /dev/null # INC0181472 rerun job # 55 23 * * * $HOME/bin/clone_vmspd_local_copy.sh vmssp &> /dev/null # CHG0089630 One Time Off Cycle RMAN clone VMSPD to VMSSP # 00 20 31 5 * $HOME/bin/clone_vmspd_local_copy.sh vmssp &> /dev/null # 00 3 15 5 * $HOME/bin/clone_vmspd_local_copy.sh vmssp &> /dev/null ### TKT0236957 ### 00 03 20 03 * $HOME/bin/clone_vmspd_local_copy.sh vmssp &> /dev/null # TKT0223518 one time clone #30 14 17 12 4 $HOME/bin/clone_vmspd_local_copy.sh vmspvw &> /dev/null #-------------------------------------------------------------------- # Entry for PWD check-T.Guinn 7/8/2011 #-------------------------------------------------------------------- 0,5,10,15,20,25,30,35,40,45,50,55 * * * * /home/dba/bin/runsql vmspd oprchk &> /dev/null #-------------------------------------------------------------------- # #-------------------------------------------------------------------- # Entry for checking long running BI SQL - T.Guinn 7/8/2011 #-------------------------------------------------------------------- 0,15,30,45 * * * * /home/dba/bin/runsql vmspd kill &> /home/dba/log/kill.log #-------------------------------------------------------------------- # ticekt TKT0164658 # 00 6 16 1 * $HOME/bin/clone_vmspd_remote_devora2.sh VMSSTG &> /dev/null # TKT0218042 # 55 00 17 11 * $HOME/bin/clone_vmspd_remote_devora2.sh SUPDV &> /dev/null # TKT0219456 # 41 12 24 11 * $HOME/bin/clone_vmspd_remote_devora2.sh SUPDV &> /dev/null # TKT0220150 one time clone # 00 21 30 11 * $HOME/bin/clone_vmspd_remote_devora2.sh RELDV &> /dev/null # TKT0220735 one time clone # 30 17 02 12 * $HOME/bin/clone_vmspd_remote_devora2.sh RELTS &> /dev/null # TKT0225663 # 00 13 5 1 * $HOME/bin/clone_vmspd_local_copy.sh vmscfg &> /dev/null # TASK0021283 # 00 17 5 4 * $HOME/bin/clone_vmspd_local_copy.sh vmscfg &> /dev/null # TKT0226097 # 00 15 8 1 * $HOME/bin/savepoint_full_11gDB_mail.sh vmscfg1 VMSCFG &> /dev/null # TKT0230970 # 30 23 03 02 * $HOME/bin/clone_vmspd_remote_devora3.sh INFRA &> /dev/null # TKT0232129 # 30 23 10 02 * $HOME/bin/clone_vmspd_remote_devora3.sh INFRA &> /dev/null # TASK0019249 # 43 15 21 03 * $HOME/bin/clone_vmspd_remote_devora3.sh RELTS &> /dev/null # TKT0236104 # 00 15 11 3 * $HOME/bin/savepoint_full_11gDB_mail.sh vmspvw1 VMSPVW &> /dev/null # TASK0025788 # 00 15 6 5 * $HOME/bin/savepoint_full_11gDB_mail.sh vmscfg1 VMSCFG &> /dev/null # TASK0030830 # 00 6 12 6 * $HOME/bin/clone_vmspd_remote_devora3.sh SUPDV &> /dev/null # 40 7 12 6 * $HOME/bin/clone_vmspd_remote_devora3.sh SUPDV &> /dev/null # TASK0035244 # 21 11 6 7 * $HOME/bin/clone_vmspd_local_copy.sh vmscfg &> /dev/null # CHG0102615 one time clone # 00 6 5 10 * $HOME/bin/clone_vmspd_local_copy.sh vmscfg &> /dev/null # TASK0064805 one time clone # 00 22 3 1 * $HOME/bin/clone_vmspd_local_copy.sh vmscfg &> /dev/null # TASK008018 one time clone # 00 9 19 3 * $HOME/bin/clone_vmspd_local_copy.sh vmssp &> /dev/null # TASK0082335 one time clone # 00 22 4 4 * $HOME/bin/clone_vmspd_local_copy.sh vmscfg &> /dev/null # TASK0083896 - Oracle - rman clone of VMSPD to SUPDV # 00 14 7 4 * $HOME/bin/clone_vmspd_remote_devora3.sh SUPDV &> /dev/null # TASK0085834 one time clone # 00 9 16 4 * $HOME/bin/clone_vmspd_local_copy.sh vmssp &> /dev/null # TASK0091773 one time clone # 00 6 14 5 * $HOME/bin/clone_vmspd_local_copy.sh vmssp &> /dev/null # TASK0101340 one time clone # 00 22 4 7 * $HOME/bin/clone_vmspd_local_copy.sh vmscfg &> /dev/null # TASK0118591 one time clone # 00 22 3 10 * $HOME/bin/clone_vmspd_local_copy.sh vmscfg &> /dev/null # TASK0130445 one time clone # 01 12 19 11 * $HOME/bin/clone_vmspd_local_copy.sh vmssp &> /dev/null # # TASK0137962 one time clone # 00 5 3 1 * $HOME/bin/clone_vmspd_local_copy.sh vmscfg &> /dev/null # TASK0155022 one time clone # 00 5 4 4 * $HOME/bin/clone_vmspd_local_copy.sh vmscfg &> /dev/null # TASK0163774 one time clone # 00 06 13 5 * $HOME/bin/clone_vmspd_local_copy.sh vmssp &> /dev/null # TASK0172374 one time clone # 00 5 3 7 * $HOME/bin/clone_vmspd_local_copy.sh vmscfg &> /dev/null # TASK0183492 - Oracle - Datapump export of VMSPD # 00 20 5 9 * /home/oracle/bin/exp_db_schema.sh vmspd TASK0183492 &> /dev/null