Schedule RMAN Backup on Windows

Create a .cmd file with rman run command block:

run{
crosscheck backup;
backup database plus archivelog;
};

Create a .bat extension file (this is windows bash shell file) which will call above .cmd file.

set oracle_sid=orcl
rman target sys/[email protected] rman_rc/[email protected]=’F:\backup.cmd’ log=’F:\rman_backup_full\backup.log’

Schedule the above .bat script in windows scheduler.

  1. Launch the task scheduler from start menu.
  2. On the right-hand panel, click on create task.

3. Give a name to your task.

4. Click on Triggers tab à New and define the schedule.

Make sure you set proper frequency like daily or weekly and set proper start date and time.

5. Click on Actions tab à New and provide the location of .bat file you created.

6. Click on OK and task will be created. You can even run the task for testing by right clicking on the task name and select Run.

Was this article helpful?

Related Articles

Leave a Comment