All Products
Search
Document Center

Use DBS to back up an Oracle instance

Last Updated: Jul 28, 2020

Database Backup (DBS) supports backup and recovery for Oracle instances and provides the features of single-table restoration, remote backup, and long-term archiving.Click here to activate DBS.

Features

Feature Description
Remote backup DBS supports backing up an Oracle instance to a database on the cloud of another region, and restoring the backup files to both the source database and the destination database on the cloud.
Long-term archiving DBS supports retaining backup files for up to five years, after which the backup set will be automatically transferred to Archive Storage.
Backup speed limit DBS allows you to limit the backup speed to significantly reduce the negative impact of backup operations on the performance of the database.
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 it on a local disk first.
Encryption DBS uses HTTPS encryption when transferring data, and AES-256 encryption when storing data.

Create a backup schedule

  1. Log on to the DBS console.
  2. Click Create Schedule in the upper-right corner to go to the DBS purchase page.
  3. Set the parameters as described in the following table and click Buy Now.

    Section Parameter Description
    Basic DBS Region The region where the DBS instance to be purchased 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 to be backed up. In this example, select Oracle.
    Specification The specification of the DBS instance to be purchased. We recommend that you select xlarge for better backup experience. For more information, see How to select DBS instances.
    Backup Method The mode for backing up data. Select Logical Backup or Physical Backup as required.
    Storage Size The storage size of the DBS instance to be purchased. You do not need to specify the storage size when you purchase a DBS instance. The instance is charged in the pay-as-you-go mode. You can also purchase a storage package. A favorable discount is available if you purchase a large storage package.
    Purchase Plan Quantity The number of DBS instances to be purchased. 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 accept the DBS Agreement of Service, 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.
    Backup schedules-Oracle-

  4. In the Configure Backup Source and Destination step, 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 specify 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 to be backed up. Valid values:
    • User-Created Database with Public IP Address
    • 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 to be backed up. In this example, this parameter is set to Oracle.
    Instance Region The region where the database to be backed 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 to be backed up.
    This parameter is available only when you set Database Location to User-Created Database with Public IP Address , 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 to be backed 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 to be backed up resides.
    This parameter is available only when you set Database Location to ECS-Hosted Database.
    POLARDB Instance ID The ID of the ApsaraDB for POLARDB instance to be backed up.
    This parameter is available only when you set Database Location to POLARDB Instance.
    Peer VPC The virtual private cloud (VPC) where the database to be backed 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 to be backed up.
    Database Account The username of the account used to connect to the database to be backed up.
    Password The password of the account used to connect to the database to be backed up.
    After you enter the database account and password, click Test Connection next to Password to check whether the information about the database to be backed 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 to be backed up based on the check results.
    Backup Destination Information Backup Storage Type The type of the storage used to back up data. Valid values:
    • DBS built-in storage
    • OSS for user
    OSS Bucket name The name of your OSS bucket.
    This parameter is available only when you set Backup Storage Type to OSS for user.
    Storage Encryption The method used to encrypt the stored data. Valid values:
    • Non-encrypted
    • Encrypted
    • KMS Encrypted

    configure backup schedule Oracle

  5. In the lower-right corner of the page, click Next.

  6. In the Edit Backup Objects step, find the database or table to be backed up in the Available section, click the rightwards arrow to add the selected database or table to the Selected section, and then click Next.

    If you back up an entire database, permission data and stored procedures will also be 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 completed, click Precheck in the lower-right corner of the page.
  10. If the Precheck Passed message appears, click Start Task.
    Precheck
  11. 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 that appears, find the target backup schedule and click Manage in the Actions column.
  4. On the Configure Task page, view 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.
    Full data oracle

Restore a PostgreSQL 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 that appears, click Restore Database in the upper-right corner.
  5. In the Set Time Restored To step in 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 specify 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 displays the available time range automatically.
    Restore To The time point that you want to restore the source database to. The value must be within the time range specified by Time Range Available to Restore.
    Configure Destination Database Database Location The location of the database to be restored. Valid values:
    • User-Created Database with Public IP Address
    • 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 TypeThe type of the database to be restored. In this example, this parameter is set to Oracle.
    Instance RegionThe region where the database to be restored 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).
    AddressThe public endpoint used to connect to the database to be restored.
    This parameter is available only when you set Database Location to User-Created Database with Public IP Address , Express Connect DB/VPN Gateway/Intelligent Gateway, or No public network IP: Port’s self-built database (accessed through the database gateway).
    Port NumberThe port used to connect to the database to be restored.
    If you set Database Location to POLARDB Instance, this parameter is unavailable.
    ECS Instance IDThe ID of the ECS instance where the database to be restored resides.
    This parameter is available only when you set Database Location to ECS-Hosted Database.
    POLARDB Instance IDThe ID of the ApsaraDB for POLARDB instance to be restored.
    This parameter is available only when you set Database Location to POLARDB Instance.
    Peer VPCThe virtual private cloud (VPC) where the database to be restored resides.
    This parameter is available only when you set Database Location to Express Connect DB/VPN Gateway/Intelligent Gateway.
    Database gateway instance IDThe 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).
    SIDThe SID of the database that is deployed on the server where the backup gateway is installed.
    Database AccountThe username of the account used to connect to the database to be restored.
    PasswordThe password of the account used to connect to the database to be restored.
    After you enter the database account and password, click Test Connection next to Password to check whether the information about the database to be restored 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 to be restored based on the check results.

    Create Restore Task Oracle

  6. In the Configure Objects to Restore step in the Create Restore Task wizard, set the parameters as described in the following table and click Precheck.

    Parameter Description
    Conflict Handling The method used 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 object as follows: For example, if the table named job_info already exists, DBS automatically renames the new table as job_info_dbs_<Restore task ID>_</Timestamp> by default.
    Objects to Restore Select the database or table 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.