Hi,

2011/5/25 Roy Sigurd Karlsbakk <r...@karlsbakk.net>

> Hi all
>
> Seems I've lost a couple of 'tapes', or files, that is. After a multiple
> drive failure, some files are listed as corrupt by ZFS:
>
> errors: Permanent errors have been detected in the following files:
>
>        /dbpool/bacula/data/Incr-1466
>        /dbpool/bacula/data/Incr-0731
>
> Now, this wasn't meant to happen, the drives are in small RAIDz2 VDEVs, so
> safety is very high, but apparently, it did because of a freak combination
> of a hot datacentre and a bad set of WD Black drives.
>
> Now - a few questions:
>  - How can I find which backup jobs are affected by this?
>


Just use a simple sql statement:
--------------------
select
  name,starttime
from
  media m, jobmedia jm, job
where
  volumename='<yourvolumename>' and m.mediaid=jm.mediaid and
jm.jobid=job.jobid;
--------------------

When you replace <yourvolumename> by a lost volume, you should get a lost
Job names and Job start times.

Hope it helps.

- Since we rarely do full backups, and stick to incrementals, how can I find
> which jobs must be re-run as full because of such a 'broke chain'?
>
> Vennlige hilsener / Best regards
>
> roy
> --
> Roy Sigurd Karlsbakk
> (+47) 97542685
> r...@karlsbakk.net
> http://blogg.karlsbakk.net/
>

best regards

Radoslaw

-- 
Radosław Korzeniewski
rados...@korzeniewski.net
------------------------------------------------------------------------------
vRanger cuts backup time in half-while increasing security.
With the market-leading solution for virtual backup and recovery, 
you get blazing-fast, flexible, and affordable data protection.
Download your free trial now. 
http://p.sf.net/sfu/quest-d2dcopy1
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to