Exadata Database Service on Dedicated Infrastructure: Backup and Restore from a Standby Database in a Data Guard Environment

  • Services: Database
  • Release Date: Aug. 24, 2023

With this enhancement, you can:

  • Enables customers to offload backups to the standby database in a Data Guard environment thereby freeing up resources in the production database environment.
  • Allows customers to schedule automatic backups on the standby database in a Data Guard environment and configure retention period and backup schedules.
  • Enables customers to create a database in another Availability Domain (AD) within the same region from a backup of the standby database.
  • Allows customers to restore and recover a standby database using a backup of the standby database.
  • Provides the flexibility to take backups only on the primary database, only on the standby database, or both.
  • Allows customers to create a manual full backup of a standby database.
  • Enables customers to enable or disable backup on the standby database only if the backup destination of the primary database is Object Storage.

Note

  • You cannot change the backup destination of the primary database to Autonomous Recovery Service if the backup destination of the primary and standby databases is Object Storage.

    To change the backup destination of the primary database to Autonomous Recovery Service, first, disable backup on the standby database.

  • You cannot use standby-side backups to perform restore/recover operations on the primary database.
  • Switchover scenarios:
    • If automatic backups was configured on the primary with backup destination of Object Storage, upon switchover, the backups will continue on the new standby database
    • If automatic backups was configured on the primary with backup destination of Autonomous Recovery Service, upon switchover, backup and restore will be disabled on the new standby database
    • If automatic backups was configured on the standby with backup destination of Object Storage, upon switchover, the backups will continue on the new primary database
  • Failover scenarios:
    • If automatic backups was configured on the primary with backup destination of Object Storage or Autonomous Recovery Service, upon failover the backups be disabled on the new Disabled Standby database
    • If automatic backups was configured on the standby with backup destination of Object Storage, upon failover the backups will continue on the new primary database

For more information, see: