All Products
Search
Document Center

Database Backup:Restore an Oracle database from a logical backup

Last Updated:Nov 14, 2023

This topic describes how to use Database Backup (DBS) to restore an Oracle database from a logical backup.

Prerequisites

The database is backed up. For more information, see Back up an Oracle instance by using logical backup.

Procedure

This section provides an example on how to restore an Oracle database from a logical backup.

  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 ID of your backup schedule 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 restoration 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. 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)

    Note

    You must make sure that the destination database is available when you perform the restoration.

    Database Type

    The type of the database that you want to back up. Default value: Oracle.

    Instance Region

    The region in which the destination database to which you want to restore your database resides.

    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.

    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.

    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.

    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.

    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.

    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.

    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 parameters are valid, the Test Passed message is displayed. If the Test Failed message is displayed, click Check next to Test Failed. Modify the information about the destination database.

    Compliance warranty regarding cross-border data transfers

    Read the statement of compliance and select I have read and agree to the preceding compliance commitment.

  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 shares the same name with another table during the restoration, the system renames the new table to job_info_dbs_<restoration task ID>_</timestamp> by default.

    Objects to Restore

    Select the database or table that you want to restore in the Available section and click the right arrow to add it to the Selected section.

    Note

    DBS allows you to restore a single database or table. This reduces the amount of data to be restored and shortens the recovery time objective (RTO).

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

    You can click Restore Tasks in the left-side navigation pane to view the database restoration progress.

    Note

    The duration of the restoration depends on the specification of the backup schedule and the size of the database. Less time is required for the restoration of a backup schedule with higher specifications. For more information, see Performance tests on backup and restoration.

Related API operations

API operation

Description

CreateRestoreTask

Creates a restoration task.

StartRestoreTask

Starts a restoration task.

DescribeRestoreTaskList

Views restoration tasks.