Restore a Database

This topic provides the details and procedure to restore a database to a point in time, to a system change number (SCN), or to the latest backup.

Before you begin, review the following:

• You can restore an Oracle AI Database 26ai in the same Database home (in-place restore) only.

• After you perform a point-in-time restore to a timestamp or SCN on NFS storage, wait approximately 10 minutes before starting a backup operation. Starting the backup operation sooner might cause the backup operation to fail.

Procedure

Perform the following steps in the Console.

1. On the Data Infrastructures list page, select the Data Infrastructure that you want to work with. If you need help finding the list page or the Data Infrastructure, see List Data Infrastructures.

2. On the Data Infrastructure details page, select the VM Cluster tab to view the list of all VM Clusters.
3. On the VM Clusters tab, select the VM Cluster that you want to work with.

4. On the VM Cluster details page, select the Databases tab to view the list of all databases.

5. On the Databases tab, select the Database that you want to work with.

6. On the Database details page, select Restore Database.

7. In the Restore Database panel, provide the following details.

   • Restore type: Select from one of the following restore type.

     • Restore to latest: The database is restored and recovered with zero or the least possible data loss.

     • Restore to a timestamp: The database is restored and recovered to the specified timestamp.

     • Restore to SCN: The database is restored and recovered to the specified Oracle AI Database System Change Number (SCN). The specified SCN must be valid otherwise the operation fails.

8. Select Restore.