Recovering a Database

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

  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.