配置RMAN的永久性参数

RMAN> show all;  --或者查找V$RMAN_CONFIGURATION

RMAN configuration parameters for database with db_unique_name PROD1 are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 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 '%F'; # default  --备份路径
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;  --备份文件并行以及是否压缩备份
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default   --单文件大小的限制
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default  --加密备份
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default  --加密备份的算法
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default  --定义压缩算法
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default  --定义归档删除策略
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_PROD1.f'; # default  --控制文件快照
           

1.CONFIGURE CONTROLFILE AUTOBACKUP ON

如果控制文件丢失，可以使用rman恢复

shutdown abort

startup nomount

restore controlfile from autobackup;  --必须打开自动备份

alter database mount;

recover database;

alter database open resetlogs;

backup database;

2.CONFIGURE RETENTION POLICY TO REDUNDANCY 1；定义冗余数，备份1次就有效

  CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 10 DAYS; 备份在10天内有效

  CONFIGURE RETENTION POLICY CLEAR; 还原为默认值

  report obsolete [recovery window of 10 days | redundancy 2]; 报告无效对象

3.CONFIGURE BACKUP OPTIMIZATION ON; 如果数据文件的scn无变化（只读，脱机），那么如果以前有备份则本次可以不备份。

4.CONFIGURE DEFAULT DEVICE TYPE TO DISK|SBT  备份到磁盘|磁带机

5.CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; 在使用db_recovery_file_dest参数后则无效

6.CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO [COMPRESSED] BACKUPSET; 并行个数和压缩备份

7.CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ;

BASIC|HIGH|MEDIUM|LOW