RMAN Example: Performing Oracle Flash Recovery Area Backups

The Oracle Flash Recovery Area (FRA) is a directory that contains Oracle datafiles, archived redo logs, backup pieces, the control file, and image copies.

This backup has the advantages of automatic file management and quick recovery, but has the disadvantage of requiring more storage space than the database.

Best Practice: The Oracle Flash Recovery Area (FRA) can run out of space, so schedule regular backups of the Flash Recovery Area to the backup media.

Before You Begin

1. If you run the RMAN script on a UNIX environment, relink the SBT library or use PARMS in the Allocate Channel Command.

2. Use a unique backup piece format to avoid conflicting backup piece names.

3. Place the database in ARCHIVELOG mode.

4. Optional: To have the CommCell Console authenticate the job, configure the parameters for CommCell Console third-party job authentication.

Procedure

• On the RMAN command line, run the following sample script, substituting any required or optional Oracle SBT parameters.

  For information on required and optional SBT parameters, see SBT Parameters.

  run
  {
  allocate channel ch1 type 'sbt_tape';
  allocate channel ch2 type 'sbt_tape' ;
  backup filesperset = 32 format '%d_%U_%t'
  recovery area;
  }