RMAN 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 

 
Copyright © 1999-2024 SS64.com
Some rights reserved