Database Backup (DBS) supports backup and restore for Oracle instances. DBS provides the features of single-table restore, remote backup, and long-term archiving.

Features

Feature Description
Remote backup DBS supports backup of an Oracle instance to a database on the cloud of another region. DBS allows you to restore the backup data to a standalone instance in a data center or a database on the cloud.
Long-term archiving DBS can retain your backup data for up to five years. After the five years, DBS automatically transfers the backup set to Archive Storage.
Backup speed limit DBS allows you to limit the backup speed to reduce the negative impact of backup operations on the database performance.
Compressed storage DBS supports native compression schemes of Oracle databases and the LZ4 compression algorithm.
Streaming backup DBS directly writes the backup data to Object Storage Service (OSS) without storing the data on a local disk first.
Encryption DBS uses HTTPS encryption to transfer data, and AES-256 encryption to store data.

Create a backup schedule

  1. Log on to the DBS console.
  2. On the Backup Schedules page, click Create Schedule in the upper-right corner to go to the DBS buy page.
  3. Set the parameters as described in the following table and click Buy Now.
    Section Parameter Description
    Basic Settings DBS Region The region where the DBS instance that you want to purchase resides. Make sure that the selected region is the same as the region where you want to store the backup data.
    Database Type The type of the database that you want to back up. In this example, select Oracle.
    Specification The type of the DBS instance that you want to purchase. We recommend that you select xlarge for better performance. For more information, see Select a DBS instance type.
    Backup Method The mode for backing up data. Valid values: Physical Backup and Logical Backup.
    Storage Size The storage size of the DBS instance that you want to purchase. You do not need to specify the storage size when you purchase a DBS instance. The storage size is charged in pay-as-you-go mode. You can also purchase a storage plan. A favorable discount is available if you purchase a storage plan with a large size.
    Purchase Plan Quantity The number of DBS instances that you want to purchase. Set this parameter based on your actual needs.
    Duration The validity period of the purchased DBS instance. Set this parameter based on your actual needs.
  4. On the Confirm Order page, confirm your order information, read and agree to DBS Agreement of Service by selecting the check box, and then click Pay.
  5. After you pay for the order, log on to the DBS console and click Backup Schedules in the left-side navigation pane to view the new backup schedule.

Configure the backup schedule

  1. Log on to the DBS console.
  2. In the left-side navigation pane, click Backup Schedules.
  3. On the Backup Schedules page, find the target backup schedule and click Configure Backup Schedule in the Actions column.
  4. In the Configure Backup Source and Destination step of the Configure Backup Schedule wizard, configure the backup source and destination.
    Section Parameter Description
    None Schedule Name The name of the backup schedule. DBS automatically generates a schedule name. We recommend that you set an informative name for easy identification. You do not need to use a unique schedule name.
    Backup Source Information Backup Mode The mode for backing up data. By default, the backup mode that you selected when you purchased the DBS instance is used.
    Database Location The location of the database that you want to back up. 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)
    Database Type The type of the database that you want to back up. In this example, this parameter is set to Oracle.
    Instance Region The region where the database that you want to back up resides. This parameter is available only when you set Database Location 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 used to connect to the database that you want to back up. This parameter is available only when you set Database Location 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 used to connect to the database that you want to back up. This parameter is unavailable when you set Database Location to PolarDB Instance.
    ECS Instance ID The ID of the Elastic Compute Service (ECS) instance where the database that you want to back up resides. This parameter is available only when you set Database Location to ECS-Hosted Database.
    PolarDB Instance ID The ID of the PolarDB instance that you want to back up. This parameter is available only when you set Database Location to PolarDB Instance.
    Peer VPC The virtual private cloud (VPC) where the database that you want to back up resides. This parameter is available only when you set Database Location to Express Connect DB/VPN Gateway/Intelligent Gateway.
    Database gateway instance ID The ID of the database gateway instance. This parameter is available only when you set Database Location to No public network IP: Port's self-built database (accessed through the database gateway).
    SID The SID of the database that you want to back up.
    Database Account The username of the account used to connect to the database that you want to back up.
    Password The password of the account used to connect to the database that you want to back up. After you enter the database account and password, click Test Connection next to Password to check whether the information about the database that you want to back up is correct. 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 database that you want to back up based on the check results.
    Backup Destination Information Backup Storage Type The type of the storage that you use to back up data. Valid values:
    • DBS built-in storage
    • OSS for user
    OSS Bucket Name The name of the OSS bucket. This parameter is available only when you set Backup Storage Type to OSS for user.
    Storage Encryption The method that you use to encrypt the stored data. Valid values:
    • Non-encrypted
    • Encrypted
    • KMS Encrypted
  5. In the lower-right corner of the page, click Next.
  6. In the Edit Backup Objects step, find the database or table that you want to back up in the Available section. Click the rightwards arrow to add the selected database or table to the Selected section. Then, click Next.
    Note If you back up an entire database, permission data and stored procedures are also backed up.
  7. In the Configure Backup Time step, set the parameters as described in the following table and click Next.
    Parameter Description
    Full-scale Backup Frequency The frequency of the backup schedule. Valid values: Periodic Backup and Single Backup.
    Full Data Backup Recurrence The day in a week on which DBS runs the backup schedule.
    Full Data Backup Start At The start time of the backup. If the time taken for a full data backup is longer than the backup interval, DBS skips the next backup.
    Real-Time Transaction Log Backup Specifies whether to enable incremental backup.
    Maximum Concurrent Threads for Full Data Backup The maximum number of concurrent threads available for a full data backup. The value varies with the specifications of the DBS instance that you purchased when you created the backup schedule.
  8. In the Edit Lifecycle step, configure the lifecycle for a full data backup in the Configure Full Data Backup Lifecycle section.
  9. After the configuration is complete, click Precheck in the lower-right corner of the page.
  10. If the Precheck Passed message appears, click Start Task.
    Note When the status of the backup schedule changes to Running, the backup schedule takes effect.

