Restore an Oracle database

Billing

No fees are charged for the restore feature.

Usage notes

• Cloud Backup's backup and restore speeds are based on data from a lab test environment and are for reference only. For more information, see Database backup and restore speeds.

• To restore data to a new Oracle instance, you must first register the instance in the Cloud Backup console and make sure that its database status is Online.

Restore scope

• Recovery Point

  You can restore data to any specified point in time.

• Restore Items

  You can restore an Oracle database instance, a control file, a PFILE/SPFILE, and a password file.

Create an Oracle restore job

To restore a backed-up database, follow these steps:

1. Log on to the Cloud Backup console.

2. Click Backup > Database Backup, select your region, then click Oracle. Click the ECS Database Instance or Local Database Instance tab. Find the target Oracle instance and, in the Actions column, click Restore.

3. In the Create Restore Job panel, follow the configuration wizard to complete the following operations.

   1. Configure Recovery Point and Restore Items, then click Next.

      Manually drag the Recovery Point on the track to specify the time to restore the database. Select the restore items. You can restore an Oracle database instance, a control file, a PFILE/SPFILE, and a password file.

      Recovery Point Type: select By Time, then select the target recovery time on the time slider. The Restore Items options include:

      • Database Instance

      • Control File

      • PFILE/SPFILE

      • Password File

   2. Configure the Plan Name for this restore job, start the restore immediately, then click Next.

      Only immediate restore is supported. You cannot specify a restore time.

   3. Configure Restore Config, then click Next.

      Parameter	Description
      Concurrent Threads	The number of concurrent threads used to restore data.
      Retry Time	The interval at which the database reconnects after a disconnection during the restore. Unit: minutes.
      Speed Limit	The amount of data restored per second. Unit: MB/s. A value of 0 indicates no speed limit.

   4. Select a destination instance for the restore, then click Create.

      Use the Specified Account field to select the account that owns the destination resource. The default is the current account, but you can also select another account. Then select the destination database instance for the restore. By default, the Oracle instance backed up is selected, but you can also restore to another registered Oracle instance.

      Note

      Select the Only Check Offline Instance option to include offline instances in the list. You can restore data from these instances to a new instance where the client is installed, enabling cross-instance data restoration. For more information, see Description of the Only Check Offline Instance feature.

   After the restore job is created, the system starts to restore the database. On the Restore Plan tab, you can view the restore job that you created. After the restore is complete, the status changes to Completed.

   After the restore job is created, it is displayed in the backup and restore management list. After the job is complete, the status is displayed as Completed 100%, and you can expand Detail of Restore to confirm the source instance, destination instance, and configured parameters such as the number of concurrent threads, retry time, and speed limit.

   Important

   If a restore job for an Oracle RAC database or an Oracle Data Guard standby database fails, the cause may be that password-free logon was used during instance activation. In the Actions column of the target database, click More > Reactivate, and use the database username and password to reactivate the instance, then retry.

   After the restore is complete, you can log on to the Oracle database to verify the data.

FAQ

FAQ About Database Backup