Oracle Cloud Infrastructure Documentation

Recovering a Database

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

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. Log in to your OCI tenancy.
  2. In the navigation menu, click Oracle Database, select the relevant database service, and navigate to the required database system page.
  3. Choose a compartment containing the database you want to view.
  4. Click the name of the required database.
    For example, to restore a bare metal or virtual machine DB system database, click Oracle Database, select Oracle Base Database (VM, BM), select a DB system, and then select the database that you want to restore.
  5. In the Database Details page, click Restore.
  6. Select one of the following 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.
  7. Click Restore database and confirm the action.