Using Oracle RMAN to Restore

By: Ian Abramson, Michael Abbey, Michelle Malcher, Michael Corey


When you create backups with RMAN, they get created in one or more backupsets; these backupsets are in proprietary format. In order to use them again for recovery, first you need to extract them from this proprietary format. This process is called restore.

You use the RESTORE command of RMAN to restore the backup. For example, in order to restore the backup of a database, use the following command at the RMAN prompt:

p276-01

One or more tablespaces can be restored using the following commands:

p276-02

p277-01

Leave a Reply