Posts

Showing posts with the label windows scheduler rman

RMAN Script Scheduling in Windows Server

First Create your scirpts in suppose D:\orascripts\rman location like below 1. rman_full_bkp_SHAONDB.bat the content of this file will be set ORACLE_HOME=D:\app\orabase\product\11.2.0\dbhome_1 set ORACLE_SID=DBSHAON %ORACLE_HOME%\bin\rman target / cmdfile='D:\orascripts\rman\rman_full_bkp.bat' log='D:\orascripts\rman\rman_archive_full_bkp_cronout.txt' 2. rman_full_bkp.bat run { backup database plus archivelog; delete obsolete; } exit Finally you just open windows task scheduler Control Panel-->All Control Panel Items-->Administrative Tools-->task scheduler create a new task where the action will be batchfile#1. That's it.