Re: [Bacula-users] autochanger and barcode
Hi, 21.10.2009 12:43, Nicola Quargentan wrote: Jari Fredriksson ha scritto: 20.10.2009 2:25, Nicola Quargentan kirjoitti: With this metode I'm unable to know where is my data in my volumes (only bacula know that). Ad absurdum I could end up finding a piece of data of single server stored in each of 24 tapes :O (IMHO). Bacula knows, and tells it to you with a query. cut... Bacula does not need a tape in order to make a query into it. Unlike many other simpler backup systems may do. You make a query, and *then* get the tape into your hand. Not the other way round. Simple. This is good, but the problem remains the fact of I not being able to pull out a single tape from the autochanger and store it in another safe place (under my bed !). Why not? You use bconsole or a customized script to find volumes you want to unload and store safely. You - or the script - marks those volumes as Used that are in that list and still in state Append. Then unmount or release the autochanger tapes. Optionally, re-order volumes in the library to put the ones to be unloaded into import/export slots Manually unload the volumes, and - manually or automatically - issue an 'update slots' command, so Bacula knows about the re-ordered volumes, and ones you probably loaded into the autochanger. I've got a scriot to do most of that work, but it's customized to some special needs, but if you want it send me an email! Cheers, Arno Thanks. -- Arno Lehmann IT-Service Lehmann Sandstr. 6, 49080 Osnabrück www.its-lehmann.de -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] autochanger and barcode
Jari Fredriksson ha scritto: 20.10.2009 2:25, Nicola Quargentan kirjoitti: With this metode I'm unable to know where is my data in my volumes (only bacula know that). Ad absurdum I could end up finding a piece of data of single server stored in each of 24 tapes :O (IMHO). Bacula knows, and tells it to you with a query. cut... Bacula does not need a tape in order to make a query into it. Unlike many other simpler backup systems may do. You make a query, and *then* get the tape into your hand. Not the other way round. Simple. This is good, but the problem remains the fact of I not being able to pull out a single tape from the autochanger and store it in another safe place (under my bed !). Thanks. -- Nicola Quargentan -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] autochanger and barcode
20.10.2009 2:25, Nicola Quargentan kirjoitti: With this metode I'm unable to know where is my data in my volumes (only bacula know that). Ad absurdum I could end up finding a piece of data of single server stored in each of 24 tapes :O (IMHO). Bacula knows, and tells it to you with a query. *query Automatically selected Catalog: MyCatalog Using Catalog MyCatalog Available queries: 1: List up to 20 places where a File is saved regardless of the directory 2: List where the most recent copies of a file are saved 3: List last 20 Full Backups for a Client 4: List all backups for a Client after a specified time 5: List all backups for a Client 6: List Volume Attributes for a selected Volume 7: List Volumes used by selected JobId 8: List Volumes to Restore All Files 9: List Pool Attributes for a selected Pool 10: List total files/bytes by Job 11: List total files/bytes by Volume 12: List Files for a selected JobId 13: List Jobs stored on a selected MediaId 14: List Jobs stored for a given Volume name 15: List Volumes Bacula thinks are in changer 16: List Volumes likely to need replacement from age or errors Choose a query (1-16): Bacula does not need a tape in order to make a query into it. Unlike many other simpler backup systems may do. You make a query, and *then* get the tape into your hand. Not the other way round. Simple. -- http://www.iki.fi/jarif/ Your heart is pure, and your mind clear, and your soul devout. pgpQE5oHq9Lui.pgp Description: PGP signature -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] autochanger and barcode
Arno Lehmann ha scritto: Hi, 16.10.2009 18:45, Nicola Quargentan wrote: Bob Hetzel ha scritto: ... Forget about trying to keep straight which tape is for which day and let bacula track that for you. When you need to do a restore, let bacula tell you which volumes that data is on. I'm not fully persuased about bacula. I fear that the database (MySQL) become corrupted. cut... In short, the catalog *any* serious backup solution provides is essential, and you've simply got to trust it. Bacula's catalog is one of the more robust versions of such a catalog, and thus it's unlikely any alternative will work more considerably reliable. That's Ok. I also saw the default job BackupCatalog in bacula config file. Now, I am convinced to use the catalog. Thanks. -- Nicola Quargentan -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] autochanger and barcode
Jesper Krogh ha scritto: But the use of pools on what for? Just for completeness I must save this data: 1) Oracle db (size unknown) 2) 5-6 MySQL db (about 25 Gb) 3) Some samba share, with office files (5Gb) 4) An subversion reposity (size unknown) 5) Mail server (size unknown) 6) The configuration of 8 servers 7) Other things that now I do not remember :) I should make a pool for each points? No, you should make the pools reflect your retention times. If you wish to keep (which you most-likely will) your Full backups for longer time than your incrementals. Recycling of volumes is based on the lastwritten time of the volume. I suggest: Full-Poll = All full backups. Incremental-Pool = All incremental backups. Differential-Poll = All Differential backups. You would then prefer to keep full backups for the longest period, Differentials for a shorter and incrementals for even shorter. I our setup we keep Full for 1y, Differential for 1y and Incremental for 6m. This enables us to: * restore any file with a days granularity for 6 months. * restore any file wiht a weeks granularity for 1 year. * - then we actually have an Archive Pool that week is backed up to ever 6 months that we keep forever. If you then dont want to have a open tape for longer than a period, then you set Max Use Duration to that. Then after that period of time you can move it to a different location. If your retention times change across above systems, then you most likely need more pools. But I would definately suggest just buying one more pack of tapes instead. With this metode I'm unable to know where is my data in my volumes (only bacula know that). Ad absurdum I could end up finding a piece of data of single server stored in each of 24 tapes :O (IMHO). I also read this tutorial: http://www.bacula.org/fr/dev-manual/Backup_Strategies.html But now I think to make a pool for each server, set Maximum Volume Jobs = 1, and perform only incremental backups. Thanks, Nicola. -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] autochanger and barcode
But the use of pools on what for? Just for completeness I must save this data: 1) Oracle db (size unknown) 2) 5-6 MySQL db (about 25 Gb) 3) Some samba share, with office files (5Gb) 4) An subversion reposity (size unknown) 5) Mail server (size unknown) 6) The configuration of 8 servers 7) Other things that now I do not remember :) I should make a pool for each points? No, you should make the pools reflect your retention times. If you wish to keep (which you most-likely will) your Full backups for longer time than your incrementals. Recycling of volumes is based on the lastwritten time of the volume. I suggest: Full-Poll = All full backups. Incremental-Pool = All incremental backups. Differential-Poll = All Differential backups. You would then prefer to keep full backups for the longest period, Differentials for a shorter and incrementals for even shorter. I our setup we keep Full for 1y, Differential for 1y and Incremental for 6m. This enables us to: * restore any file with a days granularity for 6 months. * restore any file wiht a weeks granularity for 1 year. * - then we actually have an Archive Pool that week is backed up to ever 6 months that we keep forever. If you then dont want to have a open tape for longer than a period, then you set Max Use Duration to that. Then after that period of time you can move it to a different location. If your retention times change across above systems, then you most likely need more pools. But I would definately suggest just buying one more pack of tapes instead. Jesper -- Jesper -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] autochanger and barcode
Nicola Quargentan wrote: Jesper Krogh ha scritto: Nicola Quargentan wrote: I'm very newbie and I want to use a DELL TL2000 autochanger. I made 7 pool in config file, one for each day of week: Monday, Tuesday, etc. Monday, Tuesday and so is mostly used when you dont have an autochanger. Oh you are right: before autochanger I have only a single tape drive, and I change the tape every day :O When you do have one I recommend setting up Pools so then reflect your retention policies. In my setup we: * Keep full backups for a year (run monthly) * Keep differential backups for a year (run weekly) * Keep incremental backups for 6 months (run daily). This translates into 3 Pools, Full, Differential and Incremental. On these pools the retentiontime is set and then automatically move back to Scratch-pool when retention-time has expired. So all fresh volumes just goes directly into Scratch pool. Bacula will try to fill tapes completely e.g. fill mondays's tape with tuesdays data if not explicitly configured otherwise. Uhmm, I want to be indipendent from bacula. My purpose is to occasionally carry out my tapes, and store them on a strongbox :) If my backup bacula server crash I don't want lose all my data. So I want to know where bacula store my data. Then I'd suggest that you run mysqldump on the catalog and burn it to a CD or similar occationally. I have a small perl-script that can process the catalog and give a list of files/timestamps/paths/clients stored on a volume .. (can give information for use with bextract if needed). Would that have any interest? -- Jesper -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] autochanger and barcode
Nicola, If you're using barcodes you can greatly simplify what you're doing. Instead of using one pool per day, just use one pool for all backups and one scratch pool. Place all the tapes in the scratch pool. Forget about trying to keep straight which tape is for which day and let bacula track that for you. When you need to do a restore, let bacula tell you which volumes that data is on. Set volume retention, job retention, file retention, and volume use duration if you find that you don't fill up a tape as fast as you would like, then if you wanted to do some inchanger-out of changer tape rotation, periodically remove tapes marked Full or Used. To label them do 'label barcodes slots=first-last substituting the slot numbers for the first and last slots holding the tapes to be labelled. Bob From: Nicola Quargentan nic...@quargentan.com Subject: [Bacula-users] autochanger and barcode To: bacula-users@lists.sourceforge.net Message-ID: 4ad79c49.3080...@quargentan.com Content-Type: text/plain; charset=ISO-8859-15; format=flowed hi, I'm very newbie and I want to use a DELL TL2000 autochanger. I made 7 pool in config file, one for each day of week: Monday, Tuesday, etc. I want to use one volume for day and label it same as barcode. When I tried label barcode I must to put all tape in only one pool: *label barcode The defined Storage resources are: 1: File 2: autochanger Select Storage resource (1-2): 2 Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... 3306 Issuing autochanger slots command. Device tape-burp-LTO4 has 23 slots. Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... 3306 Issuing autochanger list command. The following Volumes will be labeled: Slot Volume == 1 GDV100L4 5 GDV101L4 6 GDV102L4 12 GDV107L4 13 GDV105L4 14 GDV104L4 15 GDV103L4 16 GDV106L4 Do you want to label these Volumes? (yes|no): yes Defined Pools: 1: Scratch 2: FullTest 3: DiffTest 4: IncrTest 5: Default 6: Monday 7: Tuesday 8: Wednesday 9: Thursday 10: Friday 11: Saturday 12: Sunday Select the Pool (1-12): . So I cannot put the volume GDV100L4 in Monday, GDV101L4 in Tuesday etc. I tried also to put all volumes in Scratch pool, but bacula return a lot of messages: Cannot label Volume because it is already labeled. 1) Is there a clue to add one volume labeled by barcode to a single pool? 2) How I can relabel the volumes (I found a bad clue on the web: erase every tapes manually :( ). Thanks, Nicola. -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] autochanger and barcode
If you're using barcodes you can greatly simplify what you're doing. Instead of using one pool per day, just use one pool for all backups and one scratch pool. Place all the tapes in the scratch pool. BTW, I definitely agree with this. It's best not to have 1 pool per day if you do not really need that. Having this many pools is going to reduce the number autochanger slots you have available. At minimum 7 slots will have partially used tapes at all times and if you have any retention period this will use at least 14 slots when the first volume of each pool is full. John -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] autochanger and barcode
John Drescher ha scritto: On Thu, Oct 15, 2009 at 7:48 PM, Nicola Quargentan nic...@quargentan.com wrote: John Drescher ha scritto: On Thu, Oct 15, 2009 at 6:03 PM, Nicola Quargentan nic...@quargentan.com wrote: hi, I'm very newbie and I want to use a DELL TL2000 autochanger. I made 7 pool in config file, one for each day of week: Monday, Tuesday, etc. I want to use one volume for day and label it same as barcode. When I tried label barcode I must to put all tape in only one pool: cut Uhm, ok, but how? *update volume Parameters to modify: 1: Volume Status 2: Volume Retention Period 3: Volume Use Duration 4: Maximum Volume Jobs 5: Maximum Volume Files 6: Maximum Volume Bytes 7: Recycle Flag 8: Slot 9: InChanger Flag 10: Volume Files 11: Pool 12: Volume from Pool 13: All Volumes from Pool 14: Enabled 15: RecyclePool 16: Done Select parameter to modify (1-16): 11 Defined Pools: 1: Scratch 2: FullTest 3: DiffTest 4: IncrTest 5: Default 6: Monday 7: Tuesday 8: Wednesday 9: Thursday 10: Friday 11: Saturday 12: Sunday Select the Pool (1-12): 1 No results to list. Enter MediaId or Volume name: GDV100L4 sql_get.c:1005 Media record for Volume GDV100L4 not found. Thanks. I just tested this and the Select the Pool must be the old pool. But I haven't an old pool, I never associated a volume to a pool (I hope). After you select a volume bacula will ask you to type the pool name. In this case I would put all volumes into the Scratch pool. Ok, I think this is a good clue. If you labeled many tapes this will be tedious. A second way would be direct manipulation of the database. Remember to shut down bacula-dir before you do this. Uhm, I don't want to handle manually the database, If I can. Thanks, Nicola Quargentan. -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] autochanger and barcode
Alex Chekholko ha scritto: On Fri, 16 Oct 2009 16:52:21 +0200 Nicola Quargentan nic...@quargentan.com wrote: I just tested this and the Select the Pool must be the old pool. But I haven't an old pool, I never associated a volume to a pool (I hope). From your previous mail, it looks like when you did a label barcodes and it asked you which pool to put them into, you entered . Entering a period should cancel the whole operation. But maybe it didn't. What does your list volumes return? It will show which volumes bacula knows about, what pool they are in (and they must be in some pool! Scratch is best for new volumes) and what slot bacula thinks they are in the library. *list volumes Pool: Scratch No results to list. Pool: FullTest No results to list. Pool: DiffTest No results to list. Pool: IncrTest No results to list. Pool: Default No results to list. Pool: Monday No results to list. Pool: Tuesday No results to list. Pool: Wednesday No results to list. Pool: Thursday No results to list. Pool: Friday No results to list. Pool: Saturday No results to list. Pool: Sunday No results to list. Nicola Quargentan. -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] autochanger and barcode
On Fri, Oct 16, 2009 at 12:17 PM, Nicola Quargentan nic...@quargentan.com wrote: Alex Chekholko ha scritto: On Fri, 16 Oct 2009 16:52:21 +0200 Nicola Quargentan nic...@quargentan.com wrote: I just tested this and the Select the Pool must be the old pool. But I haven't an old pool, I never associated a volume to a pool (I hope). From your previous mail, it looks like when you did a label barcodes and it asked you which pool to put them into, you entered . Entering a period should cancel the whole operation. But maybe it didn't. What does your list volumes return? It will show which volumes bacula knows about, what pool they are in (and they must be in some pool! Scratch is best for new volumes) and what slot bacula thinks they are in the library. *list volumes Pool: Scratch No results to list. Pool: FullTest No results to list. Pool: DiffTest No results to list. Pool: IncrTest No results to list. Pool: Default No results to list. Pool: Monday No results to list. Pool: Tuesday No results to list. Pool: Wednesday No results to list. Pool: Thursday No results to list. Pool: Friday No results to list. Pool: Saturday No results to list. Pool: Sunday No results to list. Okay. None of the tapes are in any pool. So now you really only want to use the label barcodes command and put all volumes in the Scratch pool. No need to specify slots since all tapes need to go to the scratch. John -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] autochanger and barcode
Bob Hetzel ha scritto: Nicola, If you're using barcodes you can greatly simplify what you're doing. Instead of using one pool per day, just use one pool for all backups and one scratch pool. Place all the tapes in the scratch pool. Ok, now this is that I want. Forget about trying to keep straight which tape is for which day and let bacula track that for you. When you need to do a restore, let bacula tell you which volumes that data is on. I'm not fully persuased about bacula. I fear that the database (MySQL) become corrupted. Set volume retention, job retention, file retention, and volume use duration if you find that you don't fill up a tape as fast as you would like, then if you wanted to do some inchanger-out of changer tape rotation, periodically remove tapes marked Full or Used. To label them do 'label barcodes slots=first-last substituting the slot numbers for the first and last slots holding the tapes to be labelled. Ok, I think the first problem was to erase all volume. Now when I label barcodes the volumes was defined in my scratch pool :) cut... Thanks. Nicola Quargentan -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] autochanger and barcode
I'm not fully persuased about bacula. I fear that the database (MySQL) become corrupted. That is why you should keep a copy of the database on a disk based volume (or other backup) on a different machine than the one that contains the database. I have most of my backups ( 25TB now) go to tape but my database backup goes to a disk volume on a different machine than the one containing the database. John -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] autochanger and barcode
John Drescher ha scritto: On Fri, Oct 16, 2009 at 12:17 PM, Nicola Quargentan nic...@quargentan.com wrote: Alex Chekholko ha scritto: cut... Okay. None of the tapes are in any pool. So now you really only want to use the label barcodes command and put all volumes in the Scratch pool. No need to specify slots since all tapes need to go to the scratch. John Ok, current situation: *update slots The defined Storage resources are: 1: File 2: autochanger Select Storage resource (1-2): 2 Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... 3306 Issuing autochanger slots command. Device tape-burp-LTO4 has 23 slots. Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... 3306 Issuing autochanger list command. Catalog record for Volume GDV100L4 updated to reference slot 1. Catalog record for Volume GDV106L4 updated to reference slot 2. Volume GDV101L4 not found in catalog. Slot=5 InChanger set to zero. Catalog record for Volume GDV102L4 updated to reference slot 6. Catalog record for Volume GDV107L4 updated to reference slot 12. Catalog record for Volume GDV105L4 updated to reference slot 13. Catalog record for Volume GDV104L4 updated to reference slot 14. Catalog record for Volume GDV103L4 updated to reference slot 15. *list volumes Pool: Scratch +-++---+-+--+--+--+-+--+---+---+-+ | MediaId | VolumeName | VolStatus | Enabled | VolBytes | VolFiles | VolRetention | Recycle | Slot | InChanger | MediaType | LastWritten | +-++---+-+--+--+--+-+--+---+---+-+ | 14 | GDV100L4 | Append| 1 | 64,512 |0 | 31,536,000 | 1 |1 | 1 | LTO4 | -00-00 00:00:00 | | 15 | GDV106L4 | Append| 1 | 64,512 |0 | 31,536,000 | 1 |2 | 1 | LTO4 | -00-00 00:00:00 | | 16 | GDV102L4 | Append| 1 | 64,512 |0 | 31,536,000 | 1 |6 | 1 | LTO4 | -00-00 00:00:00 | | 17 | GDV107L4 | Append| 1 | 64,512 |0 | 31,536,000 | 1 | 12 | 1 | LTO4 | -00-00 00:00:00 | | 18 | GDV105L4 | Append| 1 | 64,512 |0 | 31,536,000 | 1 | 13 | 1 | LTO4 | -00-00 00:00:00 | | 19 | GDV104L4 | Append| 1 | 64,512 |0 | 31,536,000 | 1 | 14 | 1 | LTO4 | -00-00 00:00:00 | | 20 | GDV103L4 | Append| 1 | 64,512 |0 | 31,536,000 | 1 | 15 | 1 | LTO4 | -00-00 00:00:00 | +-++---+-+--+--+--+-+--+---+---+-+ Pool: FullTest No results to list. Pool: DiffTest No results to list. Pool: IncrTest No results to list. Pool: Default No results to list. Pool: Monday No results to list. Pool: Tuesday No results to list. Pool: Wednesday No results to list. Pool: Thursday No results to list. Pool: Friday No results to list. Pool: Saturday No results to list. Pool: Sunday No results to list. * Now I have some problem with slot 5. I will try to clean the tape (with mtx). Nicola Quargentan. -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] autochanger and barcode
On Fri, Oct 16, 2009 at 1:05 PM, Nicola Quargentan nic...@quargentan.com wrote: John Drescher ha scritto: On Fri, Oct 16, 2009 at 12:17 PM, Nicola Quargentan nic...@quargentan.com wrote: Alex Chekholko ha scritto: cut... Okay. None of the tapes are in any pool. So now you really only want to use the label barcodes command and put all volumes in the Scratch pool. No need to specify slots since all tapes need to go to the scratch. John Ok, current situation: *update slots The defined Storage resources are: 1: File 2: autochanger Select Storage resource (1-2): 2 Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... 3306 Issuing autochanger slots command. Device tape-burp-LTO4 has 23 slots. Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... 3306 Issuing autochanger list command. Catalog record for Volume GDV100L4 updated to reference slot 1. Catalog record for Volume GDV106L4 updated to reference slot 2. Volume GDV101L4 not found in catalog. Slot=5 InChanger set to zero. Catalog record for Volume GDV102L4 updated to reference slot 6. Catalog record for Volume GDV107L4 updated to reference slot 12. Catalog record for Volume GDV105L4 updated to reference slot 13. Catalog record for Volume GDV104L4 updated to reference slot 14. Catalog record for Volume GDV103L4 updated to reference slot 15. *list volumes Pool: Scratch +-++---+-+--+--+--+-+--+---+---+-+ | MediaId | VolumeName | VolStatus | Enabled | VolBytes | VolFiles | VolRetention | Recycle | Slot | InChanger | MediaType | LastWritten | +-++---+-+--+--+--+-+--+---+---+-+ | 14 | GDV100L4 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 1 | 1 | LTO4 | -00-00 00:00:00 | | 15 | GDV106L4 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 2 | 1 | LTO4 | -00-00 00:00:00 | | 16 | GDV102L4 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 6 | 1 | LTO4 | -00-00 00:00:00 | | 17 | GDV107L4 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 12 | 1 | LTO4 | -00-00 00:00:00 | | 18 | GDV105L4 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 13 | 1 | LTO4 | -00-00 00:00:00 | | 19 | GDV104L4 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 14 | 1 | LTO4 | -00-00 00:00:00 | | 20 | GDV103L4 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 15 | 1 | LTO4 | -00-00 00:00:00 | +-++---+-+--+--+--+-+--+---+---+-+ Pool: FullTest No results to list. Pool: DiffTest No results to list. Pool: IncrTest No results to list. Pool: Default No results to list. Pool: Monday No results to list. Pool: Tuesday No results to list. Pool: Wednesday No results to list. Pool: Thursday No results to list. Pool: Friday No results to list. Pool: Saturday No results to list. Pool: Sunday No results to list. * Now I have some problem with slot 5. I will try to clean the tape (with mtx). Perhaps you did not do an update slots before the label? type label barcodes again into the Scratch pool. Even though bacula will say its going to label all of the volumes it will only choose the one in slot5 John -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] autochanger and barcode
Hi, 16.10.2009 18:45, Nicola Quargentan wrote: Bob Hetzel ha scritto: ... Forget about trying to keep straight which tape is for which day and let bacula track that for you. When you need to do a restore, let bacula tell you which volumes that data is on. I'm not fully persuased about bacula. I fear that the database (MySQL) become corrupted. In all the years I use Bacula at several locations I haven't seen such a case (unless I broke it myself, manually, and knowing the risk I ran :-) , so I believe you don't have to be afraid of that. Furthermore, once you have more than a really small number of backup jobs, backups you keep, clients, and media, you need some way to track all of that. Bacula's database catalog is, compared to most of the other solutions I had to suffer, astonishingly robust. Furthermore, you can do as many dumps of it as you like. And any manual way of managing that information is, in my opinion, doomed to fail - I recall when I was using tar and lots of post-its on the tapes, and then tar plus some script resulting in printouts of the backup information... unmaintainable is a polite word to describe that. In short, the catalog *any* serious backup solution provides is essential, and you've simply got to trust it. Bacula's catalog is one of the more robust versions of such a catalog, and thus it's unlikely any alternative will work more considerably reliable. Arno cut... Thanks. Nicola Quargentan -- Arno Lehmann IT-Service Lehmann Sandstr. 6, 49080 Osnabrück www.its-lehmann.de -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] autochanger and barcode
John Drescher ha scritto: I'm not fully persuased about bacula. I fear that the database (MySQL) become corrupted. That is why you should keep a copy of the database on a disk based volume (or other backup) on a different machine than the one that contains the database. I have most of my backups ( 25TB now) go to tape but my database backup goes to a disk volume on a different machine than the one containing the database. But the use of pools on what for? Just for completeness I must save this data: 1) Oracle db (size unknown) 2) 5-6 MySQL db (about 25 Gb) 3) Some samba share, with office files (5Gb) 4) An subversion reposity (size unknown) 5) Mail server (size unknown) 6) The configuration of 8 servers 7) Other things that now I do not remember :) I should make a pool for each points? Thanks. Nicola Quargentan -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] autochanger and barcode
hi, I'm very newbie and I want to use a DELL TL2000 autochanger. I made 7 pool in config file, one for each day of week: Monday, Tuesday, etc. I want to use one volume for day and label it same as barcode. When I tried label barcode I must to put all tape in only one pool: *label barcode The defined Storage resources are: 1: File 2: autochanger Select Storage resource (1-2): 2 Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... 3306 Issuing autochanger slots command. Device tape-burp-LTO4 has 23 slots. Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... 3306 Issuing autochanger list command. The following Volumes will be labeled: Slot Volume == 1 GDV100L4 5 GDV101L4 6 GDV102L4 12 GDV107L4 13 GDV105L4 14 GDV104L4 15 GDV103L4 16 GDV106L4 Do you want to label these Volumes? (yes|no): yes Defined Pools: 1: Scratch 2: FullTest 3: DiffTest 4: IncrTest 5: Default 6: Monday 7: Tuesday 8: Wednesday 9: Thursday 10: Friday 11: Saturday 12: Sunday Select the Pool (1-12): . So I cannot put the volume GDV100L4 in Monday, GDV101L4 in Tuesday etc. I tried also to put all volumes in Scratch pool, but bacula return a lot of messages: Cannot label Volume because it is already labeled. 1) Is there a clue to add one volume labeled by barcode to a single pool? 2) How I can relabel the volumes (I found a bad clue on the web: erase every tapes manually :( ). Thanks, Nicola. -- Nicola Quargentan -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] autochanger and barcode
On Thu, Oct 15, 2009 at 6:03 PM, Nicola Quargentan nic...@quargentan.com wrote: hi, I'm very newbie and I want to use a DELL TL2000 autochanger. I made 7 pool in config file, one for each day of week: Monday, Tuesday, etc. I want to use one volume for day and label it same as barcode. When I tried label barcode I must to put all tape in only one pool: *label barcode The defined Storage resources are: 1: File 2: autochanger Select Storage resource (1-2): 2 Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... 3306 Issuing autochanger slots command. Device tape-burp-LTO4 has 23 slots. Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... 3306 Issuing autochanger list command. The following Volumes will be labeled: Slot Volume == 1 GDV100L4 5 GDV101L4 6 GDV102L4 12 GDV107L4 13 GDV105L4 14 GDV104L4 15 GDV103L4 16 GDV106L4 Do you want to label these Volumes? (yes|no): yes Defined Pools: 1: Scratch 2: FullTest 3: DiffTest 4: IncrTest 5: Default 6: Monday 7: Tuesday 8: Wednesday 9: Thursday 10: Friday 11: Saturday 12: Sunday Select the Pool (1-12): . So I cannot put the volume GDV100L4 in Monday, GDV101L4 in Tuesday etc. I tried also to put all volumes in Scratch pool, but bacula return a lot of messages: Cannot label Volume because it is already labeled. 1) Is there a clue to add one volume labeled by barcode to a single pool? 2) How I can relabel the volumes (I found a bad clue on the web: erase every tapes manually :( ). use update volume then select pool Normally I would put all volumes in the Scratch pool and bacula will when required move one tape to what ever pool needs tapes when you are running a backup job. John -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] autochanger and barcode
John Drescher ha scritto: On Thu, Oct 15, 2009 at 6:03 PM, Nicola Quargentan nic...@quargentan.com wrote: hi, I'm very newbie and I want to use a DELL TL2000 autochanger. I made 7 pool in config file, one for each day of week: Monday, Tuesday, etc. I want to use one volume for day and label it same as barcode. When I tried label barcode I must to put all tape in only one pool: *label barcode The defined Storage resources are: 1: File 2: autochanger Select Storage resource (1-2): 2 Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... 3306 Issuing autochanger slots command. Device tape-burp-LTO4 has 23 slots. Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... 3306 Issuing autochanger list command. The following Volumes will be labeled: Slot Volume == 1 GDV100L4 5 GDV101L4 6 GDV102L4 12 GDV107L4 13 GDV105L4 14 GDV104L4 15 GDV103L4 16 GDV106L4 Do you want to label these Volumes? (yes|no): yes Defined Pools: 1: Scratch 2: FullTest 3: DiffTest 4: IncrTest 5: Default 6: Monday 7: Tuesday 8: Wednesday 9: Thursday 10: Friday 11: Saturday 12: Sunday Select the Pool (1-12): . So I cannot put the volume GDV100L4 in Monday, GDV101L4 in Tuesday etc. I tried also to put all volumes in Scratch pool, but bacula return a lot of messages: Cannot label Volume because it is already labeled. 1) Is there a clue to add one volume labeled by barcode to a single pool? 2) How I can relabel the volumes (I found a bad clue on the web: erase every tapes manually :( ). use update volume then select pool Normally I would put all volumes in the Scratch pool and bacula will when required move one tape to what ever pool needs tapes when you are running a backup job. Uhm, ok, but how? *update volume Parameters to modify: 1: Volume Status 2: Volume Retention Period 3: Volume Use Duration 4: Maximum Volume Jobs 5: Maximum Volume Files 6: Maximum Volume Bytes 7: Recycle Flag 8: Slot 9: InChanger Flag 10: Volume Files 11: Pool 12: Volume from Pool 13: All Volumes from Pool 14: Enabled 15: RecyclePool 16: Done Select parameter to modify (1-16): 11 Defined Pools: 1: Scratch 2: FullTest 3: DiffTest 4: IncrTest 5: Default 6: Monday 7: Tuesday 8: Wednesday 9: Thursday 10: Friday 11: Saturday 12: Sunday Select the Pool (1-12): 1 No results to list. Enter MediaId or Volume name: GDV100L4 sql_get.c:1005 Media record for Volume GDV100L4 not found. Thanks. -- Nicola Quargentan Quargentan S.p.A. Via Valle, 1 Terrossa di Ronca' (VR) Tel 045/7460043 Fax 045/7460954 -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users