David Jurke wrote:
> The DBAs are already talking about partitioning and making the older
> tablespaces read-only and only backing them up weekly or fortnightly or
> whatever, which solves the problem for the daily backups but still leaves
> us with a weekly/fortnightly backup which won't fit in th
take a look at
http://www.oracle.com/technology/deploy/availability/pdf/oracle-openworld-2007/S291487_1_Chien.pdf
Backup and Recovery Best Practices for Very Large Databases (VLDBs)
Regards
D.
-
This SF.Net email is sponso
2008/11/27 David Jurke <[EMAIL PROTECTED]>
> Whoa!
>
>
>
> Okay, I need to go talk to the DBAs about this lot, lots of it is too far
> on the DBA side for me to comment intelligently on it. It does sound
> promising, though - if we back up daily only the current month's data (the
> rest will be i
inal Message-
From: Kjetil Torgrim Homme [mailto:[EMAIL PROTECTED]
Sent: Thursday, 27 November 2008 16:56
To: bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] How to set up large database backup
"David Jurke" <[EMAIL PROTECTED]> writes:
> I think it'd need
"David Jurke" <[EMAIL PROTECTED]> writes:
> Basically, as I understand it, your first group of comments are
> about not backing up empty space, as per your example if there is
> only 10GB data in a 100GB data file. However, our database is
> growing rapidly, and our DBAs tend to allocate smaller t
"David Jurke" <[EMAIL PROTECTED]> writes:
> I think it'd need some tweaking to delay putting each tablespace
> into backup mode until Bacula is ready to back it up - one of the
> problems I have is that we can't put all the tablespaces into backup
> mode at the same time because of the volume of l
:[EMAIL PROTECTED]
Sent: Wednesday, 26 November 2008 23:00
To: David Jurke
Cc: bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] How to set up large database backup
2008/11/25 David Jurke <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Hiya David,
I'm assured by our DBAs
etil Torgrim Homme [mailto:[EMAIL PROTECTED]
Sent: Thursday, 27 November 2008 14:17
To: bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] How to set up large database backup
I thought I'd get back to the original question :-)
"David Jurke" <[EMAIL PROTECTED]> write
I thought I'd get back to the original question :-)
"David Jurke" <[EMAIL PROTECTED]> writes:
> The problem I have is with our large (expected to grow to several
> terabytes) [Oracle] server. I’m told by the DBAs that the size and
> amount of activity on this database is such that putting the who
Hemant Shah wrote:
> How about exporting/dumping one table at a time and then backing up the
> exported data using bacula.
Unfortunately, export is not really suitable for a DR solution. The main
reason is that each table is exported at a different time, and so the
complex relationships between in
2008/11/25 David Jurke <[EMAIL PROTECTED]>
> Hiya David,
>
> I'm assured by our DBAs that this one-tablespace-at-a-time method works -
> it's apparently what Oracle recommend, and they do restores and recovers
> frequently for things like creating test databases, so it's a proven method.
> It coul
acula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] How to set up large database backup
> This is equivalent to what we're doing now, but we're sort of one step up
> in the hierarchy - backing up one tablespace at a time.
>
> You don't say whether you mean to ba
> This is equivalent to what we're doing now, but we're sort of one step up
> in the hierarchy - backing up one tablespace at a time.
>
> You don't say whether you mean to back up each table to tape as it's
> produced, or back them all up at the end when they've all been copied.
>
> Either way, the
--- 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&q
: Hemant Shah [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 26 November 2008 10:44
To: James Cort; David Jurke
Cc: bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] How to set up large database backup
--- On Tue, 11/25/08, David Jurke <[EMAIL PROTECTED]> wrote:
> From: D
On Nov 25, 2008, at 2:03 PM, David Jurke wrote:
> Hiya Dan,
>
> I'm not a DBA, so I don't know the internal details, but to do a hot
> backup with Oracle you have to put it into hot backup mode, take a
> copy of the data files, take it out of backup mode, switch logs, and
> back up all the
allester [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 26 November 2008 08:02
To: David Jurke; bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] How to set up large database backup
El dt 25 de 11 del 2008 a les 13:12 -0500, en/na Dan Langille va
escriure:
> On Nov 25, 2008, at 2:10 AM, Davi
From: Dan Langille [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 26 November 2008 07:12
To: David Jurke
Cc: bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] How to set up large database backup
On Nov 25, 2008, at 2:10 AM, David Jurke wrote:
> The problem I have is with our large (
El dt 25 de 11 del 2008 a les 13:12 -0500, en/na Dan Langille va
escriure:
> On Nov 25, 2008, at 2:10 AM, David Jurke wrote:
>
> > The problem I have is with our large (expected to grow to several
> > terabytes) database server. I’m told by the DBAs that the size and
> > amount of activity on
El dc 26 de 11 del 2008 a les 07:34 +1300, en/na David Jurke va
escriure:
> 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
Dan Langille wrote:
> There is no way to dump interactively? I'm a PostgreSQL fan and
> creating a backup doesn't add overhead.
And using PITR, postgresql even allows you to fetch out the raw database
files from underneath a running (and active with insert/updates)
postgresql instance. This i
s 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:
>
On Nov 25, 2008, at 2:10 AM, David Jurke wrote:
> The problem I have is with our large (expected to grow to several
> terabytes) database server. I’m told by the DBAs that the size and
> amount of activity on this database is such that putting the whole
> database into hot backup mode for t
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 g
Hi,
25.11.2008 09:58, Bruno Friedmann wrote:
> Hi David, just a little remark.
>
> In such situation, I would ask the question to how get a slave db server
> running
> and I would save this slave with whatever is the best for dumping the
> database.
Same idea here.
Two more things to consider
Hi David, just a little remark.
In such situation, I would ask the question to how get a slave db server running
and I would save this slave with whatever is the best for dumping the database.
It also improve general availability for the enterprise db
(If you consume 12hours for backups, how muc
Hiya,
We have a classic enterprise-type backup setup - a number of "clients" backing
up across the network to a tape library attached to a dedicated backup host.
This is the easy bit, and works quite happily.
The tape library is an IBM TS3310 30-tape, 2-drive unit, "attached" to the
backup hos
27 matches
Mail list logo