oracle之rman(2)

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 之rman备份数据库

1、备份整个数据库
backup database format ‘c:\rman\all_%U.bak’;
2、备份表空间
backup tablespace abc format ‘c:\rman\t_%U.bak’;
3、备份数据文件
1)backup datafile 5 format ‘c:\rman\d_%U.bak’;
2)backup datafile ‘C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ABC.DBF’
format ‘c:\rman\d_%U.bak’;
4、备份控制文件
backup current controlfile format ‘c:\rman\ctr_%U.ctl’;
5、备份数据文件同时备份控制文件
backup datafile 5 format ‘c:\rman\d_c_%U.bak’
include current controlfile;
6、备份spfile文件
backup spfile format ‘c:\rman\sp_%U.sp’;
7、备份日志文件
backup archivelog sequence between 38 and 41 format ‘c:\rman\ar_%U.log’
delete all input(可选项,表示备份日志文件后,删除原来日志文件);
8、备份数据库和日志文件
backup database plus archivelog format ‘c:\rman \d_ar_%U.d_a’;
9、copy功能(相当于用户管理备份)
backup as copy database format ‘c:\rman\%U.cy’;
copy datafile 5 to ‘c:\rman\d_%U.cy’;
note:backup as copy可以备份整个数据库
copy只能备份current controlfile、datafile、tablespace等,这个数据库不支持

oracle之rman(1)

1、连接rman
1)nocatalog模式访问
rman target sys/xifenfei@orcl nocatalog
2)启用日志文件
rman target sys/xifenfei@orcl nocatalog append log ‘c:\rman.log’

2、查看rman configure 信息
所有信息 show all;
查看相关信息:show device type;

3、rman参数设置
1)设置参数
configure controlfile autobackup off;
2)恢复为默认参数
configure controlfile autobackup clear;