RMAN 备份脚本范例

王亮

RMAN冷备份、一致性备份脚本

run{
shutdown immediate;
startup mount;
allocate channel ch1 type disk;
allocate channel ch2 type disk;
backup database format '/oraback/rmanbak/backup/%d_%s_%p.bak';
release channel ch1;
release channel ch2;
alter database open;
}



RMAN热备份、非一致性备份脚本
简化版：
run{allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
sql 'alter system switch logfile';
backup database format '/oraback/rmanbak/backup/hot_bak/%d_%s_%p_hot.bak';
release channel ch1;
release channel ch2;
}


连归档一块备份版：
run{
allocate channel ch1 type disk;
allocate channel ch2 type disk;
sql 'alter system switch logfile';
backup database format '/home/oracle/rman_bak/hot_bak/%d_%s_%p_hot.bak'
include current controlfile plus archivelog delete input ;
release channel ch1;
release channel ch2;
}

RMAN热备份、非一致性备份脚本(压缩)
run
{
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;sql 'alter system switch logfile';
backup as compressed backupset database format  format '/oraback/rmanbak/backup/%d_%s_%p_%T.db'; --压缩备份
backup as compressed backupset archivelog all format '/oraback/rmanbak/backup/%d_%s_%p_%T.arc'  delete input; --压缩备份
backup current controlfile format '/oraback/rmanbak/backup/ctl_%d_%s_%p_%T.bak' delete input;
release channel ch1;
release channel ch2;
}



注释：
rman名称不允许重复，%U肯定不重复。
%c 备份片的拷贝数
%D 日份 (DD)
%M 月份 (MM)
%F 一个基于DBID 唯一的名称,这个格式的形式为c-IIIIIIIIII-YYYYMMDD-QQ,
%d 数据库名称其中IIIIIIIIII 为该数据库的DBID，YYYYMMDD 为日期，QQ 是一个1-256 的序列
%n 数据库名称，向右填补到最大八个字符
%u 一个八个字符的名称代表备份集与创建时间
%p 该备份集中的备份片号，从1 开始到创建的文件数
%U 一个唯一的文件名，代表%u_%p_%c
%s 备份集的号
%t 备份集时间戳
%T 年月日格式(YYYYMMDD)