如何 搭建 RMAN 备份平台

2014-11-24 18:25:59 · 作者: · 浏览: 0

一. RMAN 的一些理论知识


二. RMAN 环境一些注意的配置


2.1 修改控制文件自动备份


可以用如下命令查看RMAN 的默认参数配置:


RMAN> show all;


db_unique_name ORCL 数据库RMAN 配置参数为:


CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default


CONFIGURE BACKUP OPTIMIZATION OFF; # default


CONFIGURE DEFAULT DEVICE TYPE TO DISK;


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 CHANNEL 1 DEVICE TYPE DISK FORMAT 'F:/backup/orcl_%U.bak';


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 LOA


D TRUE ; # default


CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default


CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:/APP/ADMINISTRATOR/PRODUCT/11.2.0/DBHO


ME_1/DATABASE/SNCFORCL.ORA'; # default



注意,controlfile autobackup 这个参数默认是OFF的,即默认不自动备份,我们把这个参数改成自动备份:


RMAN> configure controlfile autobackup on;


旧的 RMAN 配置参数:


CONFIGURE CONTROLFILE AUTOBACKUP OFF;


新的 RMAN 配置参数:


CONFIGURE CONTROLFILE AUTOBACKUP ON;


已成功存储新的 RMAN 配置参数



改成自动以后,在数据文件有变化,或者备份数据库的时候,都会自动的备份控制文件和spfile文件。



改parallelism参数为2. 该参数默认值为1.


如:CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;



官网对这个参数的解释:


Configures the number of automatic channels of the specified device type allocated for RMAN jobs. By default, PARALLELISM is set to 1.