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-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of Patrick Sent: Friday, May 01, 2009 4:04 AM To: VERITAS-BU@MAILMAN.ENG.AUBURN.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. netbac...@whelan-consulting.co.uk -----Original Message----- From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of nellis Sent: 30 April 2009 22:23 To: VERITAS-BU@MAILMAN.ENG.AUBURN.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_el...@discovery.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +---------------------------------------------------------------------- _______________________________________________ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu _______________________________________________ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu _______________________________________________ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
