Oracle Cloud Infrastructure Documentation

Recovering a Database

Use this procedure to recover a database using the automatic backups created by Recovery Service.

Note

Note: The in-place restore options described in this section do not apply to long-term retention (LTR) backups. You can restore an LTR backup to create a new database. See Create a DB System From a Backup Using the Console for detailed information.

  1. Open the navigation menu, select Oracle Database and then select the relevant database service. Navigate to the required database system details page.

  2. Select the name of the required database.

    For example, to restore a bare metal or virtual machine DB system database, select Oracle Database, Oracle Base Database (VM, BM) and then select a DB system and database that you want to restore.

  3. On the details page, from the Actions menu at the top of the table, select Restore.

  4. Select one of these options:

    • Restore to the latest - Restores the database to the last known good state with the least possible data loss.

    • Restore to a timestamp - Restores the database to the timestamp specified.

    • Restore to SCN - Restores the database using the System Change Number (SCN) specified. This SCN must be valid.

  5. Select Restore and confirm the action.