2012年8月30日木曜日

[备份恢复] RMAN 配置

1. 重置配置
configure retention policy clear;

2. 备份策略
# 每个文件的备份需要保留天数或份数
configure retention policy to recovery window of n days;
configure retention policy to redundancy n;
configure retention policy to none;

3. 备份优化
configure backup optimization on;
configure backup optimization off;

4. IO 设备类型
configure default device type to disk;
configure default device type to sbt;
configure device type disk parallelism 2 backup type to backupset;

5. 控制文件自动备份
configure controlfile autobackup on;
configure controlfile autobackup off;
configure controlfile autobackup format for device type disk to '%F';
configure snapshot controlfile name to '/tmp/snapcf_fsdb.f'

6. 备份冗余
configure datafile backup copies for device type disk to 2;
configure archivelog backup copies for device type disk to 2;

7. 备份集大小
configure maxsetsize to unlimited;
configure maxsetsize to 100M;

8. 备份加密
configure encryption for database on;
configure encryption for tablespace users on;
configure encryption algorithm 'aes128';

9. 删除归档
configure archivelog deletion policy to none;
configure archivelog deletion policy to applied on standby;

0 件のコメント:

コメントを投稿