Oracle Cloud Infrastructure Documentation

Copying an OCI Database with PostgreSQL Backup to Another Region

Copy an existing OCI Database with PostgreSQL database system backup to another region.

We recommend using a management policy that automatically creates and copies backups. If you manually copy a backup, you can't guarantee the order and size of backups, which might increase costs. For more information, see Backup Size and Copy Order.

Cross-region backup copy isn't supported for backups associated with Database Systems that use regional data placement. You can create cross-region backup copies for backups that are specific to an Availability domain.

    1. On the Backups list page, select the backup that you want to work with. If you need help finding the list page or the backup, see Listing Backups.
      The backup's details page opens.
    2. From the Actions menu, select Create backup copy.
      The Create backup copy panel opens.
    3. Enter the following information:
      • Compartment: Select a compartment for the backup copy.
      • Regions: Select a region for the backup copy.
      • Backup retention period (days): Enter a value, in days, that the backup copy will be retained before it's deleted by the system.
    4. Select Submit.

  • Use the oci psql backup backup-copy command and required parameters to create a backup:

    oci psql backup backup-copy --backup-id <backup_ocid> --compartment-id <compartment_ocid> --regions <regions_JSON> [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 CopyBackup operation to copy a backup to another region.