oracle账号配置文件RMAN数据库Daily备份脚本（Windows版）

RMAN数据库Daily备份脚本（Windows版）

 

例：RMAN备份每日的orawin数据库：

 

1，新建backup.cmd:

  www.2cto.com  

set oracle_sid=orawin

rman target / nocatalog cmdfile=F:Scriptorawinbackupfull.sql log=F:Scriptorawinbackupfull.log append

 

2，在上一步骤指定的路径下新建backupfull.sql:

 

run {

set command id to 'rman';

allocate channel dev1 type disk;

backup

format 'F:rmanbakorawindf%s_%p_%t'

database include current controlfile;sql'alter system archive log current';

sql 'alter system archive log current';

delete noproracle账号ompt obsolete;

 

backup

filesperset 20

format 'F:rmanbakorawinLogar%s_%p_%t'

(archivelog until time '(SYSDATE-1)' all delete input);

 

delete noprompt obsolete;release channel dev1;

}

 

3,打开控制面板，新增每日计划，设定好时间，即可。  www.2cto.com