Data Management:Logical backup and restore for self-managed or cross-cloud Oracle

Features

Create a backup schedule

For detailed instructions, see Create a backup schedule.

Configure a backup schedule

1. Log on to the Data Management Service (DMS) 5.0 console.

2. In the top navigation bar, choose Security and disaster recovery (DBS) > Data Disaster Recovery (DBS) > Backup Plan.

   Note

   If you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner of the DMS console and choose All Features > Security and disaster recovery (DBS) > Data Disaster Recovery (DBS) > Backup Plan.

3. Find the target backup schedule and click Configure Backup Schedule in the Actions column.

4. On the Configure Backup Source and Destination page, configure the backup source and destination, and then click Next.

   Section	Parameter	Description
   N/A	Backup schedule name	The name of the backup schedule. DBS automatically generates a backup schedule name. We recommend that you enter a descriptive name that is easy to identify. Backup schedule names do not need to be unique.
   Backup Source Information	Backup method	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. In this example, Logical Backup is used.
   	Database location	The location of the database to back up. Valid options: User-Created Database with Public IP Address <IP Address:Port Number> ECS-Hosted Database Express Connect DB/VPN Gateway/Intelligent Gateway Self-managed database without a public IP address, accessed via Database Gateway (DG)
   	Database type	The default value is Oracle.
   	Connection address	The connection address of the source database instance. Note If your server has a firewall configured, click Set Whitelist to obtain the IP addresses of DBS. You must add all these IP addresses to your server's whitelist for DBS to access the database. This parameter is displayed only when No public network IP: Port's self-built database (accessed through the database gateway) is set to Self-managed database without a public IP address, accessed via Database Gateway (DG), Express Connect DB/VPN Gateway/Intelligent Gateway, or User-Created Database with Public IP Address <IP Address:Port Number>.
   	Instance region	The region in which the source database instance resides. This parameter is displayed only when ECS-Hosted Database is set to Self-managed database on an ECS instance or Self-managed database without a public IP address, accessed via Database Gateway (DG).
   		Note If your server has network security settings, such as a firewall, you need to click Set Whitelist to obtain the IP addresses of DBS and add the complete list of IP addresses to your server's whitelist. This ensures that DBS can access your server. This parameter is displayed only when you select Self-managed database without a public IP address, accessed via Database Gateway (DG), Express Connect DB/VPN Gateway/Intelligent Gateway, or User-Created Database with Public IP Address <IP Address:Port Number>.
   	Port	The port used to connect to the source database instance. The default value is 1521.
   	ECS instance ID	The ID of the ECS instance that hosts the database. This parameter is displayed only when ECS-Hosted Database is set to Self-managed database on an ECS instance.
   	Destination VPC	The destination Virtual Private Cloud (VPC). This parameter is displayed only when Express Connect DB/VPN Gateway/Intelligent Gateway is set to Self-managed database accessed via Express Connect, VPN Gateway, or Smart Access Gateway (SAG).
   	Database Gateway (DG) instance ID	The Database Gateway (DG) instance. This parameter is displayed only when Database Location is set to Self-managed database without a public IP address, accessed via Database Gateway (DG).
   	SID	The Oracle System Identifier (SID) of the database.
   	Oracle home	The absolute path of the Oracle Home directory. The path must be in a standard format for Windows or Linux.
   	Database account	The database account to use for the connection.
   	Password	The password of the account that is 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 about the database that you want to back up is valid. If the specified parameters are valid, the Test Passed message is displayed. If the Test Failed message is displayed, click Check next to Test Failed. Modify the information about the database that you want to back up based on the check results.
   	Cross-border data transfer compliance commitment	Read and select the compliance commitment checkbox.
   Backup destination	Backup storage type	The storage type for the backup destination. Valid options: DBS Built-in Storage (Recommended): You do not need to create a bucket. Data is automatically stored in the built-in storage of DBS. You are charged based on the amount of data stored. For more information about billing, see Storage fees. OSS For User: You must create a bucket in Object Storage Service (OSS) in advance. For more information, see Create buckets. Note This topic uses DBS Built-in Storage as an example. If you select User-owned OSS bucket, you must also specify the OSS Bucket Name. Only the OSS Standard storage class is supported. If you have a large amount of data to store, we recommend that you purchase a DBS storage plan (subscription) to reduce the costs of using the built-in DBS storage. Storage plans are more cost-effective than the pay-as-you-go billing method.
   	Storage method	The method used to store backup data. Valid options: Encrypted (Recommended): Uses the industry-standard AES-256 algorithm to encrypt data at rest. Object Storage Service (OSS) supports server-side encryption. When you upload an object, OSS encrypts the object before saving it. When you download the object, OSS automatically decrypts the data and returns it to you. For more information, see Server-side encryption. Non-encrypted: Encryption is disabled.

5. On the Edit Backup Objects page, move the databases or tables to back up from the Available box to the Selected box, and then click Next.

   Note

   • You can back up specific databases or tables. To select all existing databases, click Select All. The supported backup objects vary based on the database engine. For more information, see Supported database engines and features.

   • By default, newly created databases are not automatically added to the backup schedule. To back them up, you must modify the backup schedule and add them to the backup objects. For more information, see Modify backup objects.

6. On the Configure Backup Time page, configure the backup time and related settings, and then click Next.

   Parameter	Description
   Full backup frequency	The frequency of the backup schedule. Valid values: Periodic Backup and Single Backup. Note If you select Periodic Backup, you must configure the Full Data Backup Recurrence and Start At parameters.
   Backup period	The days of the week on which DBS runs the backup schedule. You can select one or more days of a week. Select at least one day of the week.
   Start time	The start time of the backup. We recommend that you set a point in time within off-peak hours. Example: 01:00. Note If a previous full data backup is not finished at the start time of the next backup, DBS skips the next backup.
   Incremental backup	Incremental backup is not supported for Oracle databases.
   Maximum parallel threads for full backup	The maximum number of concurrent threads available for a full backup. You can set this parameter to adjust the backup speed. For example, you can reduce the number of backup threads to minimize impacts on the database.
   Backup network throttling	The limit on the network bandwidth. Unit: MB/s. You can set the limit based on your business requirements. The default value 0 indicates that the network bandwidth is unlimited.

7. On the Edit Lifecycle page, specify the retention period for full backup data in the DBS built-in storage.

   Note

   For more information about the backup data lifecycle, see Manage the lifecycle of backup data.

8. After the preceding configurations are complete, click Precheck in the lower-right corner of the page.

9. In the Precheck dialog box, after all items pass the precheck, click Start Task.

   The precheck verifies source database connectivity, database permissions, and OSS settings.

   Note

   After the status of the backup schedule changes to Running, the configuration is complete. You can view the backup task on the Backup Schedules page. For more information, see View a backup schedule.

Restore data