Use this procedure to recover a database using backups created by Recovery
Service.
- Log in to your OCI tenancy.
- In the navigation menu, click Oracle Database, select the relevant database service, and navigate to the required database system page.
- Choose a compartment containing the database you want to view.
- 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.
- In the Database Details page, click Restore.
- 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.
- Click Restore database and confirm the action.