I don't have anywhere near as many DB's as you but we do backup multiple DB's 
on a single host.  I don't think that restarting a failed job from inside the 
GUI just restarts a backup on the failed DB.  I think that will restart a 
backup of all the DB's covered by the policy.

When we want granularity with regard to DB backups on the same server we have 
to break them into individual policies which use an RMAN script on the backend 
to actually run the backup.  I tend to just copy the existing "catch all" 
policy to a new one and rename a new copy of the RMAN script which it calls to 
reflect the dayabase it's backing up.  

For example Solaris_OraTier2 with /usr/openv/netbackup/bin/rman_backup.sh was 
the setup for the catchall policy.  Now I have Solaris_OraTier2_tst11510 
calling usr/openv/netbackup/bin/rman_backup_tst11510.sh to backup a specific DB 
on that host.  You'll also need separate /usr/openv/netbackup/bin/rman_oratab 
files for each backup of a specific DB.

Mark Glazerman
Desk: 314-889-8282
Cell: 618-520-3401
 please don't print this e-mail unless you really need to


-----Original Message-----
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu 
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Patrick
Sent: Friday, May 01, 2009 4:04 AM
To: VERITAS-BU AT MAILMAN.ENG.AUBURN DOT EDU
Subject: Re: [Veritas-bu] Backing up multiple Oracle db's from a single host

I don't know the answer to your question, but I do have a suggestion. Why
not have one script for each DB on the client in addition to the one your
using now, and if a DB backup fails run that script from the client? This
will keep your policy number down but allow the DBA to re-run individual
backups if needed. Just a thought.

Regards,
 
Patrick Whelan
VERITAS Certified NetBackup Support Engineer for UNIX.
VERITAS Certified NetBackup Support Engineer for Windows.

netbackup AT whelan-consulting.co DOT uk



-----Original Message-----
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of nellis
Sent: 30 April 2009 22:23
To: VERITAS-BU AT MAILMAN.ENG.AUBURN DOT EDU
Subject: [Veritas-bu] Backing up multiple Oracle db's from a single host


Hello everyone, first I'll go ahead and apologize for such a long post.

I'd like to ask everyone; what works best for those of you backing up
multiple Oracle db's from a single host. I have several Oracle 10g servers I
backup. Each has anywhere from 1 to 20 db instances. I use a single policy
and a common path & script name to backup the Oracle servers. This for me
keeps the number of policies I have to manage down to a minimum. 

Our dba's have asked for one policy to be setup per DB. The reasoning behind
this is that they want the flexibility to restart a failed backup without
the restart initiating a backup of all DB's on servers. I told them that
what they should be doing on failed DB backups is from the "activity
monitor", right click on the failed Job ID and select restart. 

Here is where my lack of "in depth knowledge" of how NBU works with the
Oracle RMAN API when a single stream fails. 

They asked, how does NBU know to just restart the backup for the DB that
failed? The best "high level" reply I could come up with was that NBU tracks
which DB piece it's backing up in a log and when a restart is initiated,
it's able to request a backup of just the DB which that piece was associated
with via calls to the Oracle RMAN API. 

In other words, restarting a single failed Jod ID from "activity monitor"
for a backup stream associated with an Oracle backup does not mean that NBU
looks at the policy and executes the backup script specified in the backup
selection for all servers or just one server which is a member of that
policy.

Am I wrong? 
How does a restart work with Oracle? 
How do you backup Oracle servers which host multiple instances?
What are the advantages and disadvantages if any with one policy per
instance?

Having a policy for each to me sounds like a nightmare in more than one way
but I'd REALLY appreciate anyone's input here.

Thanks in advance to everyone that replies!

+----------------------------------------------------------------------
|This was sent by Norman_Ellis AT Discovery DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------


_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu