Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to understand Oracle RMAN environment parameters". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's ideas to study and learn "how to understand Oracle RMAN environment parameters".

Analysis of RMAN environment parameters:

RMAN > show all

RMAN configuration parameters for database with db_unique_name PROD are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

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'% favored; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE 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

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE' DEFAULT' OPTIMIZE FOR LOAD TRUE; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/ u01qapplash oracleandproduct11.2.0Universe home1anddbsAccordance prod.fills; # default

1. RETENTION POLICY

Retention policies for backup files (two policies)

(1) CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default redundancy retention policy

Explanation:

Is to specify the number of backups that must be retained for each data file (default is 1).

How to configure: RMAN > configure retention policy to redundancy 2; RMAN > configure retention policy clear

(2) configure retention policy to recovery window of 7 days recovery time window strategy

Explanation:

RMAN ensures that existing backups can restore the database to any time within the recovery time window.

For example, if the reply time window is defined as 7 days, then RMAN will keep the full backup and the incremental backup and archive redo logs required so that the database can be restored to the point in time up to 7 days ago.

Meet the conditions:

Current time minus backup time should not be less than 7 (sysdate-backup > = 7)

Backups that are earlier than the latest backups that meet this condition are considered obsolete.

* ensure that you can recover to any point in time in this window, even if there is an updated backup in the recovery window.

How to configure:

RMAN > configure retention policy to recovery window of 7 days

RMAN > configure retention policy clear

2.CONFIGURE BACKUP OPTIMIZATION OFF; # default

BACKUP OPTIMIZATION backup optimization

Explanation:

If backup optimization is turned on, the backup command ignores the same files that have been backed up to the specified device.

After the first backup, the second backup, if you find that there is no change in the tbs02 tablespace, so, the data of tbs02 will not be backed up, this is to save time and space, but the second backup, it does not contain tbs02 data, when we delete the first backup, when there is a problem with tbs02, the second backup will not be able to restore backup optimization is not recommended.

How to configure: RMAN > configure backup optimization on;RMAN > configure backup optimization off

3. CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

Default backup device type for DEFAULT DEVICE TYPE

Explanation:

* two device types *

Disk & sbt (* the destination address of the disk backup is the disk device; * the destination address of the sbt backup is the tape device)

How to configure: RMAN > CONFIGURE DEFAULT DEVICE TYPE TO DISK

RMAN > CONFIGURE DEFAULT DEVICE TYPE TO SBT

4. CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONTROLFILE AUTOBACKUP controls automatic backup of files

Explanation:

When the database starts any backup behavior or changes in the physical structure of the database, a current control file and spfile file are automatically backed up by default.

When automatic backup of control files is not enabled, if file No. 1 system data file is backed up, automatic backup will also be carried out.

How to configure: RMAN > configure controlfile autobackup on;RMAN > configure controlfile autobackup off

5.CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO'% favored; # default

CONTROLFILE AUTOBACKUP FORMAT controls the backup file format for automatic backup of files

* default format:% F

How to configure: RMAN > configure controlfile autobackup format for device type disk to'/ u01qqqapplash backupplash% Fleming match-if the storage path is not changed, it is in the flashback recovery area by default.

RMAN > configure controlfile autobackup format for device type disk clear

-- empty the configuration

6.CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

Parallelism of DEVICE TYPE DISK PARALLELISM devices

Explanation:

Multi-channel simultaneous backup is achieved by setting the degree of parallelism to improve efficiency, but the number of channels must match the number of parallelism. If the number of channels allocated is greater than the set degree of parallelism, RMAN will only write data to the channels that match the degree of parallelism and ignore other channels that exceed the degree of parallelism.

How to configure:

RMAN > configure device type disk parallelism 2 backup type to backupset;RMAN > configure device type disk clear; (clear configuration)

7.CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

Duplex backup of DATAFILE BACKUP COPIES data files

Explanation:

When you create a backup set, you can make multiple identical copies of the backup set at the same time, which improves the reliability of the backup. If one of the copies is corrupted, RMAN can also use the other copies to complete the database repair operation.

Note that you cannot duplex the backup set to the fast recovery area. RMAN can make up to four copies of the backup set at the same time, and each backup slice in the original backup set will be copied, each copy with a unique copy number. Duplex backups apply only to backup sets, not to mirrored copies.

Configuration: RMAN > configure datafile backup copies for device type disk to 2

RMAN > configure datafile backup copies for device type disk clear; (clear configuration)

8.CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

ARCHIVELOG BACKUP COPIES archive log files duplex backup

9.CONFIGURE MAXSETSIZE TO UNLIMITED; # default

MAXSETSIZE * specify the maximum value for each backup set

Configuration:

RMAN > configure maxsetsize to 100m

RMAN > configure maxsetsize clear; (clear configuration)

10.CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

ENCRYPTION FOR DATABASE backup encryption

* enable backup encryption

Configuration:

RMAN > configure encryption for database on

RMAN > configure encryption for database off; (clear configuration)

11.CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

ENCRYPTION ALGORITHM configure encryption algorithm * you can specify different encryption algorithms

12.CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE' DEFAULT' OPTIMIZE FOR LOAD TRUE; # default

COMPRESSION ALGORITHM compression algorithm * compress backup files

13.CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

ARCHIVELOG DELETION POLICY archive log deletion policy

Explanation:

Several archive log backups need to be kept and can be deleted from disk only if the logs meet the archive log deletion policy.

Configuration: RMAN > configure archivelog deletion policy to backed up 2 times to disk;RMAN > configure archivelog deletion policy clear; (empty configuration)

14.CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/ u01qapplash oracleandproduct11.2.0Universe home1anddbsAccordance prod.fills; # default

SNAPSHOT CONTROLFILE NAME controls file snapshots

Explanation:

Ensure the consistency of control files and data files during backup. * controls the location of the file snapshot. By default, the snapshot of the $ORACLE_HOME/dbs control file is a copy of the control file.

Configuration:

Rman > configure snapshot controlfile name to'/ home/oracle/snapcf.ctl'

Rman > configure snapshot controlfile name clear; (clear configuration)

Thank you for your reading, the above is the content of "how to understand Oracle RMAN environmental parameters". After the study of this article, I believe you have a deeper understanding of how to understand Oracle RMAN environmental parameters, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.