How to create a database archive in ADAM-Data Transmission Service(DTS)-阿里云帮助中心

This topic explains how to create, test, and delete database archives in Advanced Database & Application Migration (ADAM).

Prerequisites

A destination database instance must exist.
A database account must exist.
You have added the IP addresses of ADAM to the whitelist for your destination database. For more information, see Configure a whitelist.

Supported database types

Source database: Oracle
Destination database: PolarDB for PostgreSQL (Oracle Compatible)

Create a database archive

This section provides an example of creating a database archive that uses PolarDB for PostgreSQL (Oracle Compatible) as the destination database.

Note

To create a database cluster, see Create a cluster.
To create a database account, see Create a database account.
To configure a cluster whitelist, see Configure a cluster whitelist.

Log on to the ADAM console.
In the left-side navigation pane, click Database Management.
On the page that appears, click Create Database.

In the Create Database Record panel, configure the following parameters.

Section	Parameter	Required	Description
N/A	Archive Name	Yes	The name of the database. We recommend that you specify a descriptive name that makes it easy to identify the database.
N/A	Database Type	Yes	Select PolarDB-O Engine from the drop-down list.
Destination Database	POLARDB-OInstance Region	Yes	The region in which your PolarDB for Oracle cluster resides.
	Instance Type	Yes	This parameter is displayed only if you set the POLARDB-OInstance Region parameter to a specific value such as China (Qingdao) or China (Hohhot). Set the Instance Type parameter to Database with Public IP Address.
	POLARDB-OConnected VPC	Yes	The virtual private cloud (VPC) in which your PolarDB for Oracle cluster resides. You can log on to the PolarDB console and view the VPC information on the details page of the cluster.
	POLARDB-OInstances	Yes	Select your PolarDB for Oracle cluster from the drop-down list. After you configure the POLARDB-OConnected VPC parameter, the system searches for the clusters that reside in the VPC and displays the clusters in the drop-down list.
	POLARDB-OHost IP Address	Yes	You do not need to specify this parameter. After you select a PolarDB for Oracle cluster, the IP address is automatically obtained.
	Database Name	Yes	The name of the database that you want to add to ADAM.
	Encoding Method	No	Select the encoding method that corresponds to the character set of the database.
	Port Number	Yes	You do not need to specify this parameter. After you select a PolarDB for Oracle cluster, the port number is automatically obtained.
	Username	Yes	The username of the database account.
	Security Token	Yes	The password of the database account.

Click Test Connectivity.
If the test is successful, click Create.

More operations

To test a database archive's connection, navigate to the Database Management page. Find the desired archive and click Test in the Operation column. The result appears on the page after the test completes.
To delete a database archive, navigate to the Database Management page. Find the archive you want to delete and click Delete in the Operation column. In the Delete dialog box, click Confirm.

Important
This action cannot be undone. Proceed with caution.