Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Camille.

Asked: June 23, 2020 - 7:46 am UTC

Answered by: Connor McDonald - Last updated: September 16, 2020 - 1:47 am UTC

Category: Database Administration - Version: 18

Viewed 100+ times

You Asked

When I deploy Oracle Database on Amazon EC2, I can backup to Object Store with RMAN, using "Oracle Secure Backup Cloud Module for Amazon S3".

This is great.

When I deploy Oracle Database on Azure, I would like to use Azure Blob Storage with RMAN. Is there a similar or recommended solution to have RMAN sending backup pieces to Azure Blob Storage?

In this case, I deploy Oracle Database myself on a virtual machine created in Azure. I do not use managed services.

Thank you

and we said...

Currently we do not have a dedicated module for it.

However, (I think) on Azure you can expose their object/blob storage as a filesystem. In that instance, you could use RMAN to backup to that.

Similarly, you could back up to an NFS share.

and you rated our response

  (1 rating)

Reviews

RMAN backup on Azure Blob Storage

September 15, 2020 - 6:46 pm UTC

Reviewer: Tim Gorman from Portland, OR

Just a note...

There is an open-source github project called "blobfuse" which uses the FUSE libraries to write to Azure Blob storage. I'm not including a link because I don't think unsupported mechanisms are appropriate for backups, but you can google it yourself if you wish?

Following are better options...

One presently available option for less-expensive storage for RMAN backups is "Azure Files" which on Linux VMs are mounted using the CIFS protocol (a.k.a. SMB or Samba). I recommend using the "premium" level of service of Azure Files, and I also recommend specifying the additional mount.cifs option "cache=none" ( https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-use-files-linux ).

Azure Files premium over NFS v4.1 starts in "public preview" today (15-Sep 2020), so that is another option. This offers the use of the NFS protocol (instead of CIFS) for remote Azure Files storage, for the premium option only ( https://docs.microsoft.com/en-us/azure/storage/files/storage-files-how-to-create-nfs-shares?tabs=azure-portal ).

Last and best, the ability to mount inexpensive and fast Azure Blob storage directly over NFS v3.0 started in "public preview" in July, available in the East US, Central US, and Central Canada regions. This will allow data from the DEVICE TYPE DISK adapter of RMAN to stream directly to Azure blobs. ( https://azure.microsoft.com/en-us/blog/nfs-30-support-for-azure-blob-storage-is-now-in-preview/ ). This option is expected to become GA in Q1 CY2021.

Hope this helps!
Connor McDonald

Followup  

September 16, 2020 - 1:47 am UTC

Thanks for stopping by Tim

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.