Oracle Provides Automatic Managed Backup Service on DBCS Machine. Oracle completely managed the Backup of the database on the customer’s behalf. It stores the backup in DBaaS tenancy, not the customer tenancy
How to configure Automatic Managed Backup
Step 1
Open the navigation menu. Under Oracle Database, click Base Database service.
Step 2
Choose your Compartment.
A list of DB systems is displayed.
Step 3
Find the DB system where the database is located, and click the system name to display details about it. A list of databases is displayed.
Step 4
Find the database for which you want to enable or disable automatic backups, and click its name to display database details. The details indicate whether automatic backups are enabled. When backups are enabled, the details also indicate the chosen backup retention period.
Step 5
Click Configure Automatic Backups.
In the Configure Automatic Backups dialog, check or uncheck Enable Automatic Backup, as applicable.
If you are enabling automatic backups, you can choose to configure the following:
Backup Retention Period: If you enable automatic backups, you can choose one of the following preset retention periods: 7 days, 15 days, 30 days, 45 days, 60 days, or 90 days. The default selection is 30 days.
Backup Scheduling: If you enable automatic backups, you can choose a two-hour scheduling window to control when backup operations begin. If you do not specify a window, the six-hour default window of 00:00 to 06:00 (in the time zone of the DB system’s region) is used for your database.
Click Save Changes.
Characteristics of Automatic Backup
Automatic backups have the following characteristics:
Backup Location: These managed backups are stored in Cloud Object Storage under an internal bucket ( Users do not have direct access to the backup bucket under object storage service)
Backup List: The list of backups you see in the Console does not include any manual unmanaged backups (backups created directly by using RMAN or dbcli).
Backup Encryption: All backups are encrypted with the same master key used for Transparent Data Encryption (TDE) wallet encryption.
Backup Retention: 7, 15, 30, 45, or 60 days. Can be changed afterwards.
Object Storage Costs – Automatic backups incur Object Storage usage costs.
Delete Backups: You cannot explicitly delete automatic backups. Unless you terminate the database, automatic backups remain in Object Storage for 30 days, after which time they are automatically deleted. When you terminate a DB system or a database, all of its resources are deleted, along with any automatic backups. Full backups remain in Object Storage as standalone backups. You can use a standalone backup to create a new database.
In-Place Restore: Yes
Create Database from Backup: Yes.
Replication across Regions: No. Data is not replicated in another Region.
Restore across ADs: Yes.
Restore across Regions: No from the console. But it can be done manually
How to check Backupconfig from Backend in DBCS
Login to the server as OPC and then sudo to root
dbcli list-backupconfigs dbcli describe-backupconfig -i <backup config id from Previous command> dbcli list-databases dbcli describe-database -i <database id from previous command>
How to check Backup from the backend
Login to the server as OPC and then sudo to root
The below command lists the backup jobs run by dbcli
dbcli list-jobs
The below command gives the details about the backup job id
dbcli describe-job -i <backup_job_id>
How to find the backup logs in the backend
RMAN logs under /opt/oracle/dcs/log/<node name>/rman/bkup/
I hope you like this article on How to configure Automatic Managed Backup on DBCS. Please do provide the Feedback
Related Links
Oracle Database Cloud Backup Module
How To Backup Database To Cloud Object Storage Using DBCLI
How to configure Automatic Managed Backup on ExaCS
Troubleshooting backup Failures in ExaCS
