Hi there,

######################
# Summary of problem #
######################

I get the following output from the bconsole 'restore' command:

"No Full backup before 2007-03-07 12:26:11 found."

This is after choosing option 5: "Select the most recent backup for a
client".

This only started happening after using the 'bscan' utility to rebuild
my catalog.

I was able to run this restore command before I used the bscan utility
but I could only see ~25,000 out of the ~250,000 files in the backup.


####################
# Detailed history #
####################

This backup job has been running for a couple of months, so far it is
comprised of 1 full backup and ~35 incremental backups.

Recently I wanted to test the restore process to make sure everything
worked.  I tried to run the 'restore' command using option 5: Select the
most recent backup for a client.

At this point bacula provided me with a Directory Tree Structure however
only 10% of my files were available.

After troubleshooting this issue in the #bacula channel on freenode we
discovered that the client definition in the director configuration file
was setup to automatically prune all files over 60 days old.

Even though I had specifically set 'AutoPrune = No' and 'Volume
Retention = 99y' in my pool definition, the client definition seems to
have over written this.

After fixing this configuration problem I then set out to attempt to
rebuild the database using the 'bscan' utility.

bscan -s -m -c bacula-sd.conf -v -V Archive-1\|Archive-2\|Archive-3\|
Archive-4\|Archive-5\|Archive-6\|Archive-7\|Archive-8 /dev/nst0

One thing I need to mention, this backup spans across 9 tapes, I only
ran bscan on the first 8 because I assumed that the files on the last
tape did not need to be scanned as they were less than 60 days old
(Could this be a problem?).

When bscan finished it told me that it had entered ~255,000 files into
my database, unfortunately I did not save the final output from bscan.

Before running bscan I also backed up my database:

-rw-r-----  1 bacula bacula 1851354112 2007-03-07 12:15 bacula.db
-rw-r-----  1 root   root   1851354112 2007-03-05 14:06
bacula.db.backup-05-03-07

