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

2008-11-26 Thread David Ballester
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 could be

Re: [Bacula-users] Problem with tape capacity

2008-11-26 Thread Alan Brown
On Tue, 25 Nov 2008, 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... Nit: LTO3 is 400Gb capacity. Any more than that is opportunistic based on compressability of

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

2008-11-26 Thread Mike Holden
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

Re: [Bacula-users] LTO3 Tapes how long useable?

2008-11-26 Thread John Drescher
On Wed, Nov 26, 2008 at 6:14 AM, Ralf Prengel [EMAIL PROTECTED] wrote: Hallo, hast anyone a link etc. how often LTO3 Tapes can be overwritten? http://en.wikipedia.org/wiki/Linear_Tape-Open#Tape_durability John - This

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

2008-11-26 Thread Jason Dixon
On Wed, Nov 26, 2008 at 11:59:41AM +0100, Kshatriya wrote: On Mon, 24 Nov 2008, 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 reads from the local FD. They

[Bacula-users] Strange problem using label command when doing a schedule backup

2008-11-26 Thread Luis Marcelo Achite
Hi, I´m facing a strange problem with bacula 2.4.3 and 2.4.2 versions. When a backup begin and there is no label available for backup, label is not working properly and I receive an error message. The most strange part is that after this tentative, I can no use the drive anymor, as bacula informs

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

2008-11-26 Thread Kshatriya
On Mon, 24 Nov 2008, 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 reads from the local FD. They always fail with a Packet size too big error, which seems to be

[Bacula-users] LTO3 Tapes how long useable?

2008-11-26 Thread Ralf Prengel
Hallo, hast anyone a link etc. how often LTO3 Tapes can be overwritten? -- i.A. Ralf Prengel Customer Care Manager Comline AG Hauert 8 D-44227 Dortmund/Germany Fon +49231 97575- 904 Fax +49231 97575- 905 EMail [EMAIL PROTECTED] -- www.comline.de Vorstand Stephan Schilling, Erwin Leonhardi

[Bacula-users] new jobs blocked when despooling

2008-11-26 Thread Jakob Bratkovic
Hi, I'm having some problems with spooling and despooling system. Essentially a job that gets queued while another job is already despooling will wait until despooling is finished and then only will it start spooling. The backup process is as follows: *run a ClientRunBeforeJob script,

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

2008-11-26 Thread Martin Hengst
I have realized disk2disk2tape by migrating jobs (see manual: http://www.bacula.org/en/dev-manual/Migration.html). By doing so you can configure something like this: client with file daemon (and the files you want to backup) backserver with director daemon, storage daemon and file daemon. 1. you

[Bacula-users] encrypting 5gb bacula backup files?

2008-11-26 Thread Lukasz Szybalski
Hello, I was wondering if somebody could suggest a fast encryption algorithm that I could use to encrypt 5gb files. What I'm trying to do is create backup files on amazon S3 servers which allow you to upload up to 5bg per files. I can tell bacula to use 5gb files, which I would like to encrypt.

Re: [Bacula-users] Problem with tape capacity

2008-11-26 Thread Arno Lehmann
Hi, the list, please... or do you want a support contract? ;-) 26.11.2008 15:06, Willians Vivanco wrote: Arno Lehmann wrote: 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

[Bacula-users] bacula hang waiting for storage

2008-11-26 Thread Bob Hetzel
I've got bacula currently in a hung state with the following interesting info. When I run a status storage produces the following... Automatically selected Storage: Dell-PV136T Connecting to Storage daemon Dell-PV136T at gyrus:9103 gyrus-sd Version: 2.4.3 (10 October 2008) i686-pc-linux-gnu

[Bacula-users] Do i need to initializate the tapes?

2008-11-26 Thread Willians Vivanco
Hi... I'm using a tape library HP StorageWorks MSL600 series with LTO3-Ultrium tapes... So can anybody tell me if i need to make some kind of initialization, formatting or some other specific action over my tapes before start using it? Regards --- Red

Re: [Bacula-users] Do i need to initializate the tapes?

2008-11-26 Thread John Drescher
On Wed, Nov 26, 2008 at 4:18 PM, Willians Vivanco [EMAIL PROTECTED] wrote: Hi... I'm using a tape library HP StorageWorks MSL600 series with LTO3-Ultrium tapes... So can anybody tell me if i need to make some kind of initialization, formatting or some other specific action over my tapes

Re: [Bacula-users] Do i need to initializate the tapes?

2008-11-26 Thread John Drescher
So... Why my Bacula recognize just 64Kb on each tape? Some suggestion? I don't know what to do... Some kind of hardware or driver problem. Does your os have device nodes for /dev/nst0 ? Are there any errors in your dmesg output? John

Re: [Bacula-users] Do i need to initializate the tapes?

2008-11-26 Thread Dan Langille
John Drescher wrote: On Wed, Nov 26, 2008 at 4:18 PM, Willians Vivanco [EMAIL PROTECTED] wrote: Hi... I'm using a tape library HP StorageWorks MSL600 series with LTO3-Ultrium tapes... So can anybody tell me if i need to make some kind of initialization, formatting or some other specific

Re: [Bacula-users] Do i need to initializate the tapes?

2008-11-26 Thread John Drescher
On Wed, Nov 26, 2008 at 5:16 PM, Willians Vivanco [EMAIL PROTECTED] wrote: John Drescher wrote: So... Why my Bacula recognize just 64Kb on each tape? Some suggestion? I don't know what to do... Some kind of hardware or driver problem. Does your os have device nodes for /dev/nst0 ? Are

Re: [Bacula-users] Do i need to initializate the tapes?

2008-11-26 Thread John Drescher
On Wed, Nov 26, 2008 at 5:23 PM, Willians Vivanco [EMAIL PROTECTED] wrote: John Drescher wrote: On Wed, Nov 26, 2008 at 5:16 PM, Willians Vivanco [EMAIL PROTECTED] wrote: John Drescher wrote: So... Why my Bacula recognize just 64Kb on each tape? Some suggestion? I don't know what to

Re: [Bacula-users] Do i need to initializate the tapes?

2008-11-26 Thread John Drescher
Could it be cause a wrong scsi connection in the tape library? Not likely. John - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK

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

2008-11-26 Thread Kjetil Torgrim Homme
Jason Dixon [EMAIL PROTECTED] writes: On Wed, Nov 26, 2008 at 11:59:41AM +0100, Kshatriya wrote: On Mon, 24 Nov 2008, 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

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

2008-11-26 Thread Kjetil Torgrim Homme
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 whole

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

2008-11-26 Thread David Jurke
Thanks Kjetilho, Sounds ingenious! 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 logs

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

2008-11-26 Thread David Jurke
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 in static partitions), only the weekly(?) full backup

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

2008-11-26 Thread Kjetil Torgrim Homme
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 logs

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

2008-11-26 Thread David Jurke
Ah, yes, you're right, I'm with you now. You're kicking off a whole lot of parallel opens which all block, then get unblocked one at a time as Bacula starts reading them, at which point the tablespace is altered and the file copied to the FIFO and hence to tape. I hadn't clicked that the

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

2008-11-26 Thread Kjetil Torgrim Homme
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

Re: [Bacula-users] bacula hang waiting for storage

2008-11-26 Thread Arno Lehmann
Hi, 26.11.2008 21:22, Bob Hetzel wrote: I've got bacula currently in a hung state with the following interesting info. When I run a status storage produces the following... Is your Bacula still stuck? If so, and you have gdb installed, and a Bacula with debug symbols, now might be a good