--- On Tue, 11/25/08, David Jurke <[EMAIL PROTECTED]> wrote:
> From: David Jurke <[EMAIL PROTECTED]> > Subject: Re: [Bacula-users] How to set up large database backup > To: "James Cort" <[EMAIL PROTECTED]> > Cc: "bacula-users@lists.sourceforge.net" <bacula-users@lists.sourceforge.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:[EMAIL PROTECTED] > Sent: Wednesday, 26 November 2008 00:02 > To: David Jurke > Cc: bacula-users@lists.sourceforge.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@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users Hemant Shah E-mail: [EMAIL PROTECTED] ------------------------------------------------------------------------- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users