(I don't know why the database files are the same size?)

Now when I try to run the restore command it tells me: 
No Full backup before 2007-03-07 12:26:11 found


####################################
# An example of my bacula-dir.conf #
####################################

Job {
  Name = "Daily_Archive_Job"
  Client = pandora-fd
  Type = Backup
  Level = Incremental
  FileSet = "Archive"
  Storage = Tape
  Messages = Standard
  Pool = "Daily_Archive_Pool"
  Schedule = "Daily_Cycle"
  Priority = 5
  Write Bootstrap = "/var/lib/bacula/Daily_Archive_Job.bsr"
}

FileSet {
  Name = "Archive"
  Include {
    Options {
      signature = MD5
    }
    File = /mnt/raid-1/servers/archive
    File = /mnt/raid-1/traffic_accounting
  }
}

Pool {
  Name = Daily_Archive_Pool
  Pool Type = Backup
  AutoPrune = no
  Volume Retention = 99y
  Recycle = no
}

#########################
# Output from list jobs #
#########################

*list jobs
Using default Catalog name=MyCatalog DB=bacula
+-------+-----------------------+---------------------+------+-------+----------+--------------+-----------+
| JobId | Name                  | StartTime           | Type | Level |
JobFiles | JobBytes     | JobStatus |
+-------+-----------------------+---------------------+------+-------+----------+--------------+-----------+
| 157   | BackupCatalog         | 0                   | B    | F     | 0
| 0            | C         |
| 282   | Daily_Live_Job        | 0                   | B    | F     | 0
| 0            | C         |
| 283   | BackupCatalog         | 0                   | B    | F     | 0
| 0            | C         |
| 1     | Client1               | 2006-12-06 23:05:02 | B    | F     | 0
| 0            | f         |
| 2     | BackupCatalog         | 2006-12-06 23:10:02 | B    | F     | 0
| 0            | f         |
| 5     | BackupCatalog         | 2006-12-07 10:40:22 | B    | F     | 0
| 0            | f         |
| 6     | Client1               | 2006-12-07 10:43:14 | B    | F     | 0
| 0            | f         |
| 7     | BackupCatalog         | 2006-12-07 10:46:38 | B    | F     | 0
| 0            | f         |
| 8     | BackupCatalog         | 2006-12-07 10:48:50 | B    | F     | 0
| 0            | f         |
| 14    | RestoreFiles          | 2006-12-08 11:03:19 | R    | F     | 1
| 14047        | T         |
| 39    | Daily_Live_Job        | 2006-12-14 11:28:53 | B    | F     | 0
| 0            | A         |
| 40    | Daily_Live_Job        | 2006-12-14 11:28:55 | B    | F     | 0
| 0            | A         |
| 41    | Daily_Live_Job        | 2006-12-14 11:28:58 | B    | F     | 0
| 0            | A         |
| 42    | Daily_Live_Job        | 2006-12-14 11:29:00 | B    | F     | 0
| 0            | A         |
| 43    | Daily_Live_Job        | 2006-12-14 11:29:02 | B    | F     | 0
| 0            | A         |
| 44    | Daily_Live_Job        | 2006-12-14 11:29:04 | B    | F     | 0
| 0            | A         |
| 45    | Daily_Live_Job        | 2006-12-14 11:29:06 | B    | F     | 0
| 0            | A         |
| 46    | Daily_Live_Job        | 2006-12-14 11:29:08 | B    | F     | 0
| 0            | A         |
| 47    | Daily_Live_Job        | 2006-12-14 11:29:10 | B    | F     | 0
| 0            | A         |
| 48    | Daily_Live_Job        | 2006-12-14 11:29:12 | B    | F     | 0
| 0            | A         |
| 49    | Daily_Live_Job        | 2006-12-14 11:29:14 | B    | F     | 0
| 0            | A         |
| 50    | Daily_Live_Job        | 2006-12-14 11:29:16 | B    | F     | 0
| 0            | A         |
| 51    | Daily_Live_Job        | 2006-12-14 11:29:18 | B    | F     | 0
| 0            | A         |
| 52    | Daily_Live_Job        | 2006-12-14 11:29:20 | B    | F     | 0
| 0            | A         |
| 53    | Daily_Live_Job        | 2006-12-14 11:29:22 | B    | F     | 0
| 0            | A         |
| 54    | Daily_Live_Job        | 2006-12-14 11:29:25 | B    | F     | 0
| 0            | A         |
| 55    | Daily_Live_Job        | 2006-12-14 11:29:27 | B    | F     | 0
| 0            | A         |
| 56    | Daily_Live_Job        | 2006-12-14 11:29:29 | B    | F     | 0
| 0            | A         |
| 57    | Daily_Live_Job        | 2006-12-14 11:29:31 | B    | F     | 0
| 0            | A         |
| 58    | Daily_Live_Job        | 2006-12-14 11:29:33 | B    | F     | 0
| 0            | A         |
| 59    | Daily_Live_Job        | 2006-12-14 11:29:35 | B    | F     | 0
| 0            | A         |
| 60    | Daily_Live_Job        | 2006-12-14 11:29:37 | B    | F     | 0
| 0            | A         |
| 61    | Daily_Live_Job        | 2006-12-14 11:29:39 | B    | F     | 0
| 0            | A         |
| 62    | Daily_Live_Job        | 2006-12-14 11:29:41 | B    | F     | 0
| 0            | A         |
| 64    | Daily_Live_Job        | 2006-12-14 11:29:43 | B    | F     | 0
| 0            | A         |
| 65    | Daily_Live_Job        | 2006-12-14 11:29:45 | B    | F     | 0
| 0            | A         |
| 66    | Daily_Live_Job        | 2006-12-14 11:29:47 | B    | F     | 0
| 0            | A         |
| 67    | Daily_Live_Job        | 2006-12-14 11:29:49 | B    | F     | 0
| 0            | A         |
| 68    | Daily_Live_Job        | 2006-12-14 11:29:52 | B    | F     | 0
| 0            | A         |
| 69    | Daily_Live_Job        | 2006-12-14 11:29:54 | B    | F     | 0
| 0            | A         |
| 70    | Daily_Live_Job        | 2006-12-14 11:29:56 | B    | F     | 0
| 0            | A         |
| 71    | Daily_Live_Job        | 2006-12-14 11:29:58 | B    | F     | 0
| 0            | A         |
| 72    | Daily_Live_Job        | 2006-12-14 11:30:00 | B    | F     | 0
| 0            | A         |
| 73    | Daily_Live_Job        | 2006-12-14 11:30:02 | B    | F     | 0
| 0            | A         |
| 74    | Daily_Live_Job        | 2006-12-14 11:30:04 | B    | F     | 0
| 0            | A         |
| 75    | Daily_Live_Job        | 2006-12-14 11:30:06 | B    | F     | 0
| 0            | A         |
| 76    | Daily_Live_Job        | 2006-12-14 11:30:08 | B    | F     | 0
| 0            | A         |
| 77    | Daily_Live_Job        | 2006-12-14 11:30:10 | B    | F     | 0
| 0            | A         |
| 78    | Daily_Live_Job        | 2006-12-14 11:30:12 | B    | F     | 0
| 0            | A         |
| 79    | Daily_Live_Job        | 2006-12-14 11:30:14 | B    | F     | 0
| 0            | A         |
| 80    | Daily_Live_Job        | 2006-12-14 11:30:16 | B    | F     | 0
| 0            | A         |
| 81    | Daily_Live_Job        | 2006-12-14 11:30:19 | B    | F     | 0
| 0            | A         |
| 82    | Daily_Live_Job        | 2006-12-14 11:30:21 | B    | F     | 0
| 0            | A         |
| 83    | Daily_Live_Job        | 2006-12-14 11:30:23 | B    | F     | 0
| 0            | A         |
| 84    | Daily_Live_Job        | 2006-12-14 11:30:25 | B    | F     | 0
| 0            | A         |
| 85    | Daily_Live_Job        | 2006-12-14 11:30:27 | B    | F     | 0
| 0            | A         |
| 86    | Daily_Live_Job        | 2006-12-14 11:30:29 | B    | F     | 0
| 0            | A         |
| 87    | Daily_Live_Job        | 2006-12-14 11:30:31 | B    | F     | 0
| 0            | A         |
| 89    | Daily_Live_Job        | 2006-12-14 11:30:33 | B    | F     | 0
| 0            | A         |
| 90    | Daily_Live_Job        | 2006-12-14 11:30:35 | B    | F     | 0
| 0            | A         |
| 91    | Daily_Live_Job        | 2006-12-14 11:30:37 | B    | F     | 0
| 0            | A         |
| 92    | Daily_Live_Job        | 2006-12-14 11:30:39 | B    | F     | 0
| 0            | A         |
| 93    | Daily_Live_Job        | 2006-12-14 11:30:41 | B    | F     | 0
| 0            | A         |
| 94    | Daily_Live_Job        | 2006-12-14 11:30:43 | B    | F     | 0
| 0            | A         |
| 63    | BackupCatalog         | 2006-12-14 11:37:48 | B    | F     | 0
| 0            | A         |
| 88    | BackupCatalog         | 2006-12-14 11:37:50 | B    | F     | 0
| 0            | A         |
| 149   | Daily_Live_Job        | 2007-01-10 15:09:44 | B    | F     | 0
| 0            | A         |
| 150   | Monthly_Live_Job      | 2007-01-10 15:40:20 | B    | F     | 0
| 0            | A         |
| 151   | Monthly_Live_Job      | 2007-01-10 16:12:41 | B    | F     | 0
| 0            | f         |
| 152   | Monthly_Live_Job      | 2007-01-10 16:21:29 | B    | F     |
11604    | 180513327    | A         |
| 153   | Monthly_Live_Job      | 2007-01-10 16:29:24 | B    | F     |
276105   | 7770753916   | T         |
| 179   | Daily_Archive_Job     | 2007-01-23 17:11:27 | B    | F     | 0
| 0            | A         |
| 197   | Daily_Archive_Job     | 2007-01-31 14:28:30 | B    | F     |
255450   | 730923188523 | T         |
| 198   | Daily_Archive_Job     | 2007-02-01 20:18:44 | B    | I     |
994      | 3962503581   | T         |
| 199   | Daily_Live_Job        | 2007-02-01 20:27:17 | B    | F     | 0
| 0            | A         |
| 200   | Monthly_Live_Job      | 2007-02-01 20:27:19 | B    | F     | 0
| 0            | A         |
| 201   | BackupCatalog         | 2007-02-01 20:27:21 | B    | F     | 0
| 0            | A         |
| 202   | BackupCatalog         | 2007-02-01 20:27:23 | B    | F     | 0
| 0            | A         |
| 203   | Daily_Archive_Job     | 2007-02-02 01:30:04 | B    | I     |
686      | 776728387    | T         |
| 206   | Daily_Archive_Job     | 2007-02-03 01:30:03 | B    | I     |
168      | 1478613484   | E         |
| 209   | Daily_Archive_Job     | 2007-02-05 09:36:39 | B    | I     |
2794     | 8718990882   | T         |
| 212   | Daily_Archive_Job     | 2007-02-05 09:54:57 | B    | I     | 0
| 0            | T         |
| 215   | Daily_Archive_Job     | 2007-02-06 01:30:03 | B    | I     |
96       | 630085699    | T         |
| 218   | Daily_Archive_Job     | 2007-02-07 01:30:04 | B    | I     |
978      | 3173777420   | T         |
| 221   | Daily_Archive_Job     | 2007-02-08 01:30:03 | B    | I     |
979      | 4127762498   | T         |
| 224   | Daily_Archive_Job     | 2007-02-09 01:30:04 | B    | I     |
989      | 3120320233   | T         |
| 227   | Daily_Archive_Job     | 2007-02-10 01:30:04 | B    | I     |
980      | 3124987525   | T         |
| 230   | Daily_Archive_Job     | 2007-02-11 01:30:03 | B    | I     |
980      | 3231148044   | T         |
| 233   | Daily_Archive_Job     | 2007-02-12 01:30:03 | B    | I     |
974      | 3161288917   | T         |
| 236   | Daily_Archive_Job     | 2007-02-13 01:30:04 | B    | I     |
983      | 3121671301   | T         |
| 239   | Daily_Archive_Job     | 2007-02-14 01:30:03 | B    | I     |
972      | 3058925870   | T         |
| 242   | Daily_Archive_Job     | 2007-02-15 01:30:04 | B    | I     |
1001     | 3130006475   | T         |
| 245   | Daily_Archive_Job     | 2007-02-16 01:30:04 | B    | I     |
973      | 3180835109   | T         |
| 248   | Daily_Archive_Job     | 2007-02-17 01:30:03 | B    | I     |
975      | 3223494662   | T         |
| 251   | Daily_Archive_Job     | 2007-02-18 01:30:04 | B    | I     |
973      | 3113706952   | T         |
| 254   | Daily_Archive_Job     | 2007-02-19 01:30:04 | B    | I     |
996      | 3082105825   | T         |
| 257   | Daily_Archive_Job     | 2007-02-20 01:30:03 | B    | I     |
977      | 3010903571   | T         |
| 260   | Daily_Archive_Job     | 2007-02-21 01:30:03 | B    | I     |
989      | 3270699587   | T         |
| 263   | Daily_Archive_Job     | 2007-02-22 01:30:04 | B    | I     |
995      | 3288556655   | T         |
| 266   | Daily_Archive_Job     | 2007-02-23 01:30:03 | B    | I     |
995      | 3154138343   | T         |
| 269   | Daily_Archive_Job     | 2007-02-24 01:30:04 | B    | I     |
1000     | 3174689601   | T         |
| 270   | Daily_Live_Job        | 2007-02-24 02:18:24 | B    | F     |
304562   | 13072085432  | T         |
| 271   | BackupCatalog         | 2007-02-24 04:15:49 | B    | F     | 1
| 1843714169   | T         |
| 272   | Daily_Archive_Job     | 2007-02-25 01:30:04 | B    | I     |
975      | 3125912232   | T         |
| 273   | Daily_Live_Job        | 2007-02-25 02:14:48 | B    | F     |
304798   | 13091423740  | T         |
| 274   | BackupCatalog         | 2007-02-25 04:17:27 | B    | F     | 1
| 1843714169   | T         |
| 275   | Daily_Archive_Job     | 2007-02-26 01:30:03 | B    | I     |
969      | 3138290178   | T         |
| 276   | Daily_Live_Job        | 2007-02-26 02:16:43 | B    | F     |
305034   | 13099587929  | T         |
| 277   | BackupCatalog         | 2007-02-26 04:26:52 | B    | F     | 1
| 1843714169   | T         |
| 278   | Daily_Archive_Job     | 2007-02-27 01:30:04 | B    | I     |
1004     | 3237467977   | T         |
| 279   | Daily_Live_Job        | 2007-02-27 02:18:25 | B    | F     |
305624   | 13111091416  | T         |
| 280   | BackupCatalog         | 2007-02-27 04:16:01 | B    | F     | 1
| 1843714169   | T         |
| 281   | Daily_Archive_Job     | 2007-02-28 01:30:04 | B    | I     |
1232     | 3314168495   | T         |
| 284   | Daily_Archive_Job     | 2007-02-28 09:47:58 | B    | I     |
877      | 2853526783   | T         |
| 285   | Daily_Archive_Job     | 2007-03-01 03:00:04 | B    | I     |
103      | 631587016    | T         |
| 286   | Daily_Live_Job        | 2007-03-01 03:05:16 | B    | F     |
307368   | 16665285712  | T         |
| 287   | Monthly_Live_Job      | 2007-03-01 04:29:42 | B    | F     |
307368   | 16665285712  | T         |
| 288   | BackupCatalog         | 2007-03-01 06:03:45 | B    | F     | 1
| 1843714169   | T         |
| 289   | Daily_Archive_Job     | 2007-03-02 08:40:49 | B    | I     |
1858     | 6609945559   | T         |
| 290   | Daily_Live_Job        | 2007-03-02 09:00:34 | B    | F     |
309226   | 18695739450  | T         |
| 291   | BackupCatalog         | 2007-03-02 11:01:22 | B    | F     | 1
| 1843714169   | T         |
| 292   | Daily_Archive_Job     | 2007-03-03 03:00:04 | B    | I     |
123      | 632224756    | T         |
| 293   | Daily_Live_Job        | 2007-03-03 03:16:44 | B    | F     |
308307   | 22326270112  | T         |
| 294   | BackupCatalog         | 2007-03-03 05:38:16 | B    | F     | 1
| 1843714169   | T         |
| 295   | Daily_Archive_Job     | 2007-03-04 03:00:04 | B    | I     |
441      | 1619898707   | T         |
| 296   | Daily_Live_Job        | 2007-03-04 03:44:04 | B    | F     |
308466   | 23525336253  | T         |
| 297   | BackupCatalog         | 2007-03-04 05:59:42 | B    | F     | 1
| 1843714169   | T         |
| 298   | Daily_Archive_Job     | 2007-03-05 03:00:04 | B    | I     |
109      | 633713911    | T         |
| 299   | Daily_Live_Job        | 2007-03-05 03:19:01 | B    | F     |
308602   | 24693712531  | T         |
| 300   | BackupCatalog         | 2007-03-05 08:47:43 | B    | F     | 1
| 1843714169   | T         |
| 301   | Restore_Daily_Archive | 2007-03-05 11:34:37 | R    | F     | 1
| 0            | T         |
| 302   | Restore_Daily_Archive | 2007-03-05 11:43:59 | R    | F     | 1
| 5028272      | T         |
| 303   | Restore_Daily_Archive | 2007-03-05 12:04:41 | R    | F     | 1
| 0            | T         |
| 304   | Restore_Daily_Archive | 2007-03-05 13:31:34 | R    | F     |
3640     | 13600780278  | A         |
| 305   | Daily_Archive_Job     | 2007-03-07 03:00:02 | B    | F     | 0
| 0            | f         |
| 306   | Daily_Live_Job        | 2007-03-07 03:30:06 | B    | F     | 0
| 0            | f         |
| 307   | BackupCatalog         | 2007-03-07 05:08:02 | B    | F     | 0
| 0            | f         |
| 308   | Restore_Daily_Archive | 2007-03-07 12:15:59 | R    | F     | 0
| 0            | f         |
+-------+-----------------------+---------------------+------+-------+----------+--------------+-----------+

###########
# Summary #
###########

At this point I'm very stuck =)

Any ideas would be greatly appreciated!

Thank you,

Paul England
Auckland, New Zealand



-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to