Database Backup (DBS) provides features such as single table restoration, remote backup, and long-term archiving for Oracle instances.

Features

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

Usage notes

If your Oracle databases are deployed in Windows, do not use physical backup.

Create a backup schedule

Create a backup schedule. For more information, see Purchase a backup schedule.
Note When you purchase a backup schedule, set Database Type to Oracle and Backup Method to Logical Backup.

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, click Configure Backup Schedule in the Actions column corresponding to the backup schedule that you purchased.
  4. In the Configure Backup Source and Destination step of the Configure Backup Schedule wizard, configure the backup source and destination.
    Configure logical backup for Oracle databases
    Section Parameter Description
    N/A Schedule Name The name of the backup schedule. DBS generates a backup schedule name. We recommend that you set a descriptive name that makes the backup schedule easy to identify. Backup schedule names do not have to be unique.
    Backup Source Information Backup Mode The method that is used to back up data. By default, the backup method that you selected when you purchased the backup schedule 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 database that you want to back up. Default value: Oracle.
    Instance Region The region where the database that you want to back up is deployed.

    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.

    If you set Database Location to POLARDB Instance, this parameter is unavailable.

    ECS Instance ID The ID of the 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.

    If you set Database Location to POLARDB Instance, this parameter is unavailable.

    Peer VPC The 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.

    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 system identifier (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 back up.
    Password The password of the account used to connect to the database that you want to back up.

    After you enter the username and password of the database account, click Test Connection next to the password to check whether the information of 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 instance that you want to back up based on the check results.

    Backup Destination Information Backup Storage Type The type of storage used to back up data. Valid values:
    • DBS built-in storage (recommended)
    • OSS for user
    Note In this example, select DBS built-in storage (recommended). If you select OSS for user, you must set the OSS Bucket Name parameter.
    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 is used to encrypt the stored data. Valid values:
  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 right arrow to add the selected database or table to the Selected section. Then, click Next.
    Note If you back up an entire database, the 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.
    Note If you select Periodic Backup, you must set the Full Data Backup Recurrence and Full Data Backup Start At parameters.
    Full Data Backup Recurrence The days of the week on which DBS runs the backup schedule.
    Full Data Backup Start At The start time of the backup.
    Note If the time required to complete 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.
    Note The maximum number of actual concurrent threads varies based on backup schedule specifications.
  8. In the Edit Lifecycle step, configure the lifecycle for a full data backup in the Configure Full Data Backup Lifecycle section.
    Note If you select Enable for the Real-Time Transaction Log Backup parameter, you must configure the backup time for incremental backup data.
  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.
    After data is backed up, you can view the backup schedule or restore the backup data. For more informtaion, see View backup schedule and Restore Oracle databases.