列举一个简单的使用RMAN进行数据库定时全备份的例子。

1.编写ramn脚本及bat脚本

全备份backup_full.rcv内容：

connect target sys/manager123@orcl;

run{

allocate channel c1 type disk;

allocate channel c2 type disk;

allocate channel c3 type disk;

backup full tag 'dbfull' format 'D:\oracle\product\10.2.0\oradata\OMF\ORCL\ba

ckup\full%u_%s_%p' database include current controlfile;

sql 'alter system archive log current';

backup filesperset 3 format 'D:\oracle\product\10.2.0\oradata\OMF\ORCL\backup

\arch%u_%s_%p' archivelog all delete input;

release channel c1;

release channel c2;

release channel c3;

}

cmd命令backup_full.bat

rman cmdfile='D:\backup_full.rcv'

2.在控制面板中使用向导新建工作计划，设定执行时间.

ITPub博客

RMAN定时全备份数据库之简单实例