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!
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
|
