Re: [Bacula-users] Restore of files when they don't list
On Thu, Jun 23, 2011 at 02:01:56PM -0700, Steve Ellis wrote: On 6/23/2011 1:31 PM, Troy Kocher wrote: Listers, I'm trying to restore data from medicaid 27, but it appears there are no files. There is a file corresponding with this still on the disk, so I think it's just been purged from the database. Could someone help me thru the restore process when the files are no longer in the database. Thanks! Troy There are really only 3 options here that I can think of: 1) restore the entire job (probably to an temporary location), then prune the bits you don't want. 2) use bscan of the volume to recreate the file list in the db (note that I have only used this when the job itself had been expired from the DB) 3) restore a dump of the catalog that contains the file entries that you wanted that have been expired 4) Use bextract. I'm pretty sure I've done both #1 and #2, #3 I'd be much more reluctant to just try, as I would worry about clobbering more recent catalog data, unless you used a separate catalog db for the restoration. Unless the job is really huge, I'd probably do #1, because bscan is (slightly) dodgy, especially for backups that span volumes (IMHO, note that it is _much_ better than not having bscan at all). Sorry I can't provide more detail, hopefully someone else will be able to help more. -se -- Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Data protection magic? Nope - It's vRanger. Get your free trial download today. http://p.sf.net/sfu/quest-sfdev2dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense.. http://p.sf.net/sfu/splunk-d2d-c1 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Restore of files when they don't list
I decided on bextract. I've found the file I need in the volume, but still having problems... #bextract -d99 -i databaselist.rest -V DatabaseF-0027 /data/bacula /data/tmp bextract: stored_conf.c:698-0 Inserting director res: fatboy-dir bextract: butil.c:282 Using device: /data/bacula for reading. bextract: acquire.c:109-0 MediaType dcr= dev=File bextract: acquire.c:228-0 opened dev pool (/data/bacula) OK bextract: acquire.c:231-0 calling read-vol-label Volume Label: Id: Bacula 1.0 immortal VerNo : 11 VolName : DatabaseF-0027 PrevVolName : VolFile : 0 LabelType : VOL_LABEL LabelSize : 186 PoolName : DatabaseF MediaType : File PoolType : Backup HostName : foobar.mtadistributors.com Date label written: 06-Sep-2010 02:23 bextract: acquire.c:235-0 Got correct volume. 24-Jun 11:16 bextract JobId 0: Ready to read from volume DatabaseF-0027 on device pool (/data/bacula). bextract: attr.c:281-0 -rw-rw 1 pgsqlpgsql 386091824 2011-06-09 08:51:47 /data/tmp/mnt/database/usr/home/pgsql/dumps/mta.dump.sql.gz-4 bextract JobId 0: -rw-rw 1 pgsqlpgsql 386091824 2011-06-09 08:51:47 /data/tmp/mnt/database/usr/home/pgsql/dumps/mta.dump.sql.gz-4 I have one processor going @ 100%, a file touched in the restore location but O bytes being written into the file. Thoughts? Troy On 24,Jun 2011, at 2:28 AM, Graham Keeling wrote: On Thu, Jun 23, 2011 at 02:01:56PM -0700, Steve Ellis wrote: On 6/23/2011 1:31 PM, Troy Kocher wrote: Listers, I'm trying to restore data from medicaid 27, but it appears there are no files. There is a file corresponding with this still on the disk, so I think it's just been purged from the database. Could someone help me thru the restore process when the files are no longer in the database. Thanks! Troy There are really only 3 options here that I can think of: 1) restore the entire job (probably to an temporary location), then prune the bits you don't want. 2) use bscan of the volume to recreate the file list in the db (note that I have only used this when the job itself had been expired from the DB) 3) restore a dump of the catalog that contains the file entries that you wanted that have been expired 4) Use bextract. I'm pretty sure I've done both #1 and #2, #3 I'd be much more reluctant to just try, as I would worry about clobbering more recent catalog data, unless you used a separate catalog db for the restoration. Unless the job is really huge, I'd probably do #1, because bscan is (slightly) dodgy, especially for backups that span volumes (IMHO, note that it is _much_ better than not having bscan at all). Sorry I can't provide more detail, hopefully someone else will be able to help more. -se smime.p7s Description: S/MIME cryptographic signature -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense.. http://p.sf.net/sfu/splunk-d2d-c1___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Restore of files when they don't list
Listers, I'm trying to restore data from medicaid 27, but it appears there are no files. There is a file corresponding with this still on the disk, so I think it's just been purged from the database. Could someone help me thru the restore process when the files are no longer in the database. Thanks! Troy *list pools +++-+-+--+-+ | poolid | name | numvols | maxvols | pooltype | labelformat | +++-+-+--+-+ | 8 | DatabaseF | 5 | 0 | Backup | DatabaseF- | Select the Pool (1-21): 15 +-++---+-++--+--+-+--+---+---+-+ | mediaid | volumename | volstatus | enabled | volbytes | volfiles | volretention | recycle | slot | inchanger | mediatype | lastwritten | +-++---+-++--+--+-+--+---+---+-+ | 5 | DatabaseF-0005 | Used | 1 | 10,523,990,936 |2 | 2,592,000 | 1 |0 | 0 | File | 2011-06-01 02:46:26 | | 21 | DatabaseF-0021 | Used | 1 | 9,789,860,703 |2 | 2,592,000 | 1 |0 | 0 | File | 2011-06-08 02:36:45 | | 27 | DatabaseF-0027 | Used | 1 | 10,410,167,386 |2 | 2,592,000 | 1 |0 | 0 | File | 2011-06-16 00:10:55 | | 33 | DatabaseF-0033 | Append| 1 | 10,509,175,135 |2 | 2,592,000 | 1 |0 | 0 | File | 2011-06-23 02:54:28 | | 37 | DatabaseF-0037 | Used | 1 | 12,293,658,856 |2 | 2,592,000 | 1 |0 | 0 | File | 2011-05-25 02:39:36 | +-++---+-++--+--+-+--+---+---+-+ *list media pool=15 files jobid=27 Jobid 27 used 0 Volume(s): No results to list. No results to list. No results to list. smime.p7s Description: S/MIME cryptographic signature -- Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Data protection magic? Nope - It's vRanger. Get your free trial download today. http://p.sf.net/sfu/quest-sfdev2dev___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Restore of files when they don't list
On 6/23/2011 1:31 PM, Troy Kocher wrote: Listers, I'm trying to restore data from medicaid 27, but it appears there are no files. There is a file corresponding with this still on the disk, so I think it's just been purged from the database. Could someone help me thru the restore process when the files are no longer in the database. Thanks! Troy There are really only 3 options here that I can think of: 1) restore the entire job (probably to an temporary location), then prune the bits you don't want. 2) use bscan of the volume to recreate the file list in the db (note that I have only used this when the job itself had been expired from the DB) 3) restore a dump of the catalog that contains the file entries that you wanted that have been expired I'm pretty sure I've done both #1 and #2, #3 I'd be much more reluctant to just try, as I would worry about clobbering more recent catalog data, unless you used a separate catalog db for the restoration. Unless the job is really huge, I'd probably do #1, because bscan is (slightly) dodgy, especially for backups that span volumes (IMHO, note that it is _much_ better than not having bscan at all). Sorry I can't provide more detail, hopefully someone else will be able to help more. -se -- Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Data protection magic? Nope - It's vRanger. Get your free trial download today. http://p.sf.net/sfu/quest-sfdev2dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
