RMAN Example: Performing Oracle Archive Log Backups

You can use archive log backups to recover database transactions that have been lost due to an operating system or disk failure. Apply the archive logs to an online backup to recover a database.

By default, full backups include both data and archive logs, but you can also perform separate archive log backups.

Best Practice: Schedule an Oracle archive log backup every 20 minutes on busy databases.

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
  format '%d_%U_%t'
  (archivelog all delete input); 
  }