Integrate Oracle Base Database Service and Oracle Database Zero Data Loss Autonomous Recovery Service

The following tasks describe the backup and recovery operations between Oracle Base Database Service and Recovery Service.

Configure Oracle Managed Backups for New Databases

These steps describe how to create a new database with Oracle managed backups.

1. Open the navigation menu. Click Oracle Database, then click Oracle Base Database Service.
2. Click Create DB System.
3. Enter the new Oracle Base Database Service compute information including: DB system name, availability domain, shape (including number of CPUs to use), storage, node count, Oracle Database software edition, ssh key for CLI access, licensing type (license included or BYOL), VCN, client subnet on the VCN where DB system will run, hostname prefix for the DB system, and diagnostic collection options.
4. Click Next.
5. Enter the new database's information including: database name, DB unique suffix, database image (19c or 21c), and administrator credentials (password for sys user).
6. Under Configure Database Backups, select Enable Automatic Backups, then click Backup Destination, and click Autonomous Recovery Service.
7. Select a Protection Policy according to the retention period requirements for the database:
   • Bronze: 14 days
   • Silver: 35 days
   • Gold: 65 days
   • Platnium: 95 days
8. Select Real-time Data Protection.
   This option enhances database protection and minimizes the potential for data loss. Selecting this option is an additional cost.
9. Select the default Retain backups according to the protection policy retention period.
10. Select a scheduled time for daily backups.
11. Select Take the first backup immediately.
12. Click Create Database System.
    A new Oracle Base Database Service database is created.

The database window displays the backup information.

A level 0 backup of the new database will be taken to the Recovery Service backup destination. Incremental backups are performed everyday according to the specified backup schedule. If the default Anytime was specified for the backup schedule, the daily backup will be performed everyday at the same hour the database was created. Backups are retained in Recovery Service according to the specified backup protection policy. With Recovery Service incremental forever technology, there is no need to take weekly level 0 full backups. Recovery Service can produce a virtual full backup when required, without consuming CPU cycles on the Oracle Base Database Service system.

After the database is created, clicking the Autonomous Recovery Service link will display a Protected Database OCI object. The protected database displays: the status of the database (protected), if real-time redo transfer is enabled, the data loss exposure (in minutes), the size of the database backups, and the current recovery window in days and hours.

Enable Oracle Managed Backups for Existing Databases

These steps describe how to enable Oracle managed backups to Recovery Service for databases that were created without Oracle managed backups. The existing database must be running Oracle Database 19.18 and above, or 21.8 and above.

1. Open the navigation menu. Click Oracle Database, then click Oracle Base Database Service.
2. Select the Base Database System where the Oracle Base Database Service is configured.
3. Select the database where you want to enable Oracle managed backups to Recovery Service.
4. Click Enable Automatic Backups.
5. Select the Enable automatic backups checkbox.
6. Click Backup Destination, and select Autonomous Recovery Service.
7. Select a Protection Policy according to the retention period requirements for the database:
   • Bronze: 14 days
   • Silver: 35 days
   • Gold: 65 days
   • Platnium: 95 days
8. Select Real-time Data Protection.
   This option minimizes the potential for data loss.
9. Select Retain backups according to the protection policy retention period.
10. Select a scheduled time for daily backups.
11. Select Take the first backup immediately.
12. Click Save Changes.

A level 0 backup of the database will be taken to the Recovery Service backup destination. Incremental backups are performed everyday according to the specified backup schedule. If the default Anytime was specified for the backup schedule, the daily backup will be performed everyday at the same hour the database was created. Backups are retained in Recovery Service according to the specified backup protection policy. With Recovery Service incremental forever technology, there is no need to take weekly level 0 full backups. Recovery Service can produce a virtual full backup when required, without consuming CPU cycles on the Oracle Base Database Service system.

A new Protected Database OCI object is created and associated with the database. The protected database displays: the status of the database (protected), if real-time redo transfer is enabled, the data loss exposure (in minutes), the size of the database backups, and the current recovery window in days and hours.

Create On-Demand Backups

After Oracle managed backups to Recovery Service are enabled, on-demand backups can be taken using the OCI console by following these steps.

1. Open the navigation menu. Click Oracle Database, then click Oracle Base Database Service.
2. Select the Base Database System where the Oracle Base Database Service is configured.
3. Select the database where you want to create an on-demand backup to Recovery Service.
4. Under Resources, click Backups.
5. Click Create Backup.
6. Enter a name for the new on-demand backup.
7. Click Create Backup.

A new backup is created and displayed in the list of available backups. On-demand backups remain in Recovery Service according to the backup retention policy (bronze, silver, gold, or platnium) selected for automatic backups.

Create a New Database from a Backup

Create a new Oracle Base Database Service database from an existing Oracle managed backup by following these steps.

1. Open the navigation menu. Click Oracle Database, then click Oracle Base Database Service.
2. Select the Base Database System where the Oracle Base Database Service is configured.
3. Click the source database from which the backup already exists in Recovery Service.
4. Under Resources, click Backups.
5. Click the Actions menu for the backup you want to use as the source for the new database.
   A new menu is displayed.
6. Click Create Database.
7. Click Create a New Database System, and then click Create.
8. Enter the new database's compute information.
9. Click Next.
10. Enter the new database's information.
    When selecting the Database Image version, select the same database version as the source database.
11. Click Create Database System.

The new database is created on a new Base Database system in the same OCI region and availability domain as the source database. Note you cannot enable automatic backups during database creation from an existing backup. If automatic backups are required, enable automatic backups after the database is created.

Restore a Database

An Oracle Base Database Service database can be restored to the latest available restore point, to a particular point in time, or to a particular SCN. Restore and recovery are done using the OCI console. These steps illustrate how to restore a database.

1. Open the navigation menu. Click Oracle Database, then click Oracle Base Database Service.
2. Select the Base Database System where the Oracle Base Database Service is configured.
3. Select the database to restore.
4. Under Resources, click Backups.
   A list of available backups is displayed. Although it's not possible to restore a database from a backup in this list, the list of backups can be used as a reference as to what data is currently available to restore the database.
5. Click Restore.
6. Select one of the three restore options:
   • Restore to the latest: Database is restored and recovered with zero, or least possible, data loss.
   • Restore to timestamp: Database is restored to a specific timestamp.
   • Restore to SCN: Database is restored to a specific Oracle Database system change number. You must know the specific SCN.
7. Click Restore Database.