Detailed description of rman configuration parameters

Rman configuration parameters: [SQL] RMAN> show all; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; CONFIGURE BACKUP OPTIMIZATION OFF; # default configure default device type to disk; # default configure controlfile autobackup off; # default configure controlfile autobackup format for device type disk to '% F '; # default configure device type disk parallelism 1 backup type to backupset; # default C Onfigure datafile backup copies for device type disk to 1; # default configure archivelog backup copies for device type disk to 1; # default configure maxsetsize to unlimited; # default www.2cto.com configure encryption for database off; # default configure encryption algorithm 'aes128 '; # default configure archivelog deletion policy to none; # default configure snapshot controlfile name to 'd: \ OR ACLE \ PRODUCT \ 10.2.0 \ DB_1 \ DATABASE \ SNCFORCL. ORA '; # default Note: # default indicates that the configuration is still the initial default value. Go back to the default configure .. clear configuration. 1) configure retention policy .. used to determine which backups are not needed. There are three Optional options: a) redundancy 5 indicates the number of backup sets in a data file, which is 5 copies B) recovery window of 7 days indicates that you want the database to be restored to a few days ago. c) none indicates that the retention policy is not required. Note: a) and B) are mutually exclusive. 2) configure backup optimization .. theoretically, backup optimization only applies to read-only or offline tablespaces. Of course, archive log files that have been backed up will also be skipped. The DEFAULT value is off www.2cto.com 3) configure default device type to .. specify the device type of the I/o operation: SBT or DISK. The DEFAULT value is disk. 4) configure controlfile autobackup .. When autobackup is not set to on, rman will automatically back up the control file for any backup operations. 5) configure controlfile autobackup format for device type disk to '% F' configure the path and format of the backup part of the control file, for example: CONFIGURE controlfile autobackup format for device type disk to 'e: \ backupcontrol \ % F' 6) configure device type disk parallelism 1 backup type to backupset to configure the degree of PARALLELISM of the database device type. The number of parallel backups determines the number of opened channels www.2cto.com 7) configure datafile backup copies for device type disk to 1 configure archivelog backup copies for device type disk to 1 whether TO enable composite BACKUP, generates the specified number of copies from the specified position in the specified I/o device. The default value is 1. This configuration is only used for data files and archive files. It takes effect only when channels are automatically allocated! 8) configure maxsetsize to unlimited to configure the backup set size. Generally, maxpiecesize is configured to restrict the backup parts. 9) configure encryption for database off configure the encrypted backup set. Specific tablespace: configure encryption for tablespace users on; if we execute set encryption on indentified by think only, this password is required for subsequent backups. 10) configure encryption algorithm 'aes128 'specifies the encryption algorithm, and the other one is 'aes256' 11) configure archivelog deletion policy to none specifies the deletion policy for the archive file. The default value is none. That is, the archive file can be deleted after the archive backup is complete. However, in the DG Environment, DBAs must ensure that the archive file is successfully received and applied on the standby end, the primary end always saves the file www.2cto.com so, and the DG Environment should be set to: applied on standby 12) CONFIGURE SNAPSH Ot controlfile name to 'd: \ ORACLE \ PRODUCT \ 10.2.0 \ DB_1 \ DATABASE \ SNCFORCL. ORA 'configure the storage path and file name of the snapshot file of the control file. This snapshot file is generated during Backup and used to control the read consistency of the file. In addition, configure exclude for tablespace <tablespace> [CLEAR]; this command is used to not back up the specified TABLESPACE to the backup set. This command is very useful FOR read-only tablespaces.