RMAN的相关参数

RMAN>show all;
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;  # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
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 ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/product/10.2.0/db_1/dbs/snapcf_mydb.f'; # default

 

1．保存策略 (retention policy)
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
可供选项：
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; # 保存最近七天内的备份
CONFIGURE RETENTION POLICY TO REDUNDANCY 5; # 保存最新的5份备份（个人认为最安全的方法）
CONFIGURE RETENTION POLICY TO NONE;
CONFIGURE RETENTION POLICY CLEAR;

 

2．备份优化 (backup optimization)
CONFIGURE BACKUP OPTIMIZATION OFF; # default
可供选项：
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE BACKUP OPTIMIZATION CLEAR;

 

 

 

3．默认设备 (default device type)
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
可供选项：
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # 硬盘
CONFIGURE DEFAULT DEVICE TYPE TO SBT; # 磁带
CONFIGURE DEFAULT DEVICE TYPE CLEAR;

 

 

4．控制文件 (controlfile)
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default 强制数据库在备份文件或者执行改变数据库结构的命令之后将控制文件自动备份，默认值为关闭。这样可以避免控制文件和catalog丢失后，控制文件仍然可以恢复。
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default 配置控制文件的备份路径和备份格式
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/product/10.2.0/db_1/dbs/snapcf_mydb.f'; # default 配置控制文件的快照文件的存放路径和文件名，这个快照文件是在备份期间产生的，用于控制文件的读一致性。
可供选项：
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP CLEAR;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oracle/backup/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/backup/snapcf_mydb.f';
CONFIGURE SNAPSHOT CONTROLFILE NAME CLEAR;

5．并行数(通道数) (device type disk|stb pallelism n;)
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
可供选项：
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/oracle/backup/ora_df%t_s%s_s%p';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/oracle/backup/ora_df%t_s%s_s%p';
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 100m;

CONFIGURE DEVICE TYPE DISK CLEAR;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oracle/backup/ora_df%t_s%s_s%p'; # 配置备份文件的备份路径和备份格式
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 100m;
CONFIGURE CHANNEL DEVICE TYPE DISK RATE 1200K;

6．生成备份副本 (datafile|archivelog backup copies)
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default 配置数据库的每次备份的copy数量，oracle的每一次备份都可以有多份完全相同的拷贝。
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
可供选项：
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK CLEAR;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK CLEAR;

7．排除选项 (exclude)
CONFIGURE EXCLUDE FOR TABLESPACE <tablespace> [CLEAR]; 此命令用于将指定的表空间不备份到备份集中， 此命令对只读表空间是非常有用的。

8．备份集大小 (maxsetsize)
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
可供选项：
CONFIGURE MAXSETSIZE TO UNLIMITED 1G;
CONFIGURE MAXSETSIZE CLEAR;

9．其它选项 (auxiliary)
CONFIGURE AUXNAME FOR DATAFILE 1 TO '/oracle/auxfiles/aux_1.f';
CONFIGURE AUXNAME FOR DATAFILE 2 TO '/oracle/auxfiles/aux_2.f';
CONFIGURE AUXNAME FOR DATAFILE 3 TO '/oracle/auxfiles/aux_3.f';
CONFIGURE AUXNAME FOR DATAFILE 4 TO '/oracle/auxfiles/aux_4.f';

CONFIGURE AUXNAME FOR DATAFILE 1 CLEAR;
CONFIGURE AUXNAME FOR DATAFILE 2 CLEAR;
CONFIGURE AUXNAME FOR DATAFILE 3 CLEAR;
CONFIGURE AUXNAME FOR DATAFILE 4 CLEAR;
其它默认选项：
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

 

Rman的format格式中的%
%c 备份片的拷贝数
%d 数据库名称
%D 位于该月中的第几天 (DD)
%M 位于该年中的第几月 (MM)
%F 一个基于DBID唯一的名称,这个格式的形式为c-IIIIIIIIII-YYYYMMDD-QQ,其中IIIIIIIIII为该数据库的DBID，YYYYMMDD为日期，QQ是一个1-256的序列
%n 数据库名称，向右填补到最大八个字符
%u 一个八个字符的名称代表备份集与创建时间
%p 该备份集中的备份片号，从1开始到创建的文件数
%U 一个唯一的文件名，代表%u_%p_%c
%s 备份集的号
%t 备份集时间戳
%T 年月日格式(YYYYMMDD)