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, Teradata, and Db2 for LUW
- Destination database: PolarDB for MySQL, PolarDB for PostgreSQL, PolarDB for Oracle, PolarDB-X, ApsaraDB RDS for MySQL, ApsaraDB RDS for PostgreSQL, AnalyticDB for PostgreSQL
Create a database archive
This section provides an example on how to create a database archive. In this example, a PolarDB for Oracle cluster is used.
Note
- 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.
- Click Create Database.
- In the Create Database Record panel, configure the following parameters.
Section Parameter Required Description N/A Archive Name Yes Enter a name for the database. We recommend that you specify a descriptive name that is easy to identify. Database Type Yes Select PolarDB-O Engine from the drop-down list. Destination Database POLARDB-OInstance Region Yes Select the region in which your PolarDB for Oracle cluster resides. POLARDB-OConnected VPC Yes Select the 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 configure this parameter. After you select a PolarDB for Oracle cluster, the IP address is automatically obtained. Database Name Yes Enter 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 configure this parameter. After you select a PolarDB for Oracle cluster, the port number is automatically obtained. Username Yes Enter the username of the database account. Security Token Yes Enter 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. Important The delete operation cannot be rolled back. Proceed with caution.