Re: [Bacula-users] Problem with tape capacity

2008-11-25 Thread Arno Lehmann
Hi, 25.11.2008 22:24, Willians Vivanco wrote: > Hi, i'm trying to make work Bacula in Debian/Lenny with a HP > StorageWorks TapeLibrary MSL6000 and HP LTO3-Ultrium tapes of 800 Gb of > capacity each one... I'm having some advances in the last days... But > now, during the execution of the te

[Bacula-users] OT: a new phrase is born ??

2008-11-25 Thread Masopust, Christian
The following is from "How to set up large database backup": through all the tablespaces and <= bacula them => straight across the network to tape. it's funny as it also happend to me some time when talking about our backup that i told my co-workers, managers,... that we "bacula it

Re: [Bacula-users] How to set up large database backup

2008-11-25 Thread David Jurke
Thanks Jeff, Now that would be really cool... if our SAN were smart enough to do snapshots. Sadly, this is not the case. It's large, but not very smart. Cheers, David. -Original Message- From: Jeff Kalchik [mailto:[EMAIL PROTECTED] Sent: Wednesday, 26 November 2008 15:47 To: bacula-u

Re: [Bacula-users] Bacula can't append to tapes

2008-11-25 Thread David Jurke
Further update: some couple of hours later, it finished the btape test, failed with the same set of messages as below. Cheers, DJ From: David Jurke [mailto:[EMAIL PROTECTED] Sent: Wednesday, 26 November 2008 12:01 To: bacula-users@lists.sourceforge.net Subject: R

Re: [Bacula-users] How to set up large database backup

2008-11-25 Thread Jeff Kalchik
> 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

Re: [Bacula-users] Bacula can't append to tapes

2008-11-25 Thread David Jurke
Update: after 30 minutes, btape test has moved on a step. Watch this space... DJ From: David Jurke Sent: Wednesday, 26 November 2008 11:30 To: David Jurke; 'bacula-users@lists.sourceforge.net' Subject: RE: Bacula can't append to tapes One more bit of information

[Bacula-users] Problem with tape capacity

2008-11-25 Thread Willians Vivanco
Hi, i'm trying to make work Bacula in Debian/Lenny with a HP StorageWorks TapeLibrary MSL6000 and HP LTO3-Ultrium tapes of 800 Gb of capacity each one... I'm having some advances in the last days... But now, during the execution of the test under the btape shell, when i run the "fill" test,

Re: [Bacula-users] Bacula can't append to tapes

2008-11-25 Thread David Jurke
One more bit of information... I added "Two EOF = yes" to the tape device config, and re-ran the btape test: - *test === Write, rewind, and re-read test === I'm going to write 1000 records and an EOF then write 1000 records and an EOF, then rewind, and re-read the dat

[Bacula-users] Bacula can't append to tapes

2008-11-25 Thread David Jurke
Hiya Bacula-Users, I have a number of clients backing up across the network to a dedicated Bacula backup server. We have an IBM TS3310 (two drives and 30 tape cartridges) attached to our SAN and presented to the backup server, appearing as three SCSI IDs. The problem I have is that Bacula has

Re: [Bacula-users] How to set up large database backup

2008-11-25 Thread Hemant Shah
--- 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" > Date: Tuesday, November 25, 2008, 12:34 PM >

Re: [Bacula-users] How to set up large database backup

2008-11-25 Thread David Jurke
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, there's probl

Re: [Bacula-users] Relabel full tape

2008-11-25 Thread John Drescher
> There's no way I known. > The label is inside the head volume .. > http://www.bacula.org/manuals/en/developers/developers/Overall_Storage_Format.html I believe this is difficult to impossible to do nondestructively if the tape is compressed (which it should be). The reason is even if you could r

Re: [Bacula-users] Relabel full tape

2008-11-25 Thread David Jurke
Or clone (bcopy?) the tape to a new tape with the right label. For your own sanity, I'd suggest you stick a label on the tape, give Bacula the same name to put on the tape, and leave it that way. My guess is you have a bunch of "spare" tapes that get sucked in as required, yes? In which case I'd

Re: [Bacula-users] Solaris "Packet size too big" failures

2008-11-25 Thread Jason Dixon
Just a quick bump. Perhaps I should open a bug report? Thanks, Jason On Mon, Nov 24, 2008 at 11:59:36AM -0500, Jason Dixon wrote: > We moved our Bacula Director off Linux to Solaris (not my choice) > recently. Since then, we've encountered frequent failures of the > catalog backup job which rea

Re: [Bacula-users] Relabel full tape

2008-11-25 Thread Bruno Friedmann
Gaspare Siclari wrote: > Hi All, > > Probably this discussion has been already confronted. > Here's my situation: > > I have stored the data in a tape labeled scratch001. > This tape is full by now. > > By policy, I have to change the name in backup001. > Afer reading pre

[Bacula-users] Large Oracle backup best-practice

2008-11-25 Thread David Jurke
Thanks Dan, good suggestion, subject duly changed... Our DBAs are well aware of the implications of disaster recovery, we have another site with DR hardware, which in the long term will have a hot-standby database with logs shipped up to it and suchlike. For various reasons (don't ask; not the

Re: [Bacula-users] How to set up large database backup

2008-11-25 Thread Dan Langille
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

Re: [Bacula-users] Bacula-users Digest, Vol 31, Issue 38

2008-11-25 Thread David Jurke
Hiya Bruno, Arno, I wasn't as clear as I should have been... the database I'm trying to back up isn't the Bacula database, it's an Oracle database containing a lot (700GB so far, expected to grow to about ten times that) of business data. Also, FYI, the Oracle-recommended backup process is to b

Re: [Bacula-users] How to set up large database backup

2008-11-25 Thread David Jurke
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 could be that my description of the process was rather l

Re: [Bacula-users] How to set up large database backup

2008-11-25 Thread David Jurke
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 log files. Then at restore time you restore all the data files a

Re: [Bacula-users] How to set up large database backup

2008-11-25 Thread David Ballester
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

Re: [Bacula-users] How to set up large database backup

2008-11-25 Thread David Ballester
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

Re: [Bacula-users] How to set up large database backup

2008-11-25 Thread Jesper Krogh
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

Re: [Bacula-users] How to set up large database backup

2008-11-25 Thread David Jurke
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 th

[Bacula-users] FW: Disk to Disk to Tape

2008-11-25 Thread Martin Hengst
-Original Message- From: Martin Hengst Sent: Tuesday, November 25, 2008 1:30 PM To: 'John Drescher' Subject: RE: [Bacula-users] Disk to Disk to Tape >In bconsole > >list volumes > >and find the last written volume > >Then go to your storage and copy the file. Probably with the cp >command

[Bacula-users] Fwd: Disk to Disk to Tape

2008-11-25 Thread John Drescher
-- Forwarded message -- From: John Drescher <[EMAIL PROTECTED]> Date: Tue, Nov 25, 2008 at 1:25 PM Subject: Re: [Bacula-users] Disk to Disk to Tape To: Martin Hengst <[EMAIL PROTECTED]> On Tue, Nov 25, 2008 at 11:44 AM, Martin Hengst <[EMAIL PROTECTED]> wrote: > In our Bacula setu

Re: [Bacula-users] How to set up large database backup

2008-11-25 Thread Dan Langille
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

[Bacula-users] Relabel full tape

2008-11-25 Thread Gaspare Siclari
Hi All, Probably this discussion has been already confronted. Here's my situation: I have stored the data in a tape labeled scratch001. This tape is full by now. By policy, I have to change the name in backup001. Afer reading precedent threads I have noticed that the rela

[Bacula-users] Disk to Disk to Tape

2008-11-25 Thread Martin Hengst
In our Bacula setup, we're currently backing up several servers to a pool of three large volumes on a RAID array. These volumes are set to auto-recycle and are limited to 250gb in size. Typically, each volume holds at least one full backup and several days worth of differentials before it hits t

[Bacula-users] BUG? Bconsole/bgnome-console

2008-11-25 Thread Alan Brown
Bacula 2.4.2, 64 bit, RHEL5 This is wierd, to say the least. I have a subset of files in a directory I want to restore. The directory doesn't show up in bconsole or in command line mode using bgnome console but DOES does show up in the GUI-restore function on the same bgnome console at the same

Re: [Bacula-users] Problem adding second storage daemon

2008-11-25 Thread Misty Stanley-Jones
Hi Arno, > -Original Message- > From: Arno Lehmann [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 25, 2008 4:40 AM > To: bacula-users@lists.sourceforge.net > Subject: Re: [Bacula-users] Problem adding second storage daemon > > Hello, > > > Well, the error message only tells us a b

Re: [Bacula-users] Windows XP networking dies

2008-11-25 Thread Alan Brown
On Mon, 24 Nov 2008, Josh Fisher wrote: > I ran into this with a couple of Vista laptops, and also with a > nForce430 chipset XP machine. I have found it is not uncommon for > Windows NIC drivers to be buggy. Not just Windows. We found that 3com Torando/Vortex/Boomerang family cards will start b

Re: [Bacula-users] How to set up large database backup

2008-11-25 Thread James Cort
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

Re: [Bacula-users] ERR=Could not mount DVD device

2008-11-25 Thread Nils Blanck-Wehde
Hi Jari, I configured sudo that no password is needed for user "bacula" to run mount and unmount. The corresponding line from /etc/sudoers is: bacula ALL = (ALL) NOPASSWD: /bin/mount, /bin/umount Nils Jari Fredriksson schrieb: Hello list! I am running bacula 2.4.2 from fschwarz's EL5 rpms

Re: [Bacula-users] ERR=Could not mount DVD device

2008-11-25 Thread Jari Fredriksson
> Hello list! > > I am running bacula 2.4.2 from fschwarz's EL5 rpms on > CentOS 5.2 > > > My mount command (from storage definition) is: > "/usr/bin/sudo /bin/mount -t iso9660 -o ro %a %m" > I can mount and unmount the dvd-writer as user bacula with > "/usr/bin/sudo /bin/mount -t iso9660 -

Re: [Bacula-users] How to set up large database backup

2008-11-25 Thread Arno Lehmann
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

Re: [Bacula-users] Problem adding second storage daemon

2008-11-25 Thread Arno Lehmann
Hello, 24.11.2008 15:35, Misty Stanley-Jones wrote: > I have been using the same Bacula config for about three years now. > Recently, due to a network change, it is not feasible for me to store one > client's backup on the normal storage daemon, so I am trying to create a > second storage daemon o

Re: [Bacula-users] wrong SD device displayed

2008-11-25 Thread Arno Lehmann
Hi, 23.11.2008 03:21, Maxime wrote: > Hello, > > Recently I had to restore data from purged volumes that hadn't been > recycled hopefully. It's files on hard drives. > I rebuild the catalog with bscan. > And I launch restoration jobs. > > In bacula-sd.conf, we can find : > <

Re: [Bacula-users] How to set up large database backup

2008-11-25 Thread Bruno Friedmann
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