windows下rman全库备份脚本

windows下rman全库备份脚本

run
{
allocate channel ch1 type disk;
allocate channel ch2 type disk;
backup database filesperset 5 tag='full_bak' format 'D:\backup\fullbak_%d_%s_%p';  

sql 'alter system archive log current';
backup archivelog all tag='arc_bak' format='D:\backup\arch_%U_%T' skip inaccessible  filesperset 5 not  backed up 1 times  delete input;
backup current controlfile tag='bak_ctlfile' format='D:\backup\ctl_file_%U_%T';

 
release channel ch1;                                  
release channel ch2; 
}

crosscheck backup;                                              
delete noprompt obsolete;
delete noprompt expired backup;

 

 用一下代码做个批处理每天执行备份脚本：

rman target / msglog D:\dmpbackup\logs\%date:~0,10%.log cmdfile=D:\benfenjiaoben\backup.rman