Oracle Learning Rman (vii) parameter configuration

Configuring the Rman Backup Environment

For most backup operations, Rman provides a reasonable default value for persistent parameter configurations, enabling you to perform basic backup and recovery. But if you know more about the configuration, you can use Rman more effectively to implement the Rman-based backup strategy.

Use the show all command to view the configuration of Rman

rman> show all; rman configuration parameters for database with db_unique_name devdb  are:configure retention policy to redundancy 1; # defaultconfigure  Backup optimization off; # defaultconfigure default device type to  DISK; # defaultCONFIGURE CONTROLFILE AUTOBACKUP ON; configure controlfile autobackup format for device type disk to  ' %F '; # defaultconfigure device type disk parallelism 1 backup  type to backupset; # defaultconfigure datafile backup copies for  device type disk to 1; # defaultconfigure archivelog backup  Copies for device type disk to 1; # defaultconfigure maxsetsize  to unlimited; # defaultconfigure encryption for database off; # defaultconfigure  encryption algorithm  ' AES128 '; # defaultconfigure compression algorithm  ' BASIC '  AS OF RELEASE  ' DEFAULT '  optimize for load true ; #  defaultCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; #  defaultconfigure snapshot controlfile name to  '/u01/app/oracle/product/11.2.0/db_1/ Dbs/snapcf_devdb.f ';  # default

Parameter resolution

• CONFIGURE RETENTION POLICY to redundancy 1;

is used to decide that backups are no longer needed, there are three options available, namely
CONFIGURE RETENTION POLICY to RECOVERY windows of 7 days;
CONFIGURE RETENTION POLICY to redundancy 5;
CONFIGURE RETENTION POLICY to NONE;
The first recover window is to keep all the backups sufficient to restore the database system to any time in the last seven days. Any database backups that exceed the last seven days will be marked as obsolete.

The second redundancy is to maintain the latest 5 database backups that can be recovered, and any backups that exceed the latest 5 copies will be marked as redundancy. Its default value is 1 copies.

The third does not require a retention policy, and clear reverts back to the default retention policy. The safest approach is to adopt a second retention strategy.

• CONFIGURE BACKUP Optimization OFF

  The default value is off, and if opened, Rman will perform an optimized algorithm for files such as the backed up data files and archives.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/70/9D/wKioL1W6PtbT-q4iAAFT6xOpf3E631.jpg "title=" Identical file. PNG "alt=" Wkiol1w6ptbt-q4iaaft6xopf3e631.jpg "/>

• Configure default device type to disk:
  Is the device type that specifies all I/O operations is the hard disk or tape, the default is the hard disk
  The tape setting is configure default DEVICE TYPE to SBT;

• CONFIGURE Controlfile autobackup OFF
  Forces the database to automatically back up the control file after a backup file or a command that alters the structure of the database, and the default value is off. This avoids the control files and catalog loss, the control files can still be recovered.

• CONFIGURE controlfile autobackup FORMAT for DEVICE TYPE DISK to '%F '
  is the backup path and backup format of the configuration control file

• CONFIGURE DEVICE TYPE DISK PARALLELISM 1;
  is the degree of parallelism of the configuration database device type.

• CONFIGURE datafile BACKUP COPIES for DEVICE TYPE DISK to 1;
  Is the copy number of each backup of the configuration database, and each backup of Oracle can have multiple copies of the exact same copy.

• CONFIGURE ARCHIVELOG BACKUP COPIES for DEVICE TYPE DISK to 1
  is the type of storage device that sets the archive log for the database

• CONFIGURE SNAPSHOT controlfile NAME to '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_devdb.f '; # Default

is the storage path and file name of the snapshot file for the configuration control file, which is generated during the backup and is used to control the read consistency of the file.

This article is from the "Ding Dong" blog, please be sure to keep this source http://lqding.blog.51cto.com/9123978/1680362

Oracle Learning Rman (vii) parameter configuration