Oracle Cloud Infrastructure Documentation

Restore Autonomous Database

Learn how to restore an Autonomous Database using the Automatic Backup, Manual Backup (Standalone Backup), Long-Term Backup and Point-in-time options.

  1. Restore from Automatic Backup
  2. Restore from Manual Backup (Standalone Backup)
  3. Restore from Long-Term Backup
  4. Point-in-Time Restore

Restore from Automatic Backup

These are steps to restore your Autonomous Database from an automatic backup.

  1. From the OCI console, you can navigate to Autonomous Database, and then select Backups tab.
  2. From the Backups tab, select the three-dot navigation menu , and then select the Restore button.
  3. A warning message will appear to confirm the results of the attempted restore. This action will restore the current database to the selected timestamps. After confirming, select the Restore button.
  4. Return to the Backups tab within your Autonomous Database to view the State of your restore process. Once the restoring process is complete, the State will change from Active to Restore in Progress.This screenshot shows how to restore Autonomous Database from Automatic Backup

Restore from Manual Backup (Standalone Backup)

Learn how to restore and clone your Autonomous Database from manual backup in the OCI console.

These are the steps to restore and clone your Autonomous Database:
  1. From the OCI console, select Autonomous Database that you are using.
  2. Select the Backups tab. Do not select any backup from the list that has the following attributes:
    • Display name: Automatic Backup
    • Type:Longterm and initiated by user
  3. From the three-dot navigation menu, select either the Restore or Create clone option.
  4. From the Create Autonomous Database clone page, complete the following substeps:
    1. Select your Clone type as Full clone.
    2. Select your compartment that you want to create the clone in.
    3. Enter a Display name that helps you easily identify the resource.
    4. Specify a Database name.
    5. Select your preferred Region from the list. Select the region where you want to create the clone.
    6. Select your Compartment and Exadata infrastructure from the dropdown lists.
    7. Select your Compartment and Autonomous Exadata VM Cluster from the dropdown lists.
    8. Select your Compartment and Autonomous Container Database from the dropdown lists.
    9. Navigate to the Database configuration section, and then specify your ECPU count, Storage (GB).
    10. Navigate to Administrator credentials creation section, and then enter your Password and Confirm password
    11. Enter your Contact email for operational notifications and announcements. You can select the Add customer contact and fill required information.
    12. Review your information, and then select the Clone details.
  5. Return to the Autonomous Database to view the State of your clone or restore process. Once the process is complete, the State will change from Available to Restore in Progress.This screenshot shows how to clone an Autonomous Database from Manual Backup

Restore from Long-Term Backup

Learn how to restore and clone from a long-term backup in the OCI console.

These are the steps to restore and clone from a long-term backup :
  1. From the OCI console, select Autonomous Database that you are using.
  2. Select the Backups tab. Do not select any backup from the list that has the following attributes:
    • Display name: Automatic Backup
    • Type:Longterm and initiated by user
  3. From the three-dot navigation menu, select the Create clone option.
  4. From the Create Autonomous Database clone page, complete the following substeps:
    1. Select your Clone type as Full clone.
    2. Select your compartment that you want to create the clone in.
    3. Enter a Display name that helps you easily identify the resource.
    4. Specify a Database name.
    5. Select your preferred Region from the list. Select the region where you want to create the clone.
    6. Select your Compartment and Exadata infrastructure from the dropdown lists.
    7. Select your Compartment and Autonomous Exadata VM Cluster from the dropdown lists.
    8. Select your Compartment and Autonomous Container Database from the dropdown lists.
    9. Navigate to the Database configuration section, and then specify your ECPU count, Storage (GB).
    10. Navigate to Administrator credentials creation section, and then enter your Password and Confirm password
    11. Enter your Contact email for operational notifications and announcements. You can select the Add customer contact and fill required information.
    12. Review your information, and then select the Clone details.
  5. Return to the Autonomous Database to view the State of your clone process.This screenshot shows how to clone an Autonomous Database from Long-Term Backup

Point-in-Time Restore

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

  1. From the OCI console, select Autonomous Database that you are using.
  2. Select the More actions button, and then select the Restore.
  3. From the Restore page, specify a timestamp within the last 60 days to use for the point-in-time restore. Select the Enter timestamp option.
  4. Specify your date and time.
  5. Select the Restore button.
  6. Return to the Autonomous Database to view the State of your restore process.This screenshot shows how to restore Autonomous Database from Point-in-Time Restore