Bacula-users

Re: [Bacula-users] Issue with Restoring a Full which Spanned Tapes.

2009-03-18 18:46:09
Subject: Re: [Bacula-users] Issue with Restoring a Full which Spanned Tapes.
From: "Doug Forster" <dforster AT part DOT net>
To: "'John Drescher'" <drescherjm AT gmail DOT com>, "'bacula-users'" <Bacula-users AT lists.sourceforge DOT net>
Date: Wed, 18 Mar 2009 16:37:34 -0600
Here is some additional info. 

While trying to run the restore I select option 5 to restore from the latest
backup and then the jobs compile into a list for me to select from. 

+--------+-------+-----------+-----------------+---------------------+------
------+
| jobid  | level | jobfiles  | jobbytes        | starttime           |
volumename |
+--------+-------+-----------+-----------------+---------------------+------
------+
| 15,492 | F     | 1,270,369 | 175,284,402,458 | 2009-03-14 02:27:25 |
000107L2   |
| 15,492 | F     | 1,270,369 | 175,284,402,458 | 2009-03-14 02:27:25 |
000130L2   |
| 15,505 | I     |     1,564 |  11,863,643,578 | 2009-03-15 22:19:56 |
000111L2   |
| 15,519 | I     |     4,460 |   9,477,476,792 | 2009-03-16 22:52:26 |
000118L2   |
| 15,545 | I     |     2,814 |  11,859,455,884 | 2009-03-17 22:38:33 |
000118L2   |
+--------+-------+-----------+-----------------+---------------------+------
------+
You have selected the following JobIds: 15492,15505,15519,15545

Building directory tree for JobId 15492 ...  
Building directory tree for JobId 15505 ...  
Building directory tree for JobId 15519 ...  
Building directory tree for JobId 15545 ...  
4 Jobs, 6,510 files inserted into the tree.

You are now entering file selection mode where you add (mark) and
remove (unmark) files to be restored. No files are initially added, unless
you used the "all" keyword on the command line.
Enter "done" to leave this mode.

cwd is: /
$ cd /var/perforce/backup
cwd is: /var/perforce/backup/
$ ls
checkpoint.876.gz
checkpoint.877.gz
checkpoint.878.gz
journal.875.gz
journal.876.gz
journal.877.gz
$

Now compare it to what is actually on the server. 



[root@Client ~]# ll /var/perforce/backup/
total 5814764
-r--r--r--  1 perforce perforce 166947320 Feb 12 01:04 checkpoint.845.gz
-r--r--r--  1 perforce perforce 167350487 Feb 13 01:05 checkpoint.846.gz
-r--r--r--  1 perforce perforce 167245890 Feb 14 01:09 checkpoint.847.gz
-r--r--r--  1 perforce perforce 167767452 Feb 15 01:05 checkpoint.848.gz
-r--r--r--  1 perforce perforce 167707971 Feb 16 01:08 checkpoint.849.gz
-r--r--r--  1 perforce perforce 167714377 Feb 17 01:05 checkpoint.850.gz
-r--r--r--  1 perforce perforce 167884361 Feb 18 01:05 checkpoint.851.gz
-r--r--r--  1 perforce perforce 168204973 Feb 19 01:05 checkpoint.852.gz
-r--r--r--  1 perforce perforce 168305081 Feb 20 01:04 checkpoint.853.gz
-r--r--r--  1 perforce perforce 168289225 Feb 21 01:05 checkpoint.854.gz
-r--r--r--  1 perforce perforce 168294584 Feb 22 01:05 checkpoint.855.gz
-r--r--r--  1 perforce perforce 168285086 Feb 23 01:04 checkpoint.856.gz
-r--r--r--  1 perforce perforce 168475195 Feb 24 01:05 checkpoint.857.gz
-r--r--r--  1 perforce perforce 168584726 Feb 25 01:05 checkpoint.858.gz
-r--r--r--  1 perforce perforce 168530050 Feb 26 01:05 checkpoint.859.gz
-r--r--r--  1 perforce perforce 168674839 Feb 27 01:05 checkpoint.860.gz
-r--r--r--  1 perforce perforce 168682134 Feb 28 01:05 checkpoint.861.gz
-r--r--r--  1 perforce perforce 168675880 Mar  1 01:05 checkpoint.862.gz
-r--r--r--  1 perforce perforce 168699454 Mar  2 01:04 checkpoint.863.gz
-r--r--r--  1 perforce perforce 168714005 Mar  3 01:04 checkpoint.864.gz
-r--r--r--  1 perforce perforce 168728601 Mar  4 01:04 checkpoint.865.gz
-r--r--r--  1 perforce perforce 168818071 Mar  5 01:05 checkpoint.866.gz
-r--r--r--  1 perforce perforce 168865312 Mar  6 01:04 checkpoint.867.gz
-r--r--r--  1 perforce perforce 168864741 Mar  7 01:04 checkpoint.868.gz
-r--r--r--  1 perforce perforce 168875043 Mar  8 01:05 checkpoint.869.gz
-r--r--r--  1 perforce perforce 168823795 Mar  9 01:04 checkpoint.870.gz
-r--r--r--  1 perforce perforce 168861880 Mar 10 01:04 checkpoint.871.gz
-r--r--r--  1 perforce perforce 168785326 Mar 11 01:05 checkpoint.872.gz
-r--r--r--  1 perforce perforce 168786555 Mar 12 01:04 checkpoint.873.gz
-r--r--r--  1 perforce perforce 172122884 Mar 13 01:04 checkpoint.874.gz
-r--r--r--  1 perforce perforce 173264120 Mar 14 01:05 checkpoint.875.gz
-r--r--r--  1 perforce perforce 173268533 Mar 15 01:05 checkpoint.876.gz
-r--r--r--  1 perforce perforce 173259477 Mar 16 01:05 checkpoint.877.gz
-r--r--r--  1 perforce perforce 173282300 Mar 17 01:01 checkpoint.878.gz
-r--r--r--  1 perforce perforce 173397640 Mar 18 01:05 checkpoint.879.gz
-r--r--r--  1 perforce perforce   6492452 Feb 12 01:04 journal.844.gz
-r--r--r--  1 perforce perforce   1689725 Feb 13 01:05 journal.845.gz
-r--r--r--  1 perforce perforce    711976 Feb 14 01:09 journal.846.gz
-r--r--r--  1 perforce perforce   1056921 Feb 15 01:05 journal.847.gz
-r--r--r--  1 perforce perforce    123977 Feb 16 01:08 journal.848.gz
-r--r--r--  1 perforce perforce    609004 Feb 17 01:05 journal.849.gz
-r--r--r--  1 perforce perforce   1432755 Feb 18 01:05 journal.850.gz
-r--r--r--  1 perforce perforce   1081733 Feb 19 01:05 journal.851.gz
-r--r--r--  1 perforce perforce    423823 Feb 20 01:04 journal.852.gz
-r--r--r--  1 perforce perforce   1513811 Feb 21 01:05 journal.853.gz
-r--r--r--  1 perforce perforce      5382 Feb 22 01:05 journal.854.gz
-r--r--r--  1 perforce perforce      7979 Feb 23 01:04 journal.855.gz
-r--r--r--  1 perforce perforce    357891 Feb 24 01:05 journal.856.gz
-r--r--r--  1 perforce perforce    175899 Feb 25 01:05 journal.857.gz
-r--r--r--  1 perforce perforce    508465 Feb 26 01:05 journal.858.gz
-r--r--r--  1 perforce perforce   2391317 Feb 27 01:05 journal.859.gz
-r--r--r--  1 perforce perforce     83455 Feb 28 01:05 journal.860.gz
-r--r--r--  1 perforce perforce      6879 Mar  1 01:05 journal.861.gz
-r--r--r--  1 perforce perforce      5110 Mar  2 01:04 journal.862.gz
-r--r--r--  1 perforce perforce    370670 Mar  3 01:04 journal.863.gz
-r--r--r--  1 perforce perforce    370966 Mar  4 01:04 journal.864.gz
-r--r--r--  1 perforce perforce    582822 Mar  5 01:05 journal.865.gz
-r--r--r--  1 perforce perforce    241307 Mar  6 01:04 journal.866.gz
-r--r--r--  1 perforce perforce    112698 Mar  7 01:04 journal.867.gz
-r--r--r--  1 perforce perforce     11228 Mar  8 01:05 journal.868.gz
-r--r--r--  1 perforce perforce     83588 Mar  9 01:04 journal.869.gz
-r--r--r--  1 perforce perforce    138865 Mar 10 01:04 journal.870.gz
-r--r--r--  1 perforce perforce    195212 Mar 11 01:05 journal.871.gz
-r--r--r--  1 perforce perforce    191534 Mar 12 01:04 journal.872.gz
-r--r--r--  1 perforce perforce   3697855 Mar 13 01:04 journal.873.gz
-r--r--r--  1 perforce perforce   1325036 Mar 14 01:05 journal.874.gz
-r--r--r--  1 perforce perforce     26528 Mar 15 01:05 journal.875.gz
-r--r--r--  1 perforce perforce     25291 Mar 16 01:05 journal.876.gz
-r--r--r--  1 perforce perforce    324433 Mar 17 01:01 journal.877.gz
-r--r--r--  1 perforce perforce    328008 Mar 18 01:05 journal.878.gz
[root@Client ~]#


-----Original Message-----
From: John Drescher [mailto:drescherjm AT gmail DOT com] 
Sent: Wednesday, March 18, 2009 3:16 PM
To: Doug Forster; bacula-users
Subject: Re: [Bacula-users] Issue with Restoring a Full which Spanned Tapes.

> I am having issue with restoring a backup which was done over the weekend
> and I can't find any of the files that I need in the database. I have
> checked on some of the files that I do have and it looks as though only
> files done on the incremental since the full are available to select to
> restore. The last full was done accost 2 tapes and I can't find any of the
> files listed to restore. It isn't even showing them in the database from
> previous backups. It is like when inserting attributes the database said
ok
> good and then when it was done it throughout the whole backup job.
>
>
What command did you try? What did you do? Some console messages would
be helpful.

To me it is very doubtful that spanning tapes or bacula version has
any thing to do with this issue.

John


------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users