Video Screencast Help

NBU7.5 oracle RMAN backup integration prerquisites

Created: 30 Jan 2013 • Updated: 28 Mar 2013 | 3 comments
This issue has been solved. See solution.

I want to know the basic prerquisites for integrating ORACLE database with NBU7.5.

Comments 3 CommentsJump to latest comment

Mark_Solutions's picture

Take a look at the Oracle Admin Guide - most of what you will need to know is in that as all capabilities and pre-requisites are covered in the first sections:

http://www.symantec.com/docs/DOC5175

Hope this helps

Authorised Symantec Consultant

Don't forget to "Mark as Solution" if someones advice has solved your issue - and please bring back the Thumbs Up!!.

SOLUTION
Yasuhisa Ishikawa's picture

Also check latest DB compatibility list.
http://www.symantec.com/docs/TECH126904

If you are to configure Oracle backups using tamplate, make sure Oracle DBA's shell must be bourne shell. Template does not work with *csh.

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

Marianne's picture

My 2c (after 14 years of assisting dozens of customers with Db backups):

Carefully read through the manual (link in Mark's post).
This will give you a good understanding of the role of the backup admin and the role of the Oracle dba.

Never try this on your own (unless you are a knowledgeable Oracle dba).
Make the dba your best friend - you need to work as a team on this.

Show the dba the section in the manual on how to link NBU plugin with RMAN (downtime is no longer required).
RMAN scripts are 100% the dba's responsibility, although NBU provides sample scripts. The manual will tell you the location of these sample scripts. It is up to the dba to decide if he/she wants to customize sample scripts or provide own script(s). If own script(s), dba must add 'su - oracle ... ' to script, because automatically scheduled backups are started as root user. See sample scripts. RMAN script should also specify output file for the script.

Your job is to create policy for Oracle backups, ensure correct forward and reverse lookup between Oracle client and master as well as media server(s), ensure that media is available in the STU selected for the backup. Important to understand difference between Automatic Backup schedule and Application Backup schedule and how actual retention levels are linked to Application Backup schedule.
Ensure that bprd log exists on master to troubleshoot initial comms between client and master.
Logs needed on media server are bptm and bpbrm.
Work with dba to create logs on Oracle client, such as bpcd and dbclient. If Unix/Linux, ensure dbclient folder has 777 permissions.

Likewise, restores are also dba's responsibility. Either via restore scripts or using RMAN commands from cmd. 
You need to ensure that restore media and resources (tape drives) are available for restores.

Hope this helps...

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