With Oracle Database Cloud Service, you can change the backup destination for your database deployment after creating it. When a database is deployment, it is configured with one of the following backup destinations. I choose None during deployment and now would like to configure backups.

  • Both Cloud Storage and Local Storage
  • Cloud Storage Only (not currently available for database deployments that use Oracle RAC)
  • None

Prerequisites:

To configure both Cloud Storage and Local Storage, you must increase the size of the local storage used for local backups. Click Here to know how to add/increase storage volume.

You must have an Oracle Storage Cloud Service container in your account that is reserved for cloud backups. Here is information for how to create Container

Local Backups:

Connect as the “opc” user to the compute node and start root-user. Change to the location for the backup configuration file.

If a “bkup.cfg” file already exists and contains configuration details, rename the file to make it a backup in case you want to recover that configuration later. In my case its blank. So added the backup information.

BKUP_DISK is for local disk backup, and enabled local backup by setting this parameter to YES. Local disk backups are written to the Flash Recovery Area, which is /u03/app/oracle/fast_recovery_area directory.

Prepare “bkup.cfg” to be used as follow:

Cloud Backups:

For backups as Cloud Storage Only destination, enter as follows:

  • oss-url is the REST endpoint of the storage container.
  • username is the username for your account.
  • password is the password for your account.

DBaaS monitor console also shows the backup status.Click to know more about DBaaS monitor console

Capture5

OS/DB home configuration backups:

The /home/oracle/bkup/CDDB01/obkup cron job performs operating system file backups. Two files “dbcfg.spec” (Oracle_Home configuration files ) and “oscfg.spec” (OS Configuration Files) are there to back up configuration files. If you have more directories to be backed up, please update these configuration files.

Capture5

Mandy!!!!

Reference:

https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/change-backup-config-different-destination.html#GUID-E7EBDB67-007A-4910-8B5A-A84B5A4AA27E
https://docs.oracle.com/en/cloud/iaas/storage-cloud/cssto/creating-containers.html

Leave a Reply