RMAN 备份文档

我們在RMAN中可以通過CONFIGURE這個Command來固定一些在以前版本中要手工輸入的信息，如備份文件的存放路徑及文件名，備份文件的大小，備份策略。控制文件的備份等。下面列出在RMAN中常見的可以用于設定的信息（以及一些實例）

------------------------------------------------------------
--configure (配置RMAN的default設置)
------------------------------------
--1 顯示當前的configure
RMAN> show all;

RMAN configuration parameters are:
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; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
RMAN configuration has no stored or default parameters
RMAN configuration has no stored or default parameters
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/9.2.0/dbs/snapcf_uw920A.f'; # default

RMAN>
---------------------
--2. configure command
---------------------------------------------------------------------------
2.01 retention policy
 configure retention policy to recovery window of 3 days;
 configure retention policy to redundancy  3;
 configure retention policy 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;
 configrue controlfile autobackup format for device type disk clear;
 configrue snapshot controlfile name to '/cfs01/backup/snapcf/scontrofile.snp';
 configrue snapshot controlfile name clear;
2.05 device type disk|stb pallelism n
 configure device type disk|stb parallelism 2;
 configure device type disk|stb clear; 
      configure channel device type disk format 'e:rmanback_%U';
      configure channel device type disk maxpiecesize 100m
 configure channel device type disk rate 1200K
      configure channel 1 device type disk format 'e:rmanback_%U';
      configure channel 2 device type disk format 'e:rmanback_%U';
      configure channel 1 device type disk maxpiecesize 100m
2.06 datafile|archivelog backup copies
 configure datafile backup copies for device type disk|stb to 3;
 configure archivelog backup copies for device type disk|stb to 3;
 configure datafile|archivelog backup copies for device type disk|stb clear
 BACKUP DEVICE TYPE DISK DATABASE
  FORMAT '/disk1/backup/%U', '/disk2/backup/%U', '/disk3/backup/%U';
2.07 exclude
 configure exclude for tablespace 'users';
 configrue exclude clear;
2.08 maxsetsize
 configure maxsetsize to 1G|1000M|1000000K|unlimited;
 configure maxsetsize clear;
2.09 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;

e.g.
-------------------
RMAN> show all;

RMAN configuration parameters are:
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; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
RMAN configuration has no stored or default parameters
RMAN configuration has no stored or default parameters
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/9.2.0/dbs/snapcf_uw920A.f'; # default

RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 3;

new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 3;
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1

RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/cfs01/%U';

new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/cfs01/%U';
new RMAN configuration parameters are successfully stored

RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/cfs01/%U';

new RMAN configuration parameters:
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/cfs01/%U';
new RMAN configuration parameters are successfully stored

RMAN> show all;

RMAN configuration parameters are:
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 3;
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   '/cfs01/%U';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/cfs01/%U';
RMAN configuration has no stored or default parameters
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/9.2.0/dbs/snapcf_uw920A.f'; # default

RMAN> CONFIGURE CHANNEL DEVICE TYPE disk clear;

old RMAN configuration parameters are successfully deleted

RMAN> show all;

RMAN configuration parameters are:
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 3;
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   '/cfs01/%U';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/cfs01/%U';
RMAN configuration has no stored or default parameters
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/9.2.0/dbs/snapcf_uw920A.f'; # default

RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK clear;

old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/cfs01/%U';
old RMAN configuration parameters are successfully deleted

RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK clear;

old RMAN configuration parameters:
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/cfs01/%U';
old RMAN configuration parameters are successfully deleted

RMAN> CONFIGURE DEVICE TYPE DISK clear;

old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 3;
RMAN configuration parameters are successfully reset to default value

RMAN> show all;

RMAN configuration parameters are:
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; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
RMAN configuration has no stored or default parameters
RMAN configuration has no stored or default parameters
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/9.2.0/dbs/snapcf_uw920A.f'; # default

RMAN>