How to backup & restore oracle database on Azure Windows VM?

Question

Hi,

We are planing to migrate on-premise Oracle database server to Azure Windows VM. The on-premise server is running Oracle Standard v19.3

Please suggest how to setup backup of Oracle standard database instance running on Azure windows VM to blob storage?.

Does Azure Backup service support consistent oracle db backup for windows VM?.

Appreciate your support.

Regards

Pranav

Answer 1

Oracle Database must be on an Azure Windows VM, is it running on an Azure Linux VM.

If running on an Azure Linux VM, please refer to https://learn.microsoft.com/en-us/azure/virtual-machines/workloads/oracle/oracle-database-backup-azure-backup?tabs=azure-portal

This article demonstrates the use of Azure Backup to take disk snapshots of the VM disks, which include the database files and fast recovery area. Using Azure Backup you can take full disk snapshots suitable as backups, which are stored in Recovery Services Vault. Azure Backup also provides application-consistent backups, which ensure additional fixes aren't required to restore the data. Restoring application-consistent data reduces the restoration time, allowing you to quickly return to a running state.

• Back up the database with application-consistent backup
• Restore and recover the database from a recovery point
• Restore the VM from from a recovery point

Answer 2

1. Connect to your Azure Windows VM and log in to your Oracle database.

2. Create a backup of your Oracle database using Oracle Recovery Manager (RMAN) or another backup tool of your choice. It's recommended that you store the backup files in a separate location from the database files.

3. Transfer the backup files to a secure location, such as an Azure Storage account or another VM on Azure.

4. To restore the database, you will need to install Oracle Database software on a new VM or an existing VM that has sufficient resources to host the database.

5. Once the Oracle software is installed, you can restore the backup files to the new VM using RMAN or another backup tool.

6.After the restore is complete, you will need to perform some additional steps to configure the database for use, such as setting up the listener, configuring database parameters, and creating user accounts.

Answer 3

Yes, you can mount an Azure Blob storage container as a file system on a Windows VM using the Azure Blob Storage FUSE driver. Once you have mounted the Blob storage container as a file system, you can use it as a backup target for RMAN.