Cronjobs set up on Rac Databases
We are configuring the Load scripts and some batch jobs on the Oracle Productions Server.The Environment is RAC and the using 11.2.0.2 Release version.The Server is RedHat Linux Server.
This basically represents single point of failure,ie if the node on which the cron jobs and dataload jobs are configured crashes,Then we won't be able to process the jobs until the time the same configuration is done on other oracle node.
I need some recommendations from anybody as to how to setup to avoid the above scenario.
I have 2 options
1.Do a Linux clustering of both the nodes.Setup the cronjobs on both Server.Mount the directory where u will receive the input files on one node.Thus,when one node goes down the other node with cronjobs start executing the scripts
2.Use another low end VM node in clustered mode.Set up the cronjobs on that VM to invoke the data load scripts on any one node of the server.
Any recommendations is highly appreciated.
Thanks in advance
Veera