How to setup RMAN backup in Windows environment:-

How to setup RMAN backup in Windows OS environment:-

Command should be tested properly in Dev env and then should be used in production environment at user Risk:

Create a batch file say orcl_backup_rman.bat

==================In Batchfile=================
set logfile=%date%
set logfile=%logfile: =_%
set logfile=%logfile:/=_%
set logfile=orcl_backup_%logfile%.log

SET ORACLE_SID=ORCL

RMAN  nocatalog target / cmdfile 'U:\Oracle\orcl\bkp_scripts_logs\orcl_rman_backup.cmd' LOG='U:\Oracle\orcl\bkp_scripts_logs\logs\%logfile%'


Create a orcl_rman_backup.cmd file and put this command:

BACKUP AS COMPRESSED BACKUPSET database format 'U:\Oracle\orcl\backup\%U' plus archivelog format 'U:\Oracle\orcl\backup\%U' delete input;


delete force noprompt obsolete;