Unsolved
This post is more than 5 years old
6 Posts
0
2312
April 21st, 2014 10:00
How can I backup Oracle RMAN Boost Backups to tape via NetBackup?
We're currently testing Oracle RMAN backups using boost. Our normal method was to dump RMAN backups to local storage, then every night a job runs to copy those backup files to a Data Domain via NFS. Once a month, we take that NFS exported filesystem on the DD, mount it on an NBU media server, and put it to tape for long term retention.
So now the challenge is getting those boost backups to tape. A former EMC Oracle specialist recommended mounting that storage unit (which is nothing more than an mtree on the DD) using NFS and then backing up the files to tape in the same manner as we are currently doing. Has anyone done this successfully? I'm getting errors on testing a restore (we restored the tape backup of the mtree onto a local filesystem) and not sure if its because of the boost file format. We need a NB-managed tape backup since we also use NB to manage the offsite tapes.
Thanks



ble1
4 Operator
•
14.3K Posts
0
April 22nd, 2014 09:00
I'm not sure how BN does it these days, but since you are testing Boost there is one question hanging in the air? Do you
a) use NB module for online backup, or
b) ddboost direct plugin?
If b), then exporting this to tape directly is challenge as whole procedure happens outside backup application knowledge (I know that in latest version of NW they made it aware, not sure how NB stands in that respect). I would rather invest in archve tier there and have it managed by hardware. If a), then all you need to do is call migrate data from one volume to another using backup application.
LT2012
6 Posts
0
April 25th, 2014 13:00
Its "b".
I would prefer using the NB RMAN Agent, but we already have boost licensed.You mentioned NetWorker having visibility into the RMAN Boost...so if the DBAs use RMAN direct to DD via Boost (no NW plugin), NW is aware of those backup files, and can clone them to tape?
LT2012
6 Posts
0
April 25th, 2014 13:00
Raghava...I have engaged presales and didn't really get a definitive answer.
I do plan on trying to restore back to the Storage unit via NFS, but I need to expire those files first to mimic a true recovery scenario.
ble1
4 Operator
•
14.3K Posts
0
April 25th, 2014 16:00
b) is something I do not use (I use a) approach with DD Boost). I noticed that sales guys like to sell b) by stating lower license cost due to no agent or module use, but nowadays customers use more and more capacity license so this no longer applies. We use a) as we wish to have single orchestrator for backup operations and integrating with advanced features of DD comes as nice bonus.
With that said, yes, one of selling points in NW 8.1 was that DBAs can do backup on their own and NW would still pick it up into database. As I do not use that approach I can't really comment it on how exactly does it work (or not). In theory, with backup record awareness in backup application it should be easy to migrate or copy records from one media to another.
Which brings me to last topic - record awareness. You use direct backup to DD and wish to use tapes too. To my knowledge, tape awareness between DD and TL is none. So, if you use ddboost plugin to manage backups of Oracle which you wish to use later on to push to tape which I assume is owned by backup application then I see somewhat disconnected backup environment which I would try to avoid at any cost. This is why I'm sticking to a) approach. I do not have details on what raghava has mentioned above, but it doesn't sound very enterprise to me if I have to do manual steps instead of automated ones. Just as VTLs could integrate with TLs, I suspect DD will have to add this to their portfolio as well. Of course, it might be pretty ok solution for you, especially if DD is being used solely DBAs for their own stuff. Mixed state is something I would try to avoid as I personally do not believe in it.
raghav.viswanathan
39 Posts
0
December 9th, 2014 20:00
Hi ,
I am facing the same problem, t
1. How to do a tapeout of DDBoost based oracle backups ?
If we create a NFS export for the DDBoost storage unit and mount it to NBU media server then how do we restore those backups?
Has anyone implemented this. Please let me know.