Oracle Cloud Infrastructure Documentation

Restore Exadata Database

Container Database (CDB) Point-in-Time Restore

Learn how to perform point-in-time restore on Container Database in the OCI console.

  1. From the OCI console, select Exadata VM Clusters that you are using.
  2. Select Exadata Database (CDB), and select the database that you are using.
  3. Select the More actions button, and then select the Restore.
  4. From the Restore page, select Restore to a timestamp as your Restore type.
  5. Specify your Restore date and Restore timestamp.
  6. Select the Restore button.
  7. Return to the Exadata Database (CDB) to view the State of your restore process.This screenshot shows the Container Database Point-in-Time Restore

Pluggable Database (PDB) Point-in-Time Restore

Learn how to perform point-in-time restore on Pluggable Database in the OCI console.

  1. From the OCI console, select Exadata VM Clusters that you are using.
  2. Select Exadata Database (PDB), and select the database that you are using.
  3. Select the More actions button, and then select the Restore.
  4. From the Restore page, select Restore to a timestamp as your Restore type.
  5. Specify your date and time.
  6. Select the Restore button.
  7. Return to the Exadata Database (PDB) to view the State of your restore process.This screenshot shows the Pluggable Database Point-in-Time Restore

Restore from Automatic or Standalone Backup

Learn how to restore a database from automatic or standalone backup in the OCI console.

  1. From the OCI console, select Exadata VM Clusters that you are using.
  2. Select the Databases tab, and select Container Database (CDB) that you are using.
  3. Select the Backups tab.
  4. From the backup list, select your backup that you are using, and then click the three-dot navigation menu.
  5. Select the Create database.
  6. From the Create Database from Backup page, complete the following substeps:
    1. Choose the All PDBs option from PDB section.
    2. Select your preferred Region from the list. Select the region where you want to create the backup.
    3. The Availability domain is selected as default.
    4. Select your Compartment and VM Cluster from the dropdown lists.
    5. Navigate to Database Home section, and then choose the Select an existing Database Home option. From the Create Database Home dropdown list, select your Database Home.
    6. Specify a Database name that helps you easily identify the resource.
    7. Specify a Database unique name that helps you easily identify the resource.
    8. Enter your Password, Confirm password and TDE's wallet or RMAN password.
    9. Select the Create button.
  7. Return to the Exadata VM Clusters to view the State of your restore process.This screenshot shows the restore database from Automatic or Standalone Backup

Cross-Region Restore

Cross-region restore for Exadata Databases enables you to leverage Amazon S3–based automated backups to perform database restores across regions. The cross-region restore capability may accelerate your disaster recovery setup by allowing you to create a standby database in the target region.

These are the steps to perform a cross-region restore on an Exadata Database, where the AWS N. Virginia region (mapped to the OCI Ashburn region) will be used as the source region and the AWS Oregon region (mapped to the OCI Boardman region) will be used as the target region.

  • Prerequisites:
    1. Exadata Database in the source region is configured with automatic backups to Amazon S3
    2. Exadata VM Cluster in the target region is configured to use an ODB network with Restore region enabled and target region is selected from the dropdown list. To learn more about how to enable the restore region for your ODB network in the target region, follow the Create ODB Network or Modify ODB Network steps.
      Note

      From your ODB Network Service integrations tab, take a note of the Ipv4 CIDRs information which is required in the 1e step.
    Complete the following steps to configure IP route.
    1. Connect to Exadata VM Cluster and Add an ODB Network IP Route
      Note

      You must use the following steps for each of your target VMs in your Exadata VM Cluster.
      1. Connect to your Exadata VM Cluster using SSH. For more information, see Connect Exadata VM Cluster.
      2. Update dbaascli:
        sudo dbaascli admin updateStack
      3. Update agent:
        sudo dbaascli admin updateAgent --imageTag dbcs-agent-update-25.4.1.0.0_251107.1239.x86_64
      4. Check for IP route:
        sudo ip route
      5. Add IP route:
        sudo ip route add X.X.X.X via 10.2.1.1 dev bondeth1
        Replace X.X.X.X with your ODB Network Ipv4 CIDRs value.
    2. Subsequent steps are performed through the OCI Console.
    1. From the OCI console, select Oracle AI Database, and then select Oracle Exadata Database Service on Dedicated Infrastructure.
    2. From the left menu, select Exadata VM Clusters and then select your source Exadata VM ClusterThis screenshot shows the list of Exadata VM Clusters.
    3. Select the Databases tab, and then select the database which you want to restore in the target region.This screenshot shows the list of databases.
    4. Select the Backups tab, and then select the (...) icon. Select the Create database option which takes you to the Create Database from Backup page. Complete the following substeps to create a database from a backup:
      1. From the PDB section, choose the All PDBs option.
      2. From the Region dropdown list, select your target region where your backup will be restored.
        Note

        The OCI region US West (Boardman) is mapped to the AWS region Oregon. The target Exadata VM Cluster is physically located in Oregon.
      3. From the Availability domain section, choose the availability domain (mapped to AWS availability zone) where the target Exadata VM Cluster is created.
      4. From the Select a service dropdown list, select the Exadata Database Service on Dedicated Infrastructure option.This screenshot shows how to create a database from backup.
      5. From the Compartment dropdown list, select the compartment in which your Exadata Infrastructure resides.
      6. From the Exadata infrastructure dropdown list, select your target Exadata Infrastructure.
      7. Under the VM Cluster section, select your Compartment and VM Cluster of the target region.
      8. From the Database Home section, choose either the Select an existing Database Home or Create a new Database Home options based on your requirements.
        1. If you choose the Select an existing Database Home option, select a database home from the dropdown list.This screenshot shows how to create a database from backup.
        2. If you select the Create a new Database Home option, enter a name in the Database Home display name field. Database Home display name must be 1 to 255 characters, of letters, numbers, underscores (_) and hyphens (-). Database Home display name name must start with a letter or underscore (_) and cannot contain two successive hyphens(-).
      9. Enter a descriptive name in the Database name field.
      10. Enter a unique name in the Database unique name field. This value must be unique within the VM cluster. The name must be up to 30 characters. If you do not specify one, the system automatically generates a unique database name value.
      11. Under the Administrator username section, enter your Password. Password must be 9 to 30 characters and contain at least 2 uppercase, 2 lowercase, 2 special, and 2 numeric characters. The special characters must be _, #, or -.
      12. Enter your password in the Confirm Password field to confirm it. Confirmation must match password you entered in the previous step.
      13. Specify your TDE wallet password or RMAN password.This screenshot shows how to create a database from backup.
      14. Under the Advanced options section, Management and Tags are two optional sections.
      15. Once you review your information, select the Create button to initiate the create database from backup process.
      This screenshot shows how to create a database from backup.
    5. Navigate to Work requests tab to view the State of your database created using cross-region backup.