ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN--configure command

RMAN--configure command

原创 Linux操作系统 作者:vongates 时间:2019-05-08 22:18:05 0 删除 编辑

1 顯示當前的configure
RMAN> show all;

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;

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

请登录后发表评论 登录
全部评论

注册时间:2018-09-11

  • 博文量
    201
  • 访问量
    145706