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 on Oracle Base Database Service

Introduction

We are pleased to announce the general availability (GA) of the ability to backup and restore from a standby database (in Oracle Data Guard association) for Oracle Base Database Service. This feature is now available for standby databases with Oracle Database Autonomous Recovery Service and OCI Object Storage as backup destinations.

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 vice versa.

Objectives

• Enable automatic backups on the standby database with Oracle Database Autonomous Recovery Service on Oracle Base Database Service.

• Create a database in 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 Base Database Service database system (DB 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 DB system 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 Base Database Service.

   

2. Click the name of the DB system 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.
   • Compartment: Select a compartment that you want to contain the Oracle Base Database Service DB system.
   • Name your DB system: Enter a name for the target DB system.
   • Region: Select a region where the new database will reside.
   • Availability Domain: Select an availability domain within the target region.
   • Configure Shape and Storage: Enter additional details for the DB system.
   • Database Name: Enter a name for the target database.
   • Administrator Username and Password: Enter database credentials.

   

   

   

4. Click Create DB system.

   

   The new database is created in the selected region and availability domain.

   

Related Links

• What’s New in Oracle Oracle Base Database Service

• Oracle Base Database Service How To’s Video Playlist

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 on Oracle Base Database Service

F96528-01

April 2024

Copyright ©2024,

Oracle and/or its affiliates.