Oraclerman backup tool parameter settings

It is used to determine which backups are no longer needed. It has three options: assumeretentionpolicytorecoverywindowof7days; CONFIGU

Is used TO determine which backup is no longer needed, it has three options, respectively, configure retention policy to recovery window of 7 DAYS; CONFIGU

Use RMAN> show all;
The following shows the RMAN configuration parameters:

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 '% F'; # default
Configure device type disk parallelism 1; # 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 snapshot controlfile name to 'C: Oracle .. SNCFTEST. ORA '; # default

1. configure retention policy to redundancy 1:
It is used to determine which backups are no longer needed. There are three options available:
Configure retention policy to recovery window of 7 DAYS;
Configure retention policy to redundancy 5;
Configure retention policy to none;
The first type of recover window is to keep all adequate backups and restore the database system to any time point in the last seven days. Any database backup that exceeds the last seven days will be marked as obsolete.

The second type of redundancy is to maintain the latest five Database backups that can be recovered. Any backup that exceeds the latest five copies will be marked as redundancy. The default value is 1.

The third type does not require a persistence policy. clear will be restored to the default persistence policy.

Generally, the most secure method is to adopt the second persistence policy.

2. CONFIGURE BACKUP OPTIMIZATION OFF
The default value is disabled. If enabled, rman will optimize the backup data files and archive files.
3. Configure default device type to disk:
Is to specify all I/O operations of the device type is hard disk or tape, the default value is hard disk
The tape is set to configure default device type to sbt;

4. CONFIGURE CONTROLFILE AUTOBACKUP OFF
Force the database to automatically back up the control file after backing up the file or executing the command to change the database structure. The default value is disabled. In this way, the control file can still be restored after the control file and catalog are lost.

5. configure controlfile autobackup format for device type disk to '% F'
Is to configure the backup path and format of the Control File

6. configure device type disk parallelism 1;
Is to configure the degree of parallelism of the database device type.

7. configure datafile backup copies for device type disk to 1;
Is to configure the number of copies for each database backup. Each oracle backup can have multiple identical copies.

8. configure archivelog backup copies for device type disk to 1
Is to set the storage device type of database archive logs

9. configure snapshot controlfile name to 'C: ORACLE... SNCFTEST. ORA'
Is the storage path and file name of the snapshot file of the configuration control file. This snapshot file is generated during Backup and used to control the read consistency of the file.

10. configure channel device type disk format 'C:... % d_DB _ % u _ % s _ % P ';
Is to configure the backup path and format of the backup file

Configure channel device type disk clear; used to CLEAR the above CHANNEL Configuration

CONFIGURE EXCLUDE FOR TABLESPACE [CLEAR]; this command is used to do not back up the specified tablespace to the backup set. This command is very useful for read-only tablespaces.

--------------

1. Store the backup file to a specified path, such as e: \ backupb
Configure channel device type disk format 'e: \ backupb \ % d_db _ % U ';
The following % d_db _ % u is the storage format
2. You can also specify the control file to be stored in another path, for example, e: \ backupcontrol.
Configure controlfile autobackup format for device type disk to 'e: \ backupcontrol \ % F ';
The following % F is the storage format

======================

Common configure commands in rman:
1. display the current configuration information
======================================
1.01 RMAN> show all;
1.02 check non-default values in RMAN settings:
SQL> select name, value from v $ rman_configure;

2. Common configure options
======================================
2.01 retention policy (retention policy)
Configure retention policy to recovery window of 3 days;
Configure retention policy to redundancy 3;
Configure retention policy clear;

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 _ % F ';
Configure controlfile autobackup clear;
Configrue controlfile autobackup format for device type disk clear;
Configrue snapshot controlfile name to '/cfs01/backup/snapcf/scontrofile. snp ';
Configrue snapshot controlfile name clear;

2.05 parallel lines (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 100 m
Configure channel device type disk rate 1200 K;
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 100 m
Configure channel 1 device type disk clear
Configure channel 2 device type disk clear;

2.06 generate backup copy 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 exclude
Configure exclude for tablespace 'users ';
Configrue exclude clear;

2.08 backup set size maxsetsize
Configure maxsetsize to 1 GB | 1000M | 000000k | unlimited;
Configure maxsetsize clear;

2.09 other options: aupoliciary
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;
---------------------------

% In the format of Rman
% C Number of copies of backup slices
% D Database Name
% D the day in the month (DD)
% M is in the month of the year (MM)
% F a unique name based on DBID, in the form of a c-IIIIIIIIII-YYYYMMDD-QQ, where IIIIIIIIII is the DBID of the database, YYYYMMDD is
Date, QQ is a sequence of 1-
% N Database Name, up to eight characters to the right
% U an eight-character name represents the backup set and Creation Time
% P Number of the backup credits in the backup set, starting from 1 to the number of files created
A unique file name of % U, representing % u _ % p _ % c
ID of the % s backup set
% T backup set Timestamp
% T year month day format (YYYYMMDD)