RandyDBA | Database - Tips & Techniques

Automating RMAN backup Jobs with CRON utility DBAs often debate whether they should use Oracle Scheduler or the Linux/Unix cron utility for scheduling and automating tasks. There are many benefits that Oracle Scheduler  has over cron, but yet despite these benefits, many DBAs prefer to use a scheduling utility such as cron to automate many tasks. There are some advantages of cron:- Easy to use, simple, tried and true, only takes seconds to create or modify jobs. Almost universally available on all Linux/Unix boxes; for the most part, runs nearly identically, regardless of the Linux/Unix platform (yep!, there are minor differences) Database agnostic; operates independently of the database and works the same, regardless of the database vendor or version. Works whether or not the database is available. When your Linux server boots up, a cron background process is automatically started to manage all the cron jobs in the  system. On your Linux box, you can check...