Database Backup:Restore an Oracle database from a logical backup

Procedure

1. Log on to the Database Backup (DBS) console.

2. In the left-side navigation pane, click Backup Schedules. In the top navigation bar, select a region.

3. On the Backup Schedules page, find the backup schedule that you want to manage and click Manage in the Actions column.

4. On the Configure Task page, click Restore Database in the upper-right corner.

5. In the Set Time Restored To step of the Create Restore Task wizard, configure the parameters that are described in the following table and click Next.

   Section	Parameter	Description
   N/A	Task Name	The name of the task. DBS automatically generates a task name. We recommend that you specify a name that can help you identify the task. Task names do not need to be unique.
   Configure Destination Database	Database Location	The location of the destination database to which you want to restore the source database. Make sure that the destination database is running. Valid values: User-Created Database with Public IP Address <IP Address:Port Number> ECS-Hosted Database Express Connect DB/VPN Gateway/Intelligent Gateway PolarDB No public network IP: Port's self-built database (accessed through the database gateway)
   	Database Type	The type of the database that you want to restore. Default value: Oracle.
   	Instance Region	The region in which the destination database resides. Note This parameter is displayed only if you set the Database Location parameter to ECS-Hosted Database, PolarDB, or No public network IP: Port's self-built database (accessed through the database gateway).
   	Address	The public endpoint that is used to connect to the destination database. Note This parameter is displayed only if you set the Database Location parameter to User-Created Database with Public IP Address <IP Address:Port Number>, Express Connect DB/VPN Gateway/Intelligent Gateway, or No public network IP: Port's self-built database (accessed through the database gateway).
   	Port Number	The port number that is used to connect to the destination database. Note By default, this parameter is not displayed if you set the Database Location parameter to PolarDB.
   	ECS Instance ID	The ID of the Elastic Compute Service (ECS) instance. Note This parameter is displayed only if you set the Database Location parameter to ECS-Hosted Database.
   	PolarDB Instance ID	The ID of the PolarDB instance. Note This parameter is displayed only if you set the Database Location parameter to PolarDB.
   	Peer VPC	The virtual private cloud (VPC) in which the destination database resides. Note This parameter is displayed only if you set the Database Location parameter to Express Connect DB/VPN Gateway/Intelligent Gateway.
   	Gateway instance ID	The ID of the database gateway. Note This parameter is displayed only if you set the Database Location parameter to No public network IP: Port's self-built database (accessed through the database gateway).
   	SID	The system identifier (SID) of the destination database.
   	Database Account	The username of the account that is used to connect to the destination database.
   	Password	The password of the account that is used to connect to the destination database. After you enter the username and password of the database account, click Test Connection next to the password to check whether the information about the destination database is valid. If the specified information is valid, the "Test Passed" message appears. If the "Test Failed" message appears, click Check next to Test Failed. Modify the information about the destination database based on the check results.
   	Compliance warranty regarding cross-border data transfers	Read and agree to the compliance commitment by selecting the check box.

6. In the Configure Objects to Restore step, configure the parameters that are described in the following table and click Precheck.

   Parameter or setting	Description
   Conflict Handling	By default, Rename Object with the Same Name is selected for the Conflict Handling parameter. For example, if the job_info table to be restored shares the same name with a table in the destination database, the system renames the restored table in the following format: job_info_dbs_<Restore task ID>_<Timestamp>.
   Objects to Restore	Select the database or table that you want to restore in the Available section and click the rightwards arrow to add it to the Selected section. Note DBS allows you to restore some databases by database or table. This reduces the amount of data to be restored and shortens the recovery time objective (RTO). For more information about the supported restoration granularity, see Database engines and features.

7. If the Precheck Passed message appears in the Precheck dialog box, click Start Task.

   To view the database restoration progress, click Restore Tasks in the left-side navigation pane.

   Note

   The restoration duration depends on the specifications of the backup schedule and the size of the database to be restored. The restoration duration is shorter for a backup schedule with higher specifications. For more information, see Performance tests on backup and restoration.

Related operations

• You can also directly create, start, or view a restoration task by calling an API operation. For more information, see CreateRestoreTask, StartRestoreTask, or DescribeRestoreTaskList.

• If the backup data at the specified point in time does not meet your business requirements, you can click Start Full Data Backup in the upper-right corner of the Full Data page to manually back up the database. After the backup is complete, configure a restoration task to restore the database to the point in time of the latest full backup.

• If an exception or error occurs in the restoration task, refer to Common Errors and Troubleshooting for troubleshooting.