Video Screencast Help

NetBackup for Oracle

Created: 18 Nov 2010 • Updated: 19 Nov 2010 | 7 comments

OK, I hope this doesn't sound to stupid as I'm really only a month into learning NBU and I realize I havn't come close to scratching the surface, but here goes.

We have an Oracle RAC that NBU is currently backing up the Oracle database on. NBU version is 7.0 and the master is Windows 2008.

Anyway, I inherited NBU and as such have spent some time over the last month slowly learning NBU.

Now I'm getting close to having to tackle creating restore procedures for our entire DR plan which NBU just so happens to be a part of.

So I start looking at the NBU for Oracle Admin guide, at the restore portion in particular, and I pretty much see nothing but references to running RMAN.

OK, so looking back at how NBU performs a backup of Oracle, what does NBU do? It calls a RMAN script that actually performs the backup.

So my question is what is NBU actually doing here other than running an RMAN script on a schedule?  Why use NBU if that's all it is really doing, as using NBU just adds more layers of confusion to a disaster recovery situation taking into account NBU clients and NBU's own commands. It just seems like it adds more than is really needed.

I'm just trying to figure out why it wouldn't be easier to run RMAN independent of NBU and push the RMAN backups to a disk location where these are then backed up to tape using NBU as an archiving function.

Please let me know what the huge benefit is.

thanks

Comments 7 CommentsJump to latest comment

J.H Is gone's picture

"I'm just trying to figure out why it wouldn't be easier to run RMAN independent of NBU and push the RMAN backups to a disk location where these are then backed up to tape using NBU as an archiving function. """'"

 

That is what a lot of us do (but as backup not as archive)!  (same for informix and sql)

The dba's are in charge of the database, so let them be in charge of the backup to disk.

Now here you have two choices.

For me , the sql backups to disk happen at 10 pm, should be done by 2 am. So I have a policy of just SQL servers and they start the backup to tape at 2 am. 

As for my informix and oracle.  The dba's are in charge of the database so they are in charge of the backup.  They create a script that runs a backup to a disk drive ( my environment is unix).  After they are done with the script I go and add some testing to make sure the backup to disk worked, then I have the command to backup that backup disk or files to tape using a 'user' schedule.  I end it with a test that it worked or not and send an email that it failed or was good.

So now I don't have to know anything about RMAN or any of that database stuff for backups or restores.  And the DBA's don't have to know anything about Netbackup.  If they need a restore, they either get it from the backup that is still on disk, or they ask me to restore a different day, and again they do the restore from the disk back.

Less compilations for me less for them.

But then on the other side, that takes extra disk space.  Do you have it, can you afford it.

Can you afford the time to do the backups to disk then to tape.  Some cannot so they go directly to tape.

There are people who do it both ways.  You just have to decide which fits you best!

I don't have to know how to spell....I work on Unix.
NetBackup 7.0.1 - AIX & Windows

Andy Welburn's picture

especially after Judy went to the trouble of replying to it! Hopefully, the subject matter wasn't much more than the quote Judy included in her reply!

***EDIT***

Just as an aside - that's what we do, no agents etc, just DBA scheduled hot backups to disk & these subsequently hived off to tape before the next scheduled hot backup.

I'm presuming that's relevant to your original question?  indecision

***EDIT #2***

So now I look stupid(er) - the content of the OP has been resurrected or I've had a senior moment....

jwmcf1's picture

I put it back up,

Sorry, I thought I had removed soon enough to prevent a response, but I'm glad that I didn't because J.Hinchcliffe's response is excellent! 

I started looking further through admin guide and noticed that NBU does 'supposedly' give you a nice wizard to restore from and thought well maybe my question was posted to soon(which I'm still confused as to where you run this wizard, on the client or on the master?? thats another topic though!)

Andy excellent response as well!

Now my next questions are: knowing nothing about RMAN (and really not wanting to know) I assume a script can be created (not unlike the RMAN script NBU uses) that can:

1. can be scheduled to run at a certain time?

2. can be pushed to a Windows share? (my DB is on linux)

3. be given a new file name based on date as to maintain say a 30 day archive (and not overwrite the most recent)

Now, I am still curious if anyone else has any input as to what benifit there is to using NBU Oracle agent and jumping through all the whoops?  Maybe it would be good if I knew nothing of RMAN? as it helps to create templates? I don't know, any input is appreciated.

Andy Welburn's picture

prevent a response" - that's fine. Senior moment over! (There was one occurrence where every entry from one user was removed in a thread - made the whole thing a bit nonsensical!)

"knowing nothing about RMAN (and really not wanting to know)" - my philosophy too, leave all that to those that do.

Marianne's picture

In all honesty, in my 12 years experience with NBU, I have never attempted to do any database backups without a knowlegable Oracle DBA. Most of our customers are using the NBU for Oracle agent. Once the DBA's have seen the agent work, they won't use any other method.

It's a one step backup and one step restore.

You won't see much RMAN info in NBU manuals because it is part of Oracle.NBU provides the plug-in to interact with NBU. NBU merely provides automatic scheduling plus image and media management.

Extract from NBU for Oracle manual:

The rman command starts an RMAN backup or restore. Your Oracle documentation describes this command.

 

About the wizard - another extract from the manual:

To create RMAN templates using the NetBackup for Oracle RMAN template generation wizard

1.  Log on to NetBackup for Oracle client and start the NetBackup Backup, Archive, and Restore interface.

 

I have hardly ever used this wizard, because I always work with the dba who knows RMAN and understands that the backup and restore scripts are his/her responsibility.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

J.H Is gone's picture

I find that very interesting that they love it.

We tried setting up the Informix agent to do the informix backups. (both AIX) and we had a hard time with it (me as backup admin - and the lead dba).  And then trying to do the restores to other servers (refresh of the database on the test and stage servers) was very hard.   We found that it was just too complicated for what we do.  It was much easier and script-able if we backed up to disk. 

I don't have to know how to spell....I work on Unix.
NetBackup 7.0.1 - AIX & Windows

jwmcf1's picture

"NBU merely provides automatic scheduling plus image and media management" "

This is what I am trying to understand:  is if this is all NBU is really providing, it just seems like it would be simpler and cleaner to simply have the dba schedule the RMAN script to run at whatever time desired and then push these backup files to a share somewhere.  NBU could then be used to backup this share to tape if desired.  The job would be a simple directory backup. 

If a restore is needed, simply pull the needed RMAN backup files from the share back to the Oracle box and perform an RMAN restore (which is whats being done anyway even with NBU right?).

"I have hardly ever used this wizard, because I always work with the dba who knows RMAN and understands that the backup and restore scripts are his/her responsibility."

I don't know, but it sounds like if the RMAN scripts are being handled by the dba, then why doesn't the dba just handle the restore directly utilizing the RMAN script?

If the wizard isn't used, that means that the RMAN script/template is being edited exclusivly without any sort of GUI, and that means that restore is handled with the bpdbsbora command correct?

 

thanks

 

 

man