Document Center

    Database Backup Service (DBS)

    • Release notes
    • Product Introduction
      • What is DBS?
      • Benefits
      • Scenarios
      • Database engines and features
      • Terms
        • Logical backup, physical backup, and snapshot-based backup
        • Data size
        • Built-in storage and OSS
    • Pricing
      • Billing overview
      • Backup fees
      • Storage fees
      • Network traffic fees
      • DBS sandbox fees
      • Overdue payments and expiration
    • Quick Start
      • Get started with DBS
      • Purchase a backup schedule
      • Configure a backup schedule
      • Restore a database
      • Use storage plans
      • Specification requirements
        • Select a backup method
        • Select backup schedule specifications
        • Performance tests on backup and restoration
    • User Guide
      • Backup Schedules
        • Supported data sources
        • Add a data source
        • Add multiple data sources at a time
        • Configure automatic access to a data source
        • Configure the account and password for a data source
        • Create a logical group and add a data source to the logical group
      • Storage Pool
        • What is a storage pool?
        • Add and remove storage pools
      • Backup policy management
        • Create a backup policy template
        • Create a backup policy that uses multiple levels of storage pools
        • Modify the backup policy of a backup schedule
      • Backup
        • Back up one or more databases
        • Backup and restore scenarios
        • Logical backup
          • Back up an ApsaraDB RDS for MySQL, PolarDB for MySQL, or self-managed MySQL database
          • Back up an Oracle instance
          • Use DBS to back up a MongoDB instance
          • Back up a MongoDB instance from a secondary database
          • Back up a PolarDB for MySQL instance
          • Back up a PolarDB-X instance
          • Back up a Redis instance
          • Back up an ApsaraDB RDS for PostgreSQL instance
        • Physical backup
          • Add a backup gateway
          • Add a backup gateway of the bastion host architecture
          • Back up a MySQL database
          • Log backup for MySQL
          • Source deduplication
          • Back up an Oracle database
          • Create a true incremental-forever backup for an Oracle database
          • Prepare for physical backup of an Oracle database
          • Back up a file
          • Back up an SQL Server database
        • Manually add the CIDR blocks of the DBS server to the security settings of self-managed databases
      • Manage a backup
        • View backup plans
        • Manage backup plans
        • Backup set query
          • Overview
          • Query data in a single backup set
          • Query data from multiple backup sets at a time
          • Query data in backup sets that are generated based on ApsaraDB for RDS databases
        • Back up to local storage
          • Overview
          • Manually download a backup set
          • Configure automatic download of backup sets
          • View download progress
        • Upgrade a backup schedule
        • Renew backup schedules
      • Copy data management
        • Overview
        • Limits of the DBS sandbox feature
        • Create a sandbox instance for the emergency disaster recovery of an ApsaraDB RDS for MySQL database
        • Create a sandbox instance for the emergency disaster recovery of a self-managed database
        • Access sandbox instances
          • Use DMS to access sandbox instances
          • Use ECS to access sandbox instances
        • Migrate data from a sandbox instance to an ApsaraDB RDS for MySQL instance
        • FAQ
      • Restoration
        • Restore MySQL databases
          • Restore a MySQL database from a logical backup
          • Restore a MySQL database from a physical backup
          • Create a MySQL sandbox instance
        • Restore Oracle databases
          • Restore an Oracle database from a physical backup
          • Restore an Oracle database from a logical backup
          • Restore Oracle standalone databases
          • Prepare for restoring a standalone Oracle database
        • Restore an SQL Server database to ApsaraDB for RDS
        • Restore a PolarDB for MySQL database
        • Restore MongoDB databases
        • Restore a Redis database
        • Restore an ApsaraDB RDS for PostgreSQL database
        • Restore a PolarDB-X database
        • Restore files
        • Restore data by database or table
        • Disaster recovery drills
    • Best Practices
      • Backup security
        • Authorize RAM roles for data backup or restoration across Alibaba Cloud accounts
        • Back up and restore data across Alibaba Cloud accounts
        • Back up and restore a database across accounts by using a public endpoint and IP address whitelist
        • Automatically archive backup sets to backup servers
        • Retain minimal backup sets
      • Disaster recovery and security
        • Use DBS to back up and restore ECS-hosted user-created databases to meet disaster recovery and security requirements
      • Remote backup
        • Overview
        • Use the multi-level storage pool feature to implement geo-redundancy
        • Implement geo-redundancy for a self-managed database
      • Back up to Alibaba Cloud
        • Back up a user-created database in an on-premises data center connected to Alibaba Cloud through Express Connect to OSS or DBS
        • Back up a user-created database in an on-premises data center connected to Alibaba Cloud through VPN Gateway or Smart Access Gateway to OSS or DBS
        • Back up a user-created Redis database and restore the backup data to an ApsaraDB for Redis database
        • Use Database Gateway to back up on-premises databases or private databases on a third-party cloud to Alibaba Cloud
      • Quick restoration
        • Create a sandbox instance for the emergency disaster recovery of a self-managed database
        • Restore data by database or table
      • Archive backup data to an on-premises NAS file system
    • FAQs
      • How do I activate DBS?
      • Account permissions
      • How do I guarantee consistency of restored data
      • How do I manage the lifecycle rules of backup sets?
      • What is backup data volume
      • How do I view the backup data volume
      • How do I change the backup source
      • Why is the running time of DBS backup SQL statements different from that displayed in the ApsaraDB for RDS console
      • Why errors occur during prechecks
      • How do I view the backup files that are stored in OSS?
      • What is the difference between DBS and the backup capability of ApsaraDB for RDS
      • How do I back up a read-only ApsaraDB for RDS instance
      • How do I restore a database backup to another database instance by using DBS
      • How to set the binlog_format variable to facilitate database recovery
      • Impact of backups on databases
      • How do I change the maximum backup speed?
      • FAQ about backup schedules for cross-region ApsaraDB RDS backups
    • API Reference
      • List of operations by function
      • Backup schedule
        • Create and start a backup plan
        • Create a backup plan
        • Configure the backup schedule
        • Renew a backup plan
        • Upgrade a backup plan
        • View a backup plan
        • Start a backup schedule
        • Pause a backup plan
        • Enable incremental backup
        • Disable incremental backup
        • Release a pay-as-you-go backup schedule
        • Modify the lifecycle of stored data
        • Modify a backup object
        • Modify the database backup source
        • Modify the name of a backup plan
        • Modify the backup time
        • View recovery time range details
        • View the billing information of a backup schedule
      • Back up node code
        • View incremental backup tasks
        • View the list of full backup jobs
      • Restore tasks
        • Create a restoration task
        • Start a recovery task
        • View the list of recovery tasks
      • Backup Gateway
        • View the backup gateway list
      • Others
        • InitializeDbsServiceLinkedRole
        • View the CIDR blocks of DBS nodes
        • View the node standardization error codes
        • View the pre-check progress list
        • Create a task to obtain the database list through the backup gateway
        • Obtain the database list through the backup Gateway
        • Supported regions
      • Download backup sets
        • view the download list of backup sets
        • Set the download rule for backup sets
        • Create a full backup set download task
        • Create an incremental backup set download task
    • SDK Reference
      • SDK overview
      • Create an AccessKey
      • Use DBS SDK for Java based on Maven dependencies
 
All Products
Search
  • Document Center
  • Database Backup Service (DBS)
  • User Guide
  • Manage a backup
  • Backup set query
  • Query data in backup sets that are generated based on ApsaraDB for RDS databases

This Product

  • This Product
  • All Products

    Query data in backup sets that are generated based on ApsaraDB for RDS databases

    Document Center

    Query data in backup sets that are generated based on ApsaraDB for RDS databases

    Last Updated: Nov 27, 2020

    Database Backup (DBS) allows you to query data in backup sets that are generated based on ApsaraDB for RDS databases. For more information, see Query data from the remote backup files of an ApsaraDB RDS for MySQL instance.

    How it works

    Previous: Query data from multiple backup sets at a time Next: Overview

    How helpful was this page?

    What might be the problems?

      More suggestions?

      Thank you! We've received your feedback.
      Free Trial Free Trial