This topic describes how to create, test, and delete a database archive in the Advanced Database & Application Migration (ADAM) console.
Prerequisites
The destination database is created.
A database account is created.
The IP addresses of ADAM are added to the whitelist of the destination database. For more information, see Configure the whitelist.
Supported databases
Source database: Oracle
Destination database: PolarDB for PostgreSQL(Compatible with Oracle)
Create a database archive
This section provides an example on how to create a database archive. In this example, a PolarDB for PostgreSQL(Compatible with Oracle) cluster is used.
For information about how to create a cluster, see the "Step 1: Create a PolarDB for Oracle cluster" section in Getting Started.
For information about how to create a database account, see the "Step 3: Create a database account" section in the Getting Started.
For information about how to configure a whitelist for a database, see the "Step 2: Configure the cluster whitelist" section in Getting Started.
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.
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 UK (London) or Japan (Tokyo). 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.
Other supported operations
Test the connectivity of a database archive: On the Database Management page, find the database archive that you want to test and click Test in the Actions column. After the test is complete, the test result is displayed.
Delete a database archive: On the Database Management page, find the database archive that you want to delete and click Delete in the Actions column. In the Delete message, click OK.
ImportantThe delete operation cannot be rolled back. Proceed with caution.