Hi Dave
Well I don't mind providing some input and some suggestions if that helps??
We used to Backup SQL Server with an agent, which allowed the Databases to
be backed up while it was online.
However, due to the costs of the agent, it was decided to get the SQL Admins
to configure SQL to perform its own Backups within SQL and place the files
on a separate partition.
Thus - Each Night we get full backups of the Databases, and SQL can still
run without being down.
No scripting is used in anyway. Backups are configured as SAN Media Servers
using SSO over fibre. Again, this may be withdrawn soon.
DBA Administrators SHOULD be responsible for the Databases, but need to be
aware if you are backing up using a type of Agent, or if you want them to
configure offline copies or "snap shots"
I would have thought Netbackup "could" be configured to perform Mounts and
Unmounts using a script, however in some of my cases, all Netbackup may do
is simply fail with a STATUS code. Unless another script can be run, PRIOR
to Netbackup starting the backup process? Maybe DBA Admin again perhaps?
Not sure if I have been of much help here, but thought I would reply to give
you an idea of what I currently implement.
Simon Weaver
Technical Support
Windows Domain Administrator
EADS Astrium
Tel: 02392-708598
Email: Simon.Weaver AT Astrium.eads DOT net
-----Original Message-----
From: Dave Markham [mailto:dave.markham AT fjserv DOT net]
Sent: 09 March 2006 17:10
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] backing up databases
Ok, been tasked with giving my input on a backup solution for a new project.
Someone had designed it to start backing up things using scripts from cron
calling other scripts and then netbackup bpbackup commands and all sorts of
random junk.
Anyway assume we are talking Solaris 8 or 9 with fiber attached units.
The question i have which was from the original design ( and i guess still a
requirement ) is how do people go around backing up database volumes. I
myself have had dbas ( running oracle ) to do hot_archives and then backup
that. The hot_archives are called from bpstart_notify so are captured within
netbackup if they take too long or if they fail. I can also do some checking
if directories exist etc before running the oracle backup. Also have the
added benefit of not writing to tape until exit call from hot_archive which
means db backup has finished.
Ok, thats one way, the other way i do on another project is use SSO option
on the database servers which have dedicated HBA's through fiber to the tape
units and shared drives. I just point at a location and assume everything in
there is ready to be backed up. This project is slightly different and the
DBA's are responsible for the backup.
The way this new project is wanting to go is by mounting a storage volume (
disk ) on the db server and writing a backup to it. then unmounting it and
then mounting it on the backup server to be written to tape directly.
What i want to know is how ( if we have to go this route ) can i control
this within netbackup and not start backups unless mount and unmount
requests have been done?
Do i have bpstart scripts on the db servers, which do the mounts, then the
oracle backups and then the unmounts. If this fails can i send something
back through bpstart so the backup doesnt run and fails with a certain
netbackup code?
The benefit of the mount, unmount is so the resource is not used on the db
servers to do backups, but im not sure how i am going to control the process
within netbackup to capture any errors. So has anyone done anything similar
which they can advise with??
Thanks
Dave
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
This email is for the intended addressee only.
If you have received it in error then you must not use, retain, disseminate or
otherwise deal with it.
Please notify the sender by return email.
The views of the author may not necessarily constitute the views of EADS
Astrium Limited.
Nothing in this email shall bind EADS Astrium Limited in any contract or
obligation.
EADS Astrium Limited, Registered in England and Wales No. 2449259
Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England
|
