• Arun Kumar

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


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

schedule to windows scheduler - create task

Give a name to your task

schedule rman backup on windows - name to your task

Click on Triggers tab >> New and define the schedule

schedule rman backup on windows - 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

schedule rman backup on windows - program/script

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

schedule rman backup on windows - task will be created

2,840 views

Recent Posts

See All

Automate RMAN Backup using Shell Script

In a real environment, off course you will not manually trigger all the Oracle database backups. You need an automated mechanism to trigger RMAN backups. In this article we will look at RMAN backup au