Veeam support case ID: 05064782 & 02528676 & 02528676
Backing up and restoring Oracle DB has been a difficult journey.
At first, we designed our backup to use Veeam RMAN plugin. But then Veeam/Dell EMC released their Powermax Plugin which would make backup and restore of Oracle a lot easier. At least, that is what we thought.
We were able to successfully create application aware Oracle DB backups by using storage snapshots (Powermax plugin).
But when we tried a restore with the Veeam Explorer, it did not work.
I'm no Oracle expert but from my understanding you cannot use ASMFD (ASM Filter Driver) which made us fallback to RMAN.
The Veeam Explorer for Oracle only supports ASMLib (ASM Library). So be warned!
It's in the documentation but it took me some time to find it.
As for the workaround we are now trying to implement:
Deploy the Veeam RMAN plugin on all the Oracle DB VMs so they can use the Veeam repository.
Deploy the Veeam Linux Agent managed by Veeam VBR.
Create a dummy file backup job which allows us to use a pre-job script that will start an RMAN backup.
-
filipsmeets
- Enthusiast
- Posts: 37
- Liked: 3 times
- Joined: Jun 26, 2019 3:28 pm
- Full Name: Filip Smeets
- Contact:
-
HannesK
- Product Manager
- Posts: 14844
- Liked: 3086 times
- Joined: Sep 01, 2014 11:46 am
- Full Name: Hannes Kasparick
- Location: Austria
- Contact:
Re: Restoring Oracle DB not possible
Hello,
thanks for sharing your experience with the community.
Yes, your workaround is most commonly used configuration (as far as I know). In the "dummy file backup job", customers usually also back up configuration files. So it's a little bit more than "dummy".
Best regards,
Hannes
thanks for sharing your experience with the community.
Yes, your workaround is most commonly used configuration (as far as I know). In the "dummy file backup job", customers usually also back up configuration files. So it's a little bit more than "dummy".
Best regards,
Hannes
-
Andreas Neufert
- VP, Product Management
- Posts: 7081
- Liked: 1511 times
- Joined: May 04, 2011 8:36 am
- Full Name: Andreas Neufert
- Location: Germany
- Contact:
Re: Restoring Oracle DB not possible
Hello Filip,
thanks for sharing your experience. It is always helpful to get feedback from the field.
ASMFD was specifically designed to not allow any kind of data manipulation on the ASM disks that do not come from Oracle itself. Not sure if there would be any way that we could leverage Oracle somehow to recover data from a non Oracle format which is our image level backup. See for example here: http://www.dba-oracle.com/t_admfd.htm
For now the option you have described with the Plug-in and usage of RMAN is the way to go here.
For the scheduling... we want to address this in an upcoming version.
thanks for sharing your experience. It is always helpful to get feedback from the field.
ASMFD was specifically designed to not allow any kind of data manipulation on the ASM disks that do not come from Oracle itself. Not sure if there would be any way that we could leverage Oracle somehow to recover data from a non Oracle format which is our image level backup. See for example here: http://www.dba-oracle.com/t_admfd.htm
For now the option you have described with the Plug-in and usage of RMAN is the way to go here.
For the scheduling... we want to address this in an upcoming version.
Who is online
Users browsing this forum: Bing [Bot], Majestic-12 [Bot] and 83 guests