PolarDB for Oracle provides two methods for you to restore historical data to a new cluster: restore data to a specific point in time and restore data from a backup set (snapshot). This topic describes how to restore data from a backup set (snapshot).

Precautions

Only the data and account information of the original cluster can be restored to a new cluster. The parameters of the original cluster cannot be restored to the new cluster.

Procedure

  1. Log on to the PolarDB console.
  2. In the upper-left corner of the console, select the region where the cluster that you want to manage is deployed.
  3. Find the cluster you want to manage and click the cluster ID.
  4. In the left-side navigation pane, choose Settings and Management > Backup and Restore.
  5. Find the backup set (snapshot) and click Restore to New Cluster.
  6. On the Clone Instance page, select a billing method for the new cluster.
    • Subscription: When you create a cluster, you must pay for compute nodes. You are charged for the use of storage resources and the costs are deducted from your account balance on an hourly basis.
    • Pay-As-You-Go: If you select the pay-as-you-go billing method, you pay for the resources after you use them. You are charged for the compute nodes and the used storage space on an hourly basis. The fee is deducted from your account balance on an hourly basis. We recommend that you select the Pay-As-You-Go billing method for the short-term use. You can reduce costs by releasing the cluster based on your business requirements.
  7. Configure the parameters that are listed in the following table.
    Parameter Description
    Action Mode Select Restore from Backup Set.
    Backup Set The backup set from which you want to restore data.
    Note The Start Time of each backup set is displayed. You can determine whether to select the backup set based on this backup time.
    Region The region where the cluster resides.
    Note The default region is the same as the region of the original cluster. Use the default region.
    Primary Zone Select the primary zone where the cluster resides.
    Note In regions that have two or more zones, PolarDB automatically replicates the data to the secondary zone for disaster recovery.
    Network Type The default value is VPC.
    VPC Select a VPC and a vSwitch for the new cluster. We recommend that you select the same VPC and vSwitch that are connected to the original cluster.
    vSwitch
    Compatibility

    The default value is Compatible with Oracle Syntax.

    Edition This parameter is automatically set to the edition value of the original cluster. You do not need to change this value.
    Resource Type This parameter is automatically set to the Resource Type value of the original cluster. You do not need to change this value.
    Node Specification Select a node specification. The maximum storage capacity and the performance of clusters vary based on the node specifications. For more information, see Node specifications.
    Note We recommend that you select a node specification that is higher than the node specification of the original cluster. This ensures that the new cluster runs as expected.
    Nodes The default value is 2.
    Note By default, a new cluster has one primary node and one read-only node. After the cluster is created, you can add nodes to the cluster. A cluster can contain one primary node and a maximum of 15 read-only nodes. For more information about how to add nodes, see Add or remove a read-only node.
    Storage Cost You do not need to select the storage capacity when you purchase PolarDB clusters. You are charged for the used storage space on an hourly basis. You can also purchase a storage package to offset storage fees. For more information about how to purchase a storage package, see Purchase a storage plan.
    Cluster Name The name of the new PolarDB cluster must meet the following requirements:
    • The name must be 2 to 128 characters in length, and can contain letters, digits, periods (.), underscores (_) and hyphens (-). The name must start with a letter.
    • The name must start with a letter.
    • The name can contain digits, periods (.), underscores (_), and hyphens (-).

    If you leave this field empty, the system automatically generates a cluster name. You can change the cluster name after the cluster is created.

    Subscription Duration Select a Subscription Duration value for the PolarDB cluster.
    Quantity Set the number of PolarDB clusters you want to purchase.
  8. Read and select the terms of service, and then complete the payment based on the selected billing method.
    • Pay-as-you-go

      Click Buy Now.

    • Subscription
      1. Click Buy Now.
      2. On the Purchase page, confirm the order and the payment method, and click Purchase.
    Note After you complete the payment, it requires 10 to 15 minutes to create the cluster. Then, you can view the new cluster on the Clusters page.

Related API operations

Operation Description
CreateDBCluster Restores data of a PolarDB cluster.
Note You must set CreationOption to CloneFromPolarDB.