Video Screencast Help

Can RMAN perform "inline" backups to disk and tape with Netbackup agent?

Created: 21 Mar 2012 • Updated: 03 Jun 2014 | 3 comments
This issue has been solved. See solution.

We are trying to come up with a standard for Oracle backups. Running Netbackup 6.5.6 on Linux, and the DB platform is Oracle 11g (also on Linux). We also have Data Domain appliances that we are thinking about leveraging.

Current strategy the DBAs use is to utilize NB RMAN agent to backup to tape, or no NB agent, and just use RMAN to disk (then NB picks that up as a regular filesystem backup).

Someone mentioned a feature in RMAN that allows for streaming the backups to disk AND tape. I've done some rudimentary research, and have not found anything that details this feature. Wondering if anyone can provide info on this.

Also, I've had a DBA implement the NB agent to backup Oracle DBs to Data Domain. In setting the "filesperset=1" (best practice for RMAN to DD), this results in A LOT of backup streams. And if any of those streams fail, the backup is no good (these failed streams cannot be restarted at the NB level).

In case its not evident from the post...I am not a DBA.

 

Thanks

Comments 3 CommentsJump to latest comment

teiva-boy's picture

There are fantastic whitepapers on my.datadomain.com for Oracle to DataDomain.  You should read up on them.  I've got customers getting as low as 4x dedupe upwards of 15x, dumping direct to an NFS mount on the DD system.  I have never run into issues with stream counts with them, and they are very large dotcom's with very acctive storefronts running oracle on the backend.

Might want to see if you are using the optimum settings?

 

There is an online portal, save yourself the long hold times. Create ticket online, then call in with ticket # in hand :-) http://mysupport.symantec.com "We backup data to restore, we don't backup data just to back it up."

Yasuhisa Ishikawa's picture

I've nerver heard such RMAN functionality. If someone mentioned, it is better to ask detail and sample RMAN commands to them.
NetBackup has ability of inline copy(multiple copies). If you don't mind handler of online copy, this may be an option.

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan

Nicolai's picture

Your'e observation is right for filesperset=1. It means RMAN will make one job per table space file. The problem with filesperset >1 is that RMAN find new combination of data files for each backup job. That will result in a lower deduplication rate. A trade off could be filesperset in a range form 1 - 5.Test it out :-)

If you wan't two concurrent copies you should look into inline copy just like Yasuhisa suggested (see the admin manual). If you are looking into a "pure" rman solution you need to have your'e DBA look at this article.:

http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcncpt.htm#i1025065

Assumption is the mother of all mess ups.

If this post answered your'e qustion -  Please mark as a soloution.

SOLUTION