Schedule RMAN Backup on Windows

Scheduling RMAN backups on a windows machine is little different than Linux machine. Windows uses bash shell and windows scheduler to automate RMAN backups.

• Create RMAN Backup Script File

• Create Bash Shell

• Add Schedule to Windows Scheduler

Create RMAN Backup Script File

We will create a backup.cmd file with our RMAN run block for database backup

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

Create Bash Shell

Create a proddb_rman_backup.bat (.bat is a windows bash shell) file which will call above file

set oracle_sid=proddb
rman target sys/sys@ecccatalog rman_rc/rman_rc@rcat cmdfile='F:\backup.cmd' log='F:\rman_backup_full\backup.log'

Add Schedule to Windows Scheduler

Schedule the above .bat script in windows scheduler

• Launch the Task Scheduler from start menu

• On the right-hand panel, click on Create Task

Give a name to your task

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. Click on Actions tab >> New and provide the location of .bat file you created

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