configure backup optimization_optimization problem_delivery

1 显示当前的配置信息

===========================

1.01 RMAN> show all;

1.02 查询RMAN设置中非默认值:

SQL> select name,value from v$rman_configure;

2. 常用的configure选项

===========================

2.01 保存策略 (retention policy)

configure retention policy to recovery window of 3 days;

configure retention policy to redundancy 3;

configure retention policy clear;

备份策略保持

分为两个保持策略，一个是时间策略，决定至少有一个备份能恢复到指定的日期，一个冗余策略，规定至少有几个冗余的备份。

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 5 DAYS;

CONFIGURE RETENTION POLICY TO REDUNDANCY 5;

CONFIGURE RETENTION POLICY TO NONE;

在第一个策略中，是保证至少有一个备份能恢复到Sysdate-5的时间点上，之前的备份将标记为Obsolete。configure backup optimizationconfigure backup optimization第二个策略中说明至少需要有三个冗余的备份存在，如果多余三个备份以上的备份将标记为冗余。NONE可以把使备份保持策略失效，Clear将恢复默认的保持策略

2.02 备份优化 backup optimization

configure backup optimization on;

configure backup optimization off;

configure backup optimization clear;

2.03 默认设备 default device type

configure default device type to disk;

configure default device type to stb;

configure default device type clear;

2.04 控制文件 controlfile

configure controlfile autobackup on;

configure controlfile autobackup format for device type disk to ''/cfs01/backup/conf/conf_%F'';

configure controlfile autobackup clear;

configure controlfile autobackup format for device type disk clear;

configure snapshot controlfile name to ''/cfs01/backup/snapcf/scontrofile.snp'';

configrue snapshot controlfile name clear;

2.05 并行数(通道数) device type disk|stb pallelism n;

本文来自电脑杂谈，转载请注明本文网址：
https://www.pc-fly.com/a/jisuanjixue/article-39828-1.html