RMAN (Recovery Manager) commands

This manual describes an overview of ‘RMAN (Recovery Manager) commands’ to make a backup and restore of a complete or partitial Oracle Database. A backup and restore of datafiles, tablespaces, pfile, archivelog files.

  • Installation of Oracle Enterprise Linux or other.
  • Installation of Oracle Database Server 10g/11g/12c.

The necessary software can be downloaded by clicking on the link(s) below.

  • n.a.

Check Backups



Availability of backups between two dates



Back up the database, and control file

The control file keeps information that tells you how the backups are named.

Backup datafiles

Backup all datafiles in the database

(bit-for-bit copy of the database)

Backup archive logs

Backup tablespace

Backup controlfile

Backup parameter file

Backup all

Create a consitent backup and keep the backup for a year. (it overulez the retention policy parameter)

Backup controle

Backup Validation.

Backup options


Disk backups to the /tmp directory (%U unique naming format)

Configure RMAN to backup the control file

By default the controlfile is backup-ed to the flash recovery area.

Configure RMAN to keep backups 7 days.

Keep three backups of each datafile

Parallel backup

Configure backups to be executed parallel with two sbt channels. Reset any CONFIGURE setting to its default by running the command with the CLEAR option

Progress script backup

Backupset Compression


The AS COMPRESSED BACKUPSET option of the backup command allows RMAN to perform binary compression of backupsets. The resulting backupsets do not need to be uncompressed during recovery. It is most useful in the following circumstances:

  • You are performing disk-based backup with limited disk space.
  • You are performing backups across a network where network bandwidth is limiting.
  • You are performing backups to tape, CD or DVD where hardware compression is not available.

The following examples assume that some persistent parameters are configured in a similar manner to those listed below.

The AS COMPRESSED BACKUPSET option can be used explicitly in the backup command.

Alternatively the option can be defined using the configure command.

Point in time recovery


Preview restore restore of the database  to an older time.

Restore and recover of the whole database

Restore and recover a tablespace

Restore and recover a datafile

Media recovery


  1. Mount or open the database.
  2. Mount the database when performing whole database recovery, or open the database when performing online tablespace recovery.
  3. To perform incomplete recovery, use the SET UNTIL command to specify the time, SCN, or log sequence number at which recovery terminates. Alternatively, specify the UNTIL clause on the RESTORE and RECOVER commands.
  4. Restore the necessary files with the RESTORE command.
  5. Recover the datafiles with the RECOVER command.
  6. Place the database in its normal state. For example, open it or bring recovered tablespaces online.

Restore Validation confirms that a restore could be run, by confirming that all database files exist and are free of physical and logical corruption, this does not generate any output.

Delete backups en archives


Crosschecking checks the catalog of the controlfile with the physical backups.

Delete Error messages


  • n.a.

Please let me know if this manual ‘RMAN (Recovery Manager) commands’ was usefull to you. If there are faults or you have suggestions regarding this manual, please let me know. No rights can be derived from this manual.



Maarten Schoonus

Leave a Reply