Need to configure RMAN backup jobs in Windows servers

We are Taking Oracle Database Rman backup Daily on our Production Instance. In this post we will learn how to configure RMAN backup jobs in Windows Servers.

Create .cmd file with rman backup script.

1) backup_daily_db1.cmd

run{

Allocate channel ch1 type disk format '\path of taking backup_\%d_data_%U';

backup incremental level=0 database tag='Incremental_Backup';

Release channel ch1;

}

Create .bat extension file. 

2) backup_daily_db1.bat

set ORACLE_SID=TEST

rman target sys/****@TEST cmdfile=\Path of cmd file\backup_daily_db1.cmd 

log=D:\Path of log keeping\backup_complete_db1_%date:~4,2%_%date:~7,2%_%date:~10%.log

Schedule the above .bat script in windows scheduler.Launch the Task Scheduler from start menu.

👉On the right panel , click on create task.

👉Give a name to your task.

👉Click on trigger tab and new to schedule on specific time.

👉Click on Action tab and provide the patch for .bat .

👉Click on OK and task will be created.We can run the task by right clicking on task name.