例：RMAN备份每日的orawin数据库：
1，新建backup.cmd:
1，新建backup.cmd:
set oracle_sid=orawin
rman target / nocatalog cmdfile=F:\Script\orawin\backupfull.sql log=F:\Script\orawin\backupfull.log append
rman target / nocatalog cmdfile=F:\Script\orawin\backupfull.sql log=F:\Script\orawin\backupfull.log append
2，在上一步骤指定的路径下新建backupfull.sql:
run {
set command id to 'rman';
allocate channel dev1 type disk;
backup
format 'F:\rmanbak\orawin\df%s_%p_%t'
database include current controlfile;
sql 'alter system archive log current'; delete noprompt obsolete; backup
filesperset 20
format 'F:\rmanbak\orawin\Log\ar%s_%p_%t'
(archivelog until time '(SYSDATE-1)' all delete input); delete noprompt obsolete;
set command id to 'rman';
allocate channel dev1 type disk;
backup
format 'F:\rmanbak\orawin\df%s_%p_%t'
database include current controlfile;
sql
'alter system archive log current';sql 'alter system archive log current'; delete noprompt obsolete; backup
filesperset 20
format 'F:\rmanbak\orawin\Log\ar%s_%p_%t'
(archivelog until time '(SYSDATE-1)' all delete input); delete noprompt obsolete;
release channel dev1;
}
3,打开控制面板，新增每日计划，设定好时间，即可。
相关文章
暂无评论...
致力于称为最好的程序员导航网站