All Products
Search
Document Center

Cloud Backup:Restore an Oracle database

Last Updated:Mar 21, 2024

After you use Cloud Backup to back up an Oracle database to a backup vault, you can restore the Oracle database to the source Oracle database or another registered Oracle database.

Prerequisites

Billing

You are not charged for the restore feature.

Precautions

  • The backup speed and recovery speed of Cloud Backup are obtained in a test environment. The values are provided for reference only. For more information, see Backup speed and recovery speed.

  • If you want to restore data to a new Oracle database, you must register the Oracle database in the Cloud Backup console and make sure that the database is in the Running state.

Restore content

  • Recovery point

    You can restore data to any specified point in time.

  • Restore items

    You can restore Oracle databases, control files, PFILE/SPFILE, and password files.

image.png

Create a restore job for an Oracle database

To create a restore job, perform the following steps:

  1. Log on to the Cloud Backup console.

  2. In the left-side navigation pane, choose Backup > Database Backup.

  3. In the top navigation bar, select a region.

  4. On the Database Backup page, click Oracle.

  5. Click the ECS Database Instance or Local Database Instance tab.

  6. Find the Oracle database for which you want to create a restore job and click Restore in the Actions column.

  7. In the Create Restore Job panel, perform the following steps.

    1. Configure the Recovery Point and Restore Items parameters, and click Next.

      Manually drag the slider for Recovery Point to specify the time to restore the database. Select the restore content, including Oracle databases, control files, PFILE/SPFILE, and password files.image.png

    2. Specify Plan Name for the restore job and start the job immediately. Then, click Next.

      You can only start the restore job immediately. You cannot specify the restoration time.

    3. In the Restore Config step, configure the parameters and click Next.

      Parameter

      Description

      Concurrent Threads

      The number of concurrent threads used when files are being restored.

      Retry Time

      The time interval between two consecutive reconnection attempts if the database is disconnected during restoration. Unit: minutes.

      Speed Limit

      The maximum size of data that is restored per second. Unit: MB/s. The value 0 indicates that the speed is unlimited.

    4. Select a database to which you want to restore the data of the source database and click Create.

      By default, the Oracle database that is last backed up is selected. You can also restore the data to another registered Oracle database.image.png

    After you create a restore job, the job automatically starts. On the Restore Plan tab, you can view the created restore job. After the restore job is completed, the job status changes to Completed.image.png

    Then, you can log on to the Oracle database to verify data.

FAQ

What do I do if the status of an Oracle database is Unknown in the console?