RMAN SHOW ALL 配置信息说明

1 显示当前的配置信息
===========================
1.01 RMAN> show all;

2. 常用的configure选项
===========================
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;

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7199859/viewspace-462614/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7199859/viewspace-462614/