1、创建rman备份脚本:
rman>create script rman_backup {
sql 'alter system checkpoint';
backup database format '/oracle/rman/rm_bk%U.dbf';
backup current controlfile format '/oracle/rman/rm_ct%U.dbf';
}
2、执行rman备份脚本:
rman>run {execute script rman_backup;}
3、如何使用操作系统文件存储rman指令,并在rman中直接调用该文件执行rman命令,首先创建一个rman_backup.rcv 文件,文件内容如下:
sql 'alter system checkpoint';
backup database format '/oracle/rman/rm_bk%U.dbf';
backup current controlfile format '/oracle/rman/rm_ct%U.dbf';
4、调用操作系统文件执行rman指令:d:>rman catalog rman_backup/rman@orcl target system/oracle@orcl cmdfile 'rman_backup.rcv ';
为了编辑的方便,我们也可以将脚本文件转换为操作系统文件:
rman>print script rman_backup to file 'rman_backup.txt';
5、使用rman实现数据块的恢复:
rman>blockrecover datafile 6 block 118 from backupset;
6、启用快速增量备份:
sql>alter database enable block change tracking using file '/u01/oracle/product/10.2.0/oradata/chtrack.log';
7、实现rman增量备份:级别0的备份(全库备份):
rman>backup incremental level 0 database;
级别1的备份(在级别0基础上的差异备份):
rman>backup incremental level 1 database;