Note:

• This tutorial requires access to Oracle Cloud. To sign up for a free account, see Get started with Oracle Cloud Infrastructure Free Tier.
• It uses example values for Oracle Cloud Infrastructure credentials, tenancy, and compartments. When completing your lab, substitute these values with ones specific to your cloud environment.

Backup and Restore from a Standby Database for Oracle Exadata Database Service on Cloud@Customer

Introduction

Users can now backup and restore from a standby database configured for Oracle Exadata Database Service on Cloud@Customer. Until now, customers could configure backups only on a primary database with Zero Data Loss Recovery Appliance (ZDLRA), Oracle Cloud Infrastructure (OCI) Object Storage, or Network File System (NFS) as the backup destination using cloud automation. However, customers will now be able to configure backups on a standby database in addition to the primary database for these backup destination types via OCI Console/API/SDK and Terraform.

Objectives

• Enable automatic backups on the standby database.

• Restore and recover a standby database using a standby database backup.

Task 1: Enable Automatic Backups on a Standby Database

1. Log in to the OCI Console, navigate to Oracle Database and click Oracle Exadata Database Service on Cloud@Customer.

2. In the list of Exadata VM Clusters, click the name of the VM Cluster containing the standby database for which you want to configure automatic backups.

3. In the Database Details page of the standby database, click Enable automatic backups to configure backups.

   

4. In the Configure automatic backups window, select Enable automatic backups. Specify the backup destination type and retention period.

   Select to configure Recovery Appliance as Backup destination type. Select the Zero Data Loss Recovery Appliance (ZDLRA_RA2) from the available Backup Destinations.

   

   The Database Details page displays the automatic backup status and details in the Backup section.

   

   

Task 2: Restore and Recover a Standby Database using a Standby Database Backup

1. In the Database Details page of the standby database, click Restore Database.

   

2. Select the required restore option and click Restore Database.

   • Restore to latest.
   • Restore to a timestamp.
   • Restore to SCN.

   

   The Database Details page is now displayed. While the database restore process is running, the lifecycle state of the database shows UPDATING.

   

   

   When the database restore process completes, the state of the database changes to AVAILABLE.

   

Related Links

• What’s New in Oracle Exadata Database Service on Cloud@Customer

• Exadata Database Service on Cloud@Customer How To’s Video Playlist

• Oracle LiveLabs Workshop: Get Started with Oracle Exadata Database Service on Cloud@Customer

Acknowledgments

• Authors - Leo Alvarado, Dileep Thiagarajan, Tammy Bednar (Product Management)

More Learning Resources

Explore other labs on docs.oracle.com/learn or access more free learning content on the Oracle Learning YouTube channel. Additionally, visit education.oracle.com/learning-explorer to become an Oracle Learning Explorer.

For product documentation, visit Oracle Help Center.

---

Title and Copyright Information

Backup and Restore from a Standby Database for Oracle Exadata Database Service on Cloud@Customer

G34946-01

Copyright ©2025, Oracle and/or its affiliates.