Re: [Bacula-users] autochanger and barcode

2009-10-28 Thread Arno Lehmann
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

2009-10-21 Thread Nicola Quargentan
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

2009-10-20 Thread Jari Fredriksson



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

2009-10-19 Thread Nicola Quargentan
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

2009-10-19 Thread Nicola Quargentan
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

2009-10-17 Thread Jesper Krogh
 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

2009-10-17 Thread Jesper Krogh
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

2009-10-16 Thread Bob Hetzel
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

2009-10-16 Thread John Drescher
 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

2009-10-16 Thread Nicola Quargentan
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

2009-10-16 Thread Nicola Quargentan
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

2009-10-16 Thread John Drescher
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

2009-10-16 Thread Nicola Quargentan
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

2009-10-16 Thread John Drescher
 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

2009-10-16 Thread Nicola Quargentan
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

2009-10-16 Thread John Drescher
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

2009-10-16 Thread Arno Lehmann
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

2009-10-16 Thread Nicola Quargentan
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

2009-10-15 Thread Nicola Quargentan
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

2009-10-15 Thread John Drescher
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

2009-10-15 Thread Nicola Quargentan
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