Rman-configure command

Source: Internet
Author: User

Configuration in Oracle 10g
Use Rman>show all;
The Rman configuration parameters can be displayed as:
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:
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.

2. CONFIGURE Backup optimization off
  default is off, and if turned on, Rman will perform an optimized algorithm for the backed up data files and archive files.
3. 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 hard disk
  The tape setting is Configure default device TYPE to SBT;
4. 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, with the default value off. This avoids the control files and catalog loss, the control files can still be recovered.
5. CONFIGURE controlfile autobackup format for DEVICE TYPE DISK to '%F '
  is the backup path and backup format for the configuration control file
6. CONFIGURE DEVICE TYPE DISK PARALLELISM 1;
  is the degree of parallelism of the configuration database device type.
7. CONFIGURE datafile BACKUP COPIES for DEVICE TYPE DISK to 1;
  is the copy number for each backup of the configuration database, and each backup of Oracle can have multiple copies of the exact same copy.
8. CONFIGURE ARCHIVELOG BACKUP COPIES for device type DISK to 1
  is the storage device type that sets the archive log for the database
9. CONFIGURE SNAPSHOT controlfile NAME to ' c:oracle ... Sncftest. ORA '
  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.
10. CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ' c:...%d_db_%u_%s_%p ';
  is the backup path and backup format for configuring backup files

CONFIGURE CHANNEL DISK CLEAR; Used to clear the channel configuration above
CONFIGURE EXCLUDE for tablespace <tablespace> [CLEAR]; This command is used to not back up the specified tablespace to the backup set, which is useful for read-only table spaces.
1. Store the backup file to the specified path, such as E:\BACKUPB
Configure channel device type disk format ' e:\backupb\%d_db_%u ';
The%d_db_%u behind is the storage format
2. We can also specify the control file to be stored separately in another path: such as E:\backupcontrol
Configure Controlfile autobackup format for device type disk to ' E:\backupcontrol\%F ';

The%f behind is the storage format
================
Common Configure commands in Rman 2007-06-21 15:37
1 displaying 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;
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;
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 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;
Rman in format of%
Number of copies of%c backup slices
%d database name
%d The day ordinal (DD) in the month
%M in the month of the year (MM)
%F a unique name based on dbid, which is in the form of C-IIIIIIIIII-YYYYMMDD-QQ, where IIIIIIIIII is the DBID,YYYYMMDD for the database
Date, QQ is a sequence of 1-256
%n database name, fill to the right up to a maximum of eight characters
%u a eight-character name represents the backup set and the creation time
%p The backup piece number in the backup set, starting from 1 to the number of files created
%u a unique file name that represents%u_%p_%c
%s The number of the backup set
%t Backup set Timestamp
%T date Format (YYYYMMDD)
Take all the commands in a week after the test is recorded as follows (2010.08.24):

Rman-configure command

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.