Link Search Menu Expand Document

Recipe: Automatic Backup Schedule with crontab

Expected deliverables:

Scheduled Oracle Database Backup every day at 10:00 AM

Time to complete: 5 minutes

Ingredients: The account with Oracle SYSDBA access. The oracle environment should be set. Configured Veeam Plugin for Oracle RMAN.

Before you start: User account with SysDBA permissions. Veeam Plugin for Oracle RMAN installed and configured.


  1. In the example below, we are going to configure crontab to run Oracle RMAN backup every day at 10:00 AM.
  2. Run “crontab -e” commands to open crontab editor.
  3. Add the line 0 10 *** \pathtoRMANscript\

Example RMAN script:

cat «EOF >./ #!/bin/bash ORACLE_SID=ORCL; export ORACLE_SID PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

RMAN Target /

run { backup database plus archivelog; };


Back to top

Copyright © 2019-2021 Solutions Architects, Veeam Software.