Re: Crontab - HA

  • From: Mark Bole <makbo@xxxxxxxxxxx>
  • To: "Oracle-L (E-mail)" <Oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 21 Jun 2005 06:47:04 -0700

I'm happy to report that the author of the script recently replied and has updated the source at the web site shown, in case anyone downloaded this. Thanks.

-Mark Bole


Madhu R. Vajrala wrote:
Thank You very much, probably this is the solution that i am looking
for.

Great day,
Madhu

On Tue, 2005-06-14 at 08:42 -0700, Mark Bole wrote:

Perhaps best to use DBMS_SCHEDULER if you are on 10g.

A very good solution specifically for your situation (VCS) is here:

http://www.vxideas.org/cron-edit

This shell script is designed to be a resource in your VCS group. I used it for several years in a production cluster -- both a primary and a logical standby database, each with its own set of associated cron jobs, and this tool handled them both, whether running together on one node or separately on different nodes -- the correct cron jobs always ran exactly where they were supposed to, nowhere else. No need to clutter up your crontab entries themselves with some ugly if-then logic.

Unfortunately there was one small bug in the script, which is fixed by commenting out one line in the script as shown here. I sent the fix to the author but never got a response. :-(

add_entry() {
# this next line was a bug, un-doing what remove_entry did
#       cp $before $after







-- //www.freelists.org/webpage/oracle-l

Other related posts: