Automating RMAN via batch (.bat)

If you had automated Oracle RMAN backups via Enterprise Manager Console on a Windows Server and now your console no longer starts, you can create a backup solution running RMAN commands via a batch (.bat) script. 

I've found the easiest way is to create a command file (cmdfile) and a batch file that calls it. The following is an example of creating each file at the location C:\Oracle_batch\RMAN. It is a incremental RMAN backup.


Command File = C:\Oracle_batch\RMAN\weekly_backup.rcv

Command File = C:\Oracle_batch\RMAN\daily_backup.rcv

Batch file for weekly = C:\Oracle\RMAN\weekly_backup.bat

Batch file for daily = C:\Oracle\RMAN\daily_backup.bat

If you want to take backup daily or  weekly .Just run the daily or weekly batch file but remember that before taking daily backup first you have to take weekly backup then daily. If you want to automatic this backup. Add daily & weekly batch file to windows scheduler & set time & date.

Do you need an experienced Multi platform DBA to setup and manage your backup and ensure your database is in good health. Checkout my services and contact me with any questions.

Cheers!!!!!!!