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 with Oracle Database Autonomous Recovery Service for Oracle Exadata Database Service on Dedicated Infrastructure

Introduction

We are pleased to announce the General Availability (GA) of the ability to backup and restore from a standby database configured with Oracle Database Autonomous Recovery Service for Oracle Exadata Database Service on Dedicated Infrastructure (ExaDB-D). This feature is available for backups using Oracle Cloud Infrastructure (OCI) Object Storage and Oracle Database Autonomous Recovery Service.

Note: This feature is intended to allow users to schedule automatic backups, configure retention periods and backup schedules, and offload backups to the standby database in Oracle Data Guard environment. It also allows users to restore and recover a primary database using a backup of the standby database and conversely.

Objectives

• Enable automatic backups on the standby database (in Oracle Data Guard association) with Oracle Database Autonomous Recovery Service for Oracle Exadata Database Service on Dedicated Infrastructure.

• Create a database in another availability domain (AD) within the same or different region from a backup of the standby database.

• Restore and recover a primary database using a backup of the standby database.

Prerequisites

• An Oracle Data Guard association created for the primary and the standby database on an Oracle Exadata Database Service on Dedicated Infrastructure system.

Task 1: Enable Automatic Backups with Oracle Database Autonomous Recovery Service on a Standby Database

When you enable Oracle Data Guard, a separate Data Guard association is created for the primary and the standby databases. Also, a new peer VM cluster must be created for the standby database. Once the Oracle Data Guard is set up, navigate to the standby database to enable automatic backups.

1. Log in to the OCI Console, click Oracle Database and Oracle Exadata Database Service on Dedicated Infrastructure.

   

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

3. Under Resources, click Databases and the name of the primary database.

   

4. In the Primary Database Details page, click Data Guard associations and the name of the standby database for which you want to configure automatic backups.

   

5. In the Standby Database Details page, click Enable automatic backups to configure backups.

   

6. In the Configure database backups window, select Enable automatic backups and enter Autonomous Recovery Service (Recommended) as the Backup destination. Specify and configure the backup retention period and backup schedule. Click Save changes.

   

7. The Database Details page displays the Automatic Backup status and details in the Backup section.

   

Task 2: Create a Database from a Standby Database Backup

1. In the Standby Database Details page, click Backups.

2. In the Backups section, select the backup to restore. Click the Actions menu for the backup and then click Create database.

   

3. In the Create database from backup window, enter the following information.

   • Add PDB: Select PDBs to restore.
   • Region: Select a region where the new database will reside.
   • Availability Domain: Select an availability domain within the target region.
   • Select Exadata Infrastructure: Select Exadata Infrastructure where the new database will reside.
   • Select VM Cluster: Select Exadata VM cluster where the new database will reside.
   • Configure the Database Home: Select Select an existing Database Home or Create a new Database Home.
   • Enter additional details for the new database.
   • Database Name: Enter a name for the database.
   • Administrator Username and Password: Enter database credentials.

   

   

4. Click Create Database. The new database is created in the selected region and availability domain.

   

   

Related Links

• What’s New in Oracle Exadata Database Service on Dedicated Infrastructure

• Exadata Database Service on Dedicated Infrastructure How To’s Video Playlist

• Oracle LiveLabs Workshop: Get Started with Oracle Exadata Database Service on Dedicated Infrastructure

Acknowledgments

• Authors - Dileep Thiagarajan, Tammy Bednar, Leo Alvarado (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 with Oracle Database Autonomous Recovery Service for Oracle Exadata Database Service on Dedicated Infrastructure

G11032-01

September 2024

Copyright ©2024,

Oracle and/or its affiliates.