--- On Tue, 11/25/08, David Jurke <David.Jurke AT tnzi DOT com> wrote:

> From: David Jurke <David.Jurke AT tnzi DOT com>
> Subject: Re: [Bacula-users] How to set up large database backup
> To: "James Cort" <james.cort AT u4eatech DOT com>
> Cc: "bacula-users AT lists.sourceforge DOT net" <bacula-users AT 
> lists.sourceforge DOT net>
> Date: Tuesday, November 25, 2008, 12:34 PM
> Thanks James,
> 
> Sorry, missed that bit... Oracle on Linux. The database is,
> as you say, for the business, hence the need to back it up!
> 

  How about exporting/dumping one table at a time and then backing up the 
exported data using bacula.

> And sadly no, our SAN doesn't support snapshots, or for
> sure I'd have been doing that! Likewise I don't have
> the option of breaking RAID mirrors and doing it that way.
> 
> 
> Cheers,
> 
> David.
> 
> -----Original Message-----
> From: James Cort [mailto:james.cort AT u4eatech DOT com] 
> Sent: Wednesday, 26 November 2008 00:02
> To: David Jurke
> Cc: bacula-users AT lists.sourceforge DOT net
> Subject: Re: [Bacula-users] How to set up large database
> backup
> 
> David Jurke wrote:
> > 
> > The method we're using for now is to back up the
> database by copying it
> > to disk on the backup server (via NFS), and then back
> that up to tape.
> > Trouble is, this is handling the data twice, and is
> currently taking
> > well over twelve hours all up, which given the
> expected growth is going
> > to become untenable fairly soon, so any suggestions
> gratefully received!
> > Not to mention we're going to run out of disk
> space!!
> 
> You don't mention what OS or DBMS the database is,
> given the context I'm
> assuming it's for some other business process than
> Bacula.
> 
> Does the SAN support snapshots?  You could always take a
> snapshot, back
> it up and then remove the snapshot afterwards.  There may
> need to be
> some scripting to make sure the database is in a consistent
> state before
> you do this, but it'd be a lot quicker than copying the
> data.
> 
> -- 
> James Cort
> 
> IT Manager
> U4EA Technologies Ltd.
> 
> -- 
> U4EA Technologies
> http://www.u4eatech.com
> 
> 
> 
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move
> Developer's challenge
> Build the coolest Linux based applications with Moblin SDK
> & win great prizes
> Grand prize is a trip for two to an Open Source event
> anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users



Hemant Shah
E-mail: hjrrs AT yahoo DOT com



      

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users