View the backup schedule

  1. Log on to the DBS console.
  2. In the left-side navigation pane, click Backup Schedules.
  3. On the Backup Schedules page, find the target backup schedule and click Manage in the Actions column.
  4. The Configure Task page displays the basic information and running status of the backup schedule.
  5. In the left-side navigation pane, choose Backup Tasks > Full Data to view information about all full data backups.

Restore an Oracle instance

  1. Log on to the DBS console.
  2. In the left-side navigation pane, click Backup Schedules.
  3. On the Backup Schedules page, find the target 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, set the parameters as described in the following table and click Next.
    Section Parameter Description
    None Task Name The name of the restore task. DBS automatically generates a task name. We recommend that you set an informative name for easy identification. You do not need to use a unique task name.
    Set Time Restored To Time Range Available to Restore The time range available for restoring backup sets. DBS automatically displays the available time range.
    Restore To The point in time that you want to restore the source database to. 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 database that you want to restore. 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)
    Database Type The type of the database that you want to restore. In this example, this parameter is set to Oracle.
    Instance Region The region where the database that you want to restore resides. This parameter is available only when you set Database Location 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 used to connect to the database that you want to restore. This parameter is available only when you set Database Location 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 used to connect to the database that you want to restore. This parameter is unavailable when you set Database Location to PolarDB Instance.
    ECS Instance ID The ID of the ECS instance where the database that you want to restore resides. This parameter is available only when you set Database Location to ECS-Hosted Database.
    PolarDB Instance ID The ID of the PolarDB instance that you want to restore. This parameter is available only when you set Database Location to PolarDB Instance.
    Peer VPC The VPC where the database that you want to restore resides. This parameter is available only when you set Database Location to Express Connect DB/VPN Gateway/Intelligent Gateway.
    Database gateway instance ID The ID of the database gateway instance. This parameter is available only when you set Database Location to No public network IP: Port's self-built database (accessed through the database gateway).
    SID The SID of the database that you want to restore.
    Database Account The username of the account used to connect to the database that you want to restore.
    Password The password of the account used to connect to the database that you want to restore. After you enter the database account and password, click Test Connection next to Password to check whether the information about the database that you want to restore is correct. 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 database that you want to restore based on the check results.
  6. In the Configure Objects to Restore step, set the parameters as described in the following table and click Precheck.
    Parameter Description
    Conflict Handling The method that you use to handle a name conflict. Valid values: Fail When Object with the Same Name Exists and Rename Object with the Same Name. If you select Rename Object with the Same Name, DBS renames the new table that is to be created by the restore task. Assume that a table to be restored in the source database and an existing table in the destination database have the same name job_info. The system renames the new table, which 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 The database or table that you want 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.
  7. If the Precheck Passed message appears, click Start Task.