oracle rman备份批处理脚本,RMAN备份脚本及自动批处理(windows)

RMAN备份脚本及自动批处理(windows)

接上章RMAN备份前工作：

C:\Documents and

Settings\Administrator>rman catalog rmanuser1/rmanuser1 target

RMAN>show

all;

设置控制文件的自动备份和自动备份的目录(建议设置，备份目录自定)

RMAN>CONFIGURE CONTROLFILE

AUTOBACKUP ON;

RMAN>CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE

TYPE DISK TO

'd:/backup/%F';

RMAN>exit;

按如上设置后，控制文件和spfile就会随着数据库备份自动备份到d:/backup下；

建立脚本文件和批处理文件：

脚本文件，如文件名为orabackup.rcv，具体内容如下：

run

{

allocate channel d1 type disk;

allocate channel d2 type disk;

backup

incremental level 0 database format 'd:\backup\level0_%d_%s_%p_%u.bak';

sql

'alter system archive log current';

backup archivelog all format

'd:\backup\log_%d_%s_%p_%u.bak' delete all input;

release channel

d2;

release channel d1;

}

crosscheck backup;

delete noprompt expired

backup;

delete noprompt obsolete;

resync

catalog;

exit

批处理文件，如文件名为orabackup.bat，具体内容如下

rman catalog target

CMDFILE 'd：\backup\orabackup.rcv' LOG

’d:\backup\oracl_%date'

将orabackup.bat和orabackup.rcv存放在同一目录下，执行orabackup.bat就可以调用orabackup.rcv备份数据库了，你可以再windows的计划任务里执行orabackup.bat就可以自动备份了；