2014-12-09 Baoxinjian
1. Display the current configuration information
1.01 rman> Show All;
1.02 query Rman setting non-default values:
Sql> select Name,value from V$rman_configure;
2. Common Configure Options
2.01 Save policies (retention policy)
Configure retention policy to recovery windows of 3 days;
Configure retention policy to redundancy 3;
Configure retention policy clear;
Backup policy remains
Divided into two retention strategies, one is a time policy, which determines that at least one backup can be restored to a specified date, a redundancy policy that requires at least a few redundant backups.
CONFIGURE RETENTION POLICY to RECOVERY windows of 5 days;
CONFIGURE RETENTION POLICY to redundancy 5;
CONFIGURE RETENTION POLICY to NONE;
In the first policy, it is guaranteed that at least one backup can be restored to Sysdate-5 at a point in time, and the previous backup will be marked as obsolete.
In the second policy, it is stated that at least three redundant backups are required to exist, and if more than three backups above the backup will be marked as redundant.
None in the second policy can invalidate the backup retention policy, and Clear restores the default retention policy
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 Control File Controlfile
Configure Controlfile autobackup on;
Configure Controlfile autobackup format for device type disk to '/cfs01/backup/conf/conf_%f ';
Configure Controlfile Autobackup clear;
Configure Controlfile autobackup format for device type disk clear;
Configure snapshot Controlfile name to '/CFS01/BACKUP/SNAPCF/SCONTROFILE.SNP ';
Configrue snapshot controlfile name clear;
2.05 parallel number (number of channels) 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 creating a backup copy of 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 exclusion options Exclude
Configure exclude for tablespace ' users ';
Configrue exclude clear;
2.08 Backup set Size Maxsetsize
Configure Maxsetsize to 1g|1000m|1000000k|unlimited;
Configure Maxsetsize Clear;
2.09 Other Options 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;
Thanks and regards
Reference: http://www.cnblogs.com/coohoo/archive/2011/01/16/1936854.html
Common configure configuration for rman_oracle Rman