Restore an Autonomous Database

This page describes how to restore an Autonomous Database from a backup.

You can restore an Autonomous Database from a backup to a specific point in time. When you restore a database, the database retains all the data and schema of the database up to the time of the backup, as well as the database options. To view backups for an existing Autonomous Database, see View backups for an Autonomous Database.

To learn more about how backup and recovery works on an Autonomous Database, see About Backup and Recovery on Autonomous Database.

Restore an Autonomous Database

You can restore your Autonomous Database from a backup using gcloud CLI using the following command:

gcloud oracle-database autonomous-database restore DATABASE_NAME
--location=REGION_ID
--project=PROJECT_NAME
--restore-time=RESTORE_TIME

Replace the following:

  • DATABASE_NAME: name of the database you want to restore.
  • REGION_ID: the region of your database.
  • PROJECT_NAME: the name of your Google Cloud project.
  • RESTORE_TIME: the backup time you want to restore your database to. You must use the endTime of the backup as the restore time. To see a list of available backups for your database, see View backups for an Autonomous Database.