Oracle backup in Azure vm

Question

Hello all ,

I have an Azure vm running win 2019 and is protected with Azure backup. This vm runs Oracle DB as well

Will DB be operational after a full vm restore? What other options exist to backup Oracle on Azure VM?

thank you ,

Answer 1

Hello @Nikos Sotiriadis Thank you for posting your question on the Microsoft Q&A platform. Happy to answer any questions you may have!

Basically your question is about the restore of Oracle DB and will it be operation post restore. Also, if there are any other options exist for backing up Oracle on Azure VM.

If you have taken a full VM backup using Azure Backup, then the Oracle DB will be operational after a full VM restore. Azure Backup takes application-consistent snapshots of your running VM and Oracle databases. The databases will be placed into backup mode allowing a transactionally consistent online backup to occur while Azure Backup takes a snapshot of the VM disks. The snapshot will be a full copy of the storage and not an incremental or Copy on Write snapshot, so it is an effective medium to restore your database from. The advantage of using Azure Backup application-consistent snapshots is that they are extremely fast to take no matter how large your database is, and a snapshot can be used for restore operations as soon as it is taken without having to wait for it to be transferred to the Recovery Services vault.

Apart from Azure Backup, you can also use Oracle Recovery Manager (RMAN) for backups to disk and restores from disk. For backup/restore functionality, the SAP BR*Tools for Oracle are supported in the same way as they are on bare metal and Hyper-V.

For more information about how you can use Azure Backup and Recovery services for Oracle databases, see:

Back up and recover Oracle Database on an Azure Linux VM by using Azure Backup

Backup strategies for Oracle Database on an Azure Linux VM

Back up and recover Oracle Database on an Azure Linux VM by using Azure Files

Hope this helps. Let us know if you have any other questions.

---

If the response helped, do "Accept Answer" and up-vote it