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.

Procedure

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

  1. Log on to the DBS console.
  2. In the left-side navigation pane, click Backup Schedules. On the Backup Schedules page, select a region in the upper-left corner.
  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, set the parameters that are described in the following table. Then, click Next.
    Section Parameter Description
    N/A Task Name The name of the restore task. DBS generates a task name. We recommend that you set a descriptive name that is easy to identify. Task names do not have to be unique.
    Set Time Restored To Time Range Available to Restore The time range available to restore the source database. DBS displays the available time range.
    Restore To The point in time to which you want to restore the source database. The value must be within the time range that is specified by the Time Range Available to Restore parameter.
    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 Instance
    • 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 restore operation.
    Database Type The type of the destination database. Default value: Oracle.
    Instance Region The region where the destination instance to which you want to restore the source database resides.

    This parameter is displayed only when you set the Database Location parameter to ECS-Hosted Database, POLARDB Instance, 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 when 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 that is used to connect to the destination database.

    By default, this parameter is not displayed when you set the Database Location parameter to POLARDB Instance.

    ECS Instance ID The ID of the Elastic Compute Service (ECS) instance where the destination database resides.

    This parameter is displayed only when you set the Database Location parameter to ECS-Hosted Database.

    PolarDB Instance ID The ID of the PolarDB instance to which you want to restore the source database.

    This parameter is displayed only when you set the Database Location parameter to POLARDB Instance.

    Peer VPC The virtual private cloud (VPC) where the destination database resides.

    This parameter is displayed only when you set the Database Location parameter to Express Connect DB/VPN Gateway/Intelligent Gateway.

    Database gateway instance ID The ID of the database gateway instance.

    This parameter is displayed only when 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 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.
  6. In the Configure Objects to Restore step, set the parameters that are described in the following table. Then, click Precheck in the lower-right corner.
    Parameter Description
    Conflict Handling Select one of the following methods for conflict handling:
    • Fail When Object with the Same Name Exists
    • Rename Object with the Same Name. If you select this option, DBS renames the new table that is to be created by the restore task. For example, a table to be restored in the source database and an existing table in the destination database have the same name job_info. DBS renames the new table that is restored from the table in the source database in the following format: job_info_dbs_<ID of the restore task>_</Timestamp>.
    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 feature reduces the amount of data to be restored and shortens the recovery time objective (RTO).
  7. After 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 amount of time used to restore a database depends on the specification of the backup schedule and the size of the database. Higher specifications offer a higher restore speed. For more information, see Performance tests on backup and restoration.