Common configure configuration for rman_oracle Rman

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