记录rman的命令，备忘 连接到目标数据库: back (dbid=4048592102) 连接到恢复目录数据库 rman 2 show all; --查看参数 rman 配置参数为: configure retention policy to recovery window of 3 days; configure backup optimization on; configure default de
记录rman的命令，备忘
连接到目标数据库: back (dbid=4048592102)
连接到恢复目录数据库
rman> 2> show all; --查看参数
rman 配置参数为:
configure retention policy to recovery window of 3 days;
configure backup optimization on;
configure default device type to disk; # default
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to 'd:\backup\control_%f';
configure device type disk parallelism 2 backup type to backupset;
configure datafile backup copies for device type disk to 1;
configure archivelog backup copies for device type disk to 1;
configure channel 1 device type disk format 'd:\backup\backup_%u';
configure channel 2 device type disk format 'd:\backup\backup_%u';
configure maxsetsize to unlimited; # default
configure encryption for database off; # default
configure encryption algorithm 'aes128'; # default
configure archivelog deletion policy to none; # default
configure snapshot controlfile name to 'd:\oracle\product\10.2.0\db_1\database\sncfback.ora'; # default
介绍一下参数
configure retention policy to recovery window of 3 days; --备份策略，保留3天的备份
configure retention policy to redundancy 7; --备份策略，保留7个备份
这两个备份策略只能两个取一，不能共存。
configure backup optimization on; --备份优化打开，不知道oracle为什么不默认打开
configure default device type to disk; # default --备份设备设备disk为磁盘,sbt为磁带
configure controlfile autobackup on; --控制文件备份是否自动备份，意思是说备份数据库的同时是否自动备份控制文件
configure controlfile autobackup format for device type disk to 'd:\backup\control_%f'; --控制文件备份的目录和格式
configure device type disk parallelism 2 backup type to backupset; --备份的并行度和备份压缩
configure datafile backup copies for device type disk to 1; --备份的数据文件 有几个副本
configure archivelog backup copies for device type disk to 1; --备份的归档日志 有几个副本
configure channel 1 device type disk format 'd:\backup\backup_%u';
configure channel 2 device type disk format 'd:\backup\backup_%u'; --分配通道，通道的备份目录
configure maxsetsize to unlimited; # default --备份集的大小，这个还是unlimited为好，因为我们总是无法估计备份集的大小
configure snapshot controlfile name to 'd:\oracle\product\10.2.0\db_1\database\sncfback.ora'; # default --备份文件的镜像