Restoring from an OCI Database with PostgreSQL Point-in-Time Source

Restore an OCI Database with PostgreSQL database system from a point-in-time source.

Warning

You might lose data if you restore a database system. We recommend that you create a manual backup of the database system before restoring. For more information, see Creating an OCI Database with PostgreSQL Database System Backup

1. On the Database systems list page, find the database system that you want to work with. If you need help finding the list page or the database system, see Listing OCI Database with PostgreSQL Database Systems.
  The database system's details page opens.
2. From the Actions menu, select Restore to point in time.
  The Restore to point in time panel opens.
3. Enter the following information:
  
  Point in time to restore to: Select the point in time option to use for the database system you're creating from the list.
  
  Latest: The most recent point-in-time. The Restore time for the latest point-in-time is displayed.
  
  Custom: Specify a particular date and time for the point-in-time source:
  
  Date: Enter or use the calendar tool to specify the date of the point-in-time source.
  
  Time: Enter the time of the point-in-time source for the specify date.
  
  Possible recovery windows: Displays the time range available for you to select from.
4. Select Restore to point in time.
Use the oci psql db-system restore command and required parameters to restore a database from a backup:
oci psql --db-system-id <db_system_OCID> --backup-id <backup_ocid> [OPTIONS]
To get your backup's OCID, see Listing Backups.

For a complete list of parameters and values for CLI commands, see the CLI Command Reference.
Run the RestoreDbSystem operation to restore a database from a backup.