Monday, February 24, 2020

Backup an Oracle DB using Veeam Plugin for Oracle RMAN

In this short article, I will try to cover the basic steps about how to take a backup of Physical windows based Oracle Server using the 'Veeam plugin for Oracle RMAN'.
In my scenario, normal backup through an agent was getting failed with the error message: 'Unable to perform a backup: Oracle Automatic Storage Management (ASM) disk configuration is not supported'.

After further discussion with Veeam's support and my oracle DBA team, we decided to proceed with Veeam Plugin for Oracle RMAN. So, Let's begin,

Prerequisites:
 1. Veeam Backup server 
     Version   - Minimum Veeam 9.5 u4
     License  - Veeam Enterprise Plus or Veeam Universal License(VUL)
      
2. Oracle Server
     Version - Minimum 11gR2
     Port - From Oracle Server to Veeam Bkp(10006, 2500 to 3300)
     RMAN Script - Attached the sample script in the bottom. for more info, Click Here> 
     Permission - Backup service account should have access to the Oracle Server to perform the backup operation using the RMAN script.


Procedural:

Step1- Deployment of Veeam plugin for RMAN on Oracle Server
             The setup file(MSI) can be found in the Veeam Backup and replication setup ISO image under the plugin folder. Once installed, Next, you need to configure the plugin as follow-.

Double Click on 'Veeam Plugin for Oracle RMAN configuration wizard' from the Desktop icon.














Type the FQDN/IP address of the Backup server with Veeam admin credential
















Add Repository
















Now you should be able to see that Veeam Plug has created the required device and channel configuration. Save the configuration by using the export option and click Finish.
















Step2: Initiate the backup using RMAN Script.
         In my case, I wanted to take the full backup of the Oracle DB with an option of arching the logs as well. Below is the sample script file for the same. For more info, Click Here>  
After the successful execution of the below script,  Veeam Plugin for Oracle RMAN will create the required backup job in the Veeam backup server side automatically.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
rman target Credential here(exmple- sys/Password@DBName)
crosscheck archivelog all;
Delete noprompt expired archivelog all;
crosscheck archivelog all;
run
{
backup as compressed backupset database;
backup as compressed backupset archivelog all;
backup current controlfile;
delete force noprompt archivelog until time 'SYSDATE-2';
}
+++++++++++++++++++++++++++++++++++++++++++++++++++++++

Backup Job Creation at Veeam Backup server-side after successful execution of RMAN commands:



Thank you,

No comments:

Post a Comment