This article covers backup procedures that must be used for different types of data including:
It is strongly recommended to back up the OS disk and software disk (LUN 0) after the initial FlashGrid server configuration and before and after applying any changes, such as patch installation or security settings changes. Using Azure Backup service is the recommended method for backing up the disks.
az backup protection enable-for-vm --resource-group {resourcegroup} --vault-name {vaultname} --vm {vmname} --policy-name {policyname} --disk-list-setting include --diskslist 0
The backup configured by the above script includes both LUN0 and OS disks, because the OS disk is by default added to the VM backup and can't be excluded.
az backup protection enable-for-vm --resource-group {resourcegroup} --vault-name {vaultname} --vm {vmname} --policy-name {policyname} --exclude-all-data-disks
Connect to the Azure portal -> Recovery Services Vault -> {vaultname} -> Backup Items (Azure Virtual Machine) -> click {vmname} -> check Included disk(s) section.
Standard RMAN procedures should be used for backing up and restoring database files.
Two main options for backup destination are available:
Configuring a disk attached the FlashGrid server system for database backup
Configuring Azure File Share for database backup
Create Standard performance Storage Account and add a file share.
Install cifs-utils
package:
# yum install cifs-utils -y
Make sure port 445/TCP is not blocked:
Azure Files uses SMB protocol, which communicates over TCP port 445. If you're having trouble mounting your Azure file share, make sure your firewall is not blocking TCP port 445.
Create backup mount point:
# mkdir /db_backup
# chown oracle:oinstall /db_backup
# chmod 755 /db_backup
Create a persistent mount point for the Azure file share in /etc/fstab
. Example:
//mystorageaccount.file.core.windows.net/myfileshare /db_backup cifs vers=3.0,username=mystorageaccount,password=c3N+JcWQk7bw0yTT/yAMBmDcEFcRa4AkPQp+zpaljj6e...,dir_mode=0755,file_mode=0755,gid=2000,uid=3001
Where uid and gid options are Oracle software owner user and group ids respectively. If you have a customized user, then you need to change these parameters accordingly.
Mount the backup folder:
# mount /db_backup
Please follow Grid Infrastructure Backup and Restore Best Practices
For backing up and restoring files on ACFS use same tools and procedures that you would normally use for file-level backup and restore.