Restoring a Database for Amazon RDS for Oracle

You can restore a database for Amazon RDS for Oracle.

Note

RDS to RDS restores are not supported and are not possible due to AWS limitations. For information on the supported restores, see Amazon RDS for Oracle.

Before You Begin

The destination Oracle client must have the Cloud Apps package installed.

Procedure

  1. From the navigation pane, go to Protect > Databases.

    The Instances page appears.

  2. Click the instance.

    The instance page appears.

  3. On the Overview tab, in the Recovery points section, select the backup to restore, and then click Restore.

    The Backup content page appears.

  4. Select the parts of the database that you want to restore, and the date and time from which to restore, and then click Restore.

    The Restore options dialog box appears.

  5. From the Destination server list, select the destination host.

  6. In the Destination instance box, enter the destination instance.

  7. To change the number of streams used for the restore operation, in the Number of streams box, enter the number of streams to use.

  8. To specify a staging location for restoring the RMAN backup files to disk, in the Staging path box, enter the path.

  9. To specify the data path for the database files, in the Redirect path for database box, enter the path.

    Note

    The RMAN backup pieces are restored to the staging location. The restore operation then uses these pieces and redirects them to the location specified by the Redirect path for database location. The RMAN restore uses the redirect path for the destination database and the restore datafiles.

  10. To restore the database after the backup pieces are copied to disk, select Restore database.

  11. To recover the database, select Recover database.

    • To recover the database to the current time, select Current time.

    • To recover to a point-in-time, select Point in time, and then select the date and time.

  12. Click Submit.

Loading...