在windows下自動執行rman備份

1批處理文件為：test.bat，腳本如下

set oralce_sid=test

rman target sys/oracle nocatalog log f:\rman\%backup_file%rman.log append cmdfile=f:\rman\test.rman

2.備份文件為test.rman

RUN {

 CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

 CONFIGURE CONTROLFILE AUTOBACKUP ON;

 CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'f:/rman/%F';

 ALLOCATE CHANNEL CH1 DEVICE TYPE DISK FORMAT 'f:/rman/%U';

 BACKUP DATABASE SKIP INACCESSIBLE FILESPERSET 10

   PLUS ARCHIVELOG FILESPERSET 20

   DELETE ALL INPUT;

 RELEASE CHANNEL CH1;

 }

 ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;

 CROSSCHECK BACKUPSET;

 DELETE NOPROMPT OBSOLETE;

3. 將 test.bat 加入執行計畫

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25530136/viewspace-697872/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25530136/viewspace-697872/