RMAN backup jobs through DBMS_SCHEDULER

It is very easy to create the RMAN backup jobs through DBMS_SCHEDULER.

Benefits of using DBMS_SCHEDLER for RMAN jobs:

  • For multinode RAC configuration, executing the RMAN jobs through OS cronjobs will fail when the node is not available. While using DBMS_SCHEDULER , the job can be run from serviving instance.
  • It is easy to maintain the logs at OS level as well as in the database dictionary.
  • By default execution of the job can be fixed for specific instance using service and can be changed at any time.

Read More »