oracle之rman详解
1、设置并发执行rman备份1）手工配置
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
backup database format ‘c:\rman\d_%U_%p.bak’
tag=’xifenfei’;
}
2)参数中配置
configure device type disk parallelism 3 backup type to backupset;
backup database format ‘c:\rman\d_%U.bak’ tag=’xifenfei’;
2、设置备份文件大小
run{ allocate channel c1 type disk maxpiecesize 100m;
backup database format ‘c:\rman\test_%U_%p.bak’ filesperset 2 maxsetsize 500m;}
note：maxpiecesize–单个备份文件大小
filesperset–一个backset中含有的datafile的数量
maxsetsize–backset的大小
3、备份控制文件
1）配置自动备份
configure controlfile autobackup on;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR
DEVICE TYPE DISK TO ‘c:\rman\cl_%F.ctl’;
2）备份时顺带备份
backup datafile 5 format ‘c:\rman\d_%U.bak’
include current controlfile;
4、一次备份多份（最多四份）
1）直接指定
backup copies 2 datafile 5 format
‘c:\rman\%U.bak’,'c:\temp\%U.bak’;
2）配置文件中指定
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
backup datafile 5 format ‘c:\temp\t_%U.bak’,'c:\rman\t_%U.bak’;
oracle视频教程请关注:http://u.youku.com/user_video/id_UMzAzMjkxMjE2.html
页:
[1]