Configure Clause
Change persistent RMAN configuration settings.
Syntax:
CONFIGURE deviceConf; CONFIGURE backupConf; CONFIGURE AUXNAME FOR DATAFILE datafileSpec { TO 'filename' | CLEAR }; CONFIGURE SNAPSHOT CONTROLFILE NAME { TO 'filename' | CLEAR }; CONFIGURE cfauConf; deviceConf::= { DEFAULT DEVICE TYPE { TO deviceSpecifier | CLEAR } | DEVICE TYPE deviceSpecifier { PARALLELISM integer | CLEAR } | [AUXILIARY] CHANNEL [integer] DEVICE TYPE deviceSpecifier { allocOperandList | CLEAR } } allocOperandList::= { PARMS [=] 'channel_parms' | FORMAT [=] 'format_string' [, 'format_string']… | { MAXPIECESIZE [=] integer | RATE [=] integer } [ K | M | G ] . . . }… connectStringSpec::= ['] [userid] [/ [password]] [@net_service_name] ['] backupConf::= { RETENTION POLICY { TO { RECOVERY WINDOW OF integer DAYS | REDUNDANCY [=] integer | NONE } | CLEAR } | MAXSETSIZE { TO { integer [ K | M | G ] | UNLIMITED } | CLEAR } | { ARCHIVELOG | DATAFILE } BACKUP COPIES FOR DEVICE TYPE deviceSpecifier { TO integer | CLEAR } | BACKUP OPTIMIZATION { ON | OFF | CLEAR } | EXCLUDE FOR TABLESPACE tablespace_name [CLEAR] } cfauConf::== CONTROLFILE AUTOBACKUP { ON | OFF | CLEAR | FORMAT FOR DEVICE TYPE deviceSpecifier { TO 'format string' | CLEAR } }
Examples
Show all configurable settings:
RMAN> SHOW ALL;
Write disk backups to
the /tmp
directory:
(%U will be replaced with unique
filenames)
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/tmp/%U';
Backup using a flash recovery area rather than disk
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT CLEAR;
Configure RMAN to back up the control file after each backup
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
By default, RMAN automatically names control file backups and
stores them in the flash recovery area.
To configure RMAN
to write control file backups to the /cfilebackups
directory:
(
%F will generate a unique filename)
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/cfilebackups/cf%F';
Ensure that RMAN retains all backups needed to recover the database to any point in time in the last 7 days:
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
Retain three backups of each datafile:
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
Delete backups no longer required by the retention policy:
RMAN> DELETE OBSOLETE
To override the configured retention policy for individual backups
- use BACKUP.. KEEP
(or CHANGE.. KEEP)
Configure backups to run in parallel by assigning two sbt
channels:
RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 2;
Reset any CONFIGURE
setting to its default by running the command
with the CLEAR
option
RMAN> CONFIGURE CHANNEL DEVICE TYPE sbt CLEAR; RMAN> CONFIGURE RETENTION POLICY CLEAR;
Unique filenames are:
DBID, day, month, year, and sequence
number.
"The desire for safety stands against every great and noble enterprise"
- Cornelius Tacitus
Related Oracle Commands:
BACKUP - Back up database files, archive
logs, backups, or copies.
CROSSCHECK - Check whether backup items still exist.
RECOVER - Perform media recovery from RMAN backups and copies.
RESTORE - Restore RMAN backups and copies.
RUN - Some RMAN commands are only valid inside a RUN block.
SET - Settings for the current RMAN session.
SHOW - Display the current configuration
Related Views:
RMAN persistent configuration settings: RC_RMAN_CONFIGURATION V$RMAN_CONFIGURATION