fiche de procédure - accueil -...

Memo bconsole

Memo bconsole

/ 24 Version du 10 Avril 2015

Memo bconsole


Memo bconsole

Sommaire

1 Voir les différentes travaux effectués par bacula.........................................................................3

1.1 Commande list jobs..............................................................................................................3

1.2 Commande sqlquery.............................................................................................................3

2 Afficher les message de bacula (stocker aussi dans les log)........................................................3

3 Restauration................................................................................................................................ 4

4 Voir les types de sauvegardes.....................................................................................................5

5 Voir le nombre de volumes utilisé par un type de sauvegarde :..................................................5

6 Voir la configuration d'un type de sauvegarde :..........................................................................5

7 La commande « query »..............................................................................................................6

8 Lister les volumes utilisés par un job...........................................................................................6

9 Lister les jobs utilisant un volume................................................................................................7

10 Trouver les jobs ayant sauvegardés un fichier...........................................................................7

11 Écriture de requêtes :................................................................................................................ 7

11.1 Rechercher.......................................................................................................................... 7

11.2 Préparation de requêtes pour exécuter en ligne de commande.........................................8

11.2.1 prune (bconsole)..........................................................................................................8

11.2.2 delete (bconsole).......................................................................................................10

11.2.3 rm (batch).................................................................................................................. 10

11.3 Exécuter les commandes précédentes.............................................................................11

11.3.1 Dans bconsole...........................................................................................................11

11.3.2 Dans un terminal batch.............................................................................................11

12 Modifier le temps de rétention des volumes............................................................................12

12.1.1 Avant......................................................................................................................... 12

12.1.2 modification...............................................................................................................12


Memo bconsole

12.1.3 après.......................................................................................................................... 12

12.2 Lister les tables disponible dans sqlite de bconsole.........................................................13

12.3 Liste des champs disponibles dans la table 'Media'..........................................................13

13 Estimer la taille de la prochaine sauvegardes.........................................................................15

14 Lancer une commande bconsole depuis un terminal...............................................................15

15 Annuler une commande...........................................................................................................15


Memo bconsole

1 Voir les différentes travaux effectués par bacula

1.1 Commande list jobs

*list jobs

Automatically selected Catalog: MyCatalog

Using Catalog "MyCatalog"

JobId Name StartTime Type Level JobFiles JobBytes JobStatus

2 JobSauvegarde 2015-04-07 19:45:31 B F 40612 3452565385 T

5 JobSauvegarde 2015-04-07 20:26:10 B I 38 95126219 T



14 JobSauvegarde 2015-04-08 01:00:34 B D 604 2177332 T



22 BackupCatalog 2015-04-09 02:17:10 B F 6 24972071 T

23 JobSchedulePost 2015-04-09 02:17:19 B F 0 0 T

1.2 Commande sqlquery

*sqlquery

Enter SQL query: select JobId,Name,StartTime,Type,JobBytes/(1024*1024) as JobMega from job;

+-------+-----------------+---------------------+------+---------+

| JobId | Name | StartTime | Type | JobMega |

+-------+-----------------+---------------------+------+---------+

| 2 | JobSauvegarde | 2015-04-07 19:45:31 | B | 3292 |

| 5 | JobSauvegarde | 2015-04-07 20:26:10 | B | 90 |

| 8 | JobSauvegarde | 2015-04-07 20:30:34 | B | 3381 |

| 11 | JobSauvegarde | 2015-04-07 21:17:48 | B | 3381 | / 24 Version du 10 Avril 2015

Memo bconsole

| 14 | JobSauvegarde | 2015-04-08 01:00:34 | B | 2 |

| 18 | JobSauvegarde | 2015-04-08 13:02:19 | B | 3381 |

| 21 | JobSauvegarde | 2015-04-09 01:00:39 | B | 2 |

| 25 | JobSauvegarde | 2015-04-10 01:00:37 | B | 3428 |

| 29 | JobSauvegarde | 2015-04-11 01:00:35 | B | 2 |

| 33 | JobSauvegarde | 2015-04-12 01:00:31 | B | 3428 |

| 37 | JobSauvegarde | 2015-04-13 01:00:33 | B | 2 |

| 41 | JobSauvegarde | 2015-04-14 01:00:47 | B | 55 |

| 42 | BackupCatalog | 2015-04-14 02:17:19 | B | 35 |

| 43 | JobSchedulePost | 2015-04-14 02:17:30 | B | 0 |

+-------+-----------------+---------------------+------+---------+

2 Afficher les message de bacula (stocker aussi dans les log)*messages

08-Apr 13:33 127.0.0.1-fd JobId 18: Could not stat "/etc/cups/ppds.dat": ERR=No such file or directory

08-Apr 13:35 127.0.0.1-fd JobId 18: shell command: run ClientAfterJob "sudo /usr/share/eole/bacula/baculaconfig.py --unlock --backup_ok --jobType=sauvegarde --jobID=18"

08-Apr 13:35 127.0.0.1-sd JobId 18: Job write elapsed time = 00:33:31, Transfer rate = 1.766 M Bytes/second

08-Apr 13:36 127.0.0.1-dir JobId 18: Bacula 127.0.0.1-dir 5.0.1 (24Feb10): 08-Apr-2015 13:36:32

Build OS: i486-pc-linux-gnu ubuntu 10.04

JobId: 18

Job: JobSauvegarde.2015-04-08_13.01.43_48

Backup Level: Full

Client: "127.0.0.1-fd" 5.0.1 (24Feb10) i486-pc-linux-gnu,ubuntu,10.04

…

09-Apr 02:17 127.0.0.1-dir JobId 23: Bacula 127.0.0.1-dir 5.0.1 (24Feb10): 09-Apr-2015 02:17:19

Build OS: i486-pc-linux-gnu ubuntu 10.04


Memo bconsole

JobId: 23

Job: JobSchedulePost.2015-04-09_02.17.00_49

Backup Level: Full

Client: "127.0.0.1-fd" 5.0.1 (24Feb10) i486-pc-linux-gnu,ubuntu,10.04

FileSet: "FileSetDefault" 2013-11-14 11:18:41

Pool: "PoolDefault" (From Job resource)

Catalog: "MyCatalog" (From Client resource)

Storage: "StorageDefault" (From Job resource)

Scheduled time: 09-Apr-2015 02:17:00

Start time: 09-Apr-2015 02:17:19

End time: 09-Apr-2015 02:17:19

Elapsed time: 0 secs

Priority: 99

FD Files Written: 0

SD Files Written: 0

FD Bytes Written: 0 (0 B)

SD Bytes Written: 0 (0 B)

Rate: 0.0 KB/s

Software Compression: None

VSS: no

Encryption: no

Accurate: no

Volume name(s): 127.0.0.1-dir-volume-0001

Volume Session Id: 14

Volume Session Time: 1428433891

Last Volume Bytes: 639 (639 B)

Non-fatal FD errors: 0

SD Errors: 0

FD termination status: OK

SD termination status: OK


Memo bconsole

Termination: Backup OK

09-Apr 02:17 127.0.0.1-dir JobId 23: Begin pruning Jobs older than 6 months .

09-Apr 02:17 127.0.0.1-dir JobId 23: No Jobs found to prune.

09-Apr 02:17 127.0.0.1-dir JobId 23: Begin pruning Jobs.

09-Apr 02:17 127.0.0.1-dir JobId 23: No Files found to prune.

09-Apr 02:17 127.0.0.1-dir JobId 23: End auto prune.

09-Apr 02:17 127.0.0.1-dir JobId 23: shell command: run AfterJob "sudo /usr/share/eole/bacula/baculamount.py --umount"

09-Apr 02:17 127.0.0.1-dir JobId 23: AfterJob: Démontage OK

3 Restauration*restore

First you select one or more JobIds that contain files

to be restored. You will be presented several methods

of specifying the JobIds. Then you will be allowed to

select which files from those JobIds are to be restored.

To select the JobIds, you have the following choices:

1: List last 20 Jobs run

2: List Jobs where a given File is saved

3: Enter list of comma separated JobIds to select

4: Enter SQL list command

5: Select the most recent backup for a client

6: Select backup for a client before a specified time

7: Enter a list of files to restore

8: Enter a list of files to restore before a specified time

9: Find the JobIds of the most recent backup for a client


Memo bconsole

10: Find the JobIds for a backup for a client before a specified time

11: Enter a list of directories to restore for found JobIds

12: Select full restore to a specified Job date

13: Cancel

Select item: (1-13):

4 Voir les types de sauvegardes*list pools

PoolId Name NumVols MaxVols PoolType LabelFormat

1 PoolDefault 1 1 Backup 127.0.0.1-dir-volume-

2 Full-Pool 60 0 Backup 127.0.0.1-dir-full-

3 Diff-Pool 13 0 Backup 127.0.0.1-dir-diff-

4 Inc-Pool 1 0 Backup 127.0.0.1-dir-inc-

5 PoolCatalog 1 1 Backup 127.0.0.1-dir-catalog-

5 Voir le nombre de volumes utilisé par un type de sauvegarde :

Pour les sauvegardes complètes par exemple :

*list pool=Full-Pool

PoolId Name NumVols MaxVols PoolType LabelFormat

2 Full-Pool 60 0 Backup 127.0.0.1-dir-full-


Memo bconsole

6 Voir la configuration d'un type de sauvegarde :*show pool=Full-Pool

Pool: name=Full-Pool PoolType=Backup

use_cat=1 use_once=0 cat_files=1

max_vols=0 auto_prune=1 VolRetention=3 months

VolUse=1 month recycle=1 LabelFormat=127.0.0.1-dir-full-

CleaningPrefix=*None* LabelType=0

RecyleOldest=1 PurgeOldest=0 ActionOnPurge=0

MaxVolJobs=0 MaxVolFiles=0 MaxVolBytes=2000000000

MigTime=0 secs MigHiBytes=0 MigLoBytes=0

JobRetention=0 secs FileRetention=4 years 4 months 8 days 1 hour 43 mins 4 secs

7 La commande « query »*query

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


Memo bconsole

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

17: Count Running Jobs (EOLE:running_jobs)

18: List total bytes by Pool (EOLE:pools_size)

Choose a query (1-18):

8 Lister les volumes utilisés par un jobPour le Jobid 2 par exemple :

* list volume jobid=2

Jobid 2 used 3 Volume(s): 127.0.0.1-dir-full-0075|127.0.0.1-dir-full-0033|127.0.0.1-dir-full-0002

JobId Name StartTime Type Level JobFiles JobBytes JobStatus


Ou bien

*query

Available queries:

...

7: List Volumes used by selected JobId

...

Choose a query (1-18): 7

Enter JobId: 2

JobId VolumeName

2 127.0.0.1-dir-full-0002


Memo bconsole

2 127.0.0.1-dir-full-0033

2 127.0.0.1-dir-full-0075

9 Lister les jobs utilisant un volume*query

Available queries:

…

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

...


Enter Volume name: 127.0.0.1-dir-diff-0021

JobId Name StartTime Type Level Files Bytes Status



10 Trouver les jobs ayant sauvegardés un fichier

Recherchons les sauvegardes de esu.exe par exemple :

*query

Available queries:

1: List up to 20 places where a File is saved regardless of the directory


Memo bconsole

2: List where the most recent copies of a file are saved

...


Enter Filename (no path): esu.exe

JobId Client Path Name StartTime Level JobFiles JobBytes

2 127.0.0.1-fd /home/esu/Console/ esu.exe 2015-04-07 19:45:31 F 40612 3452565385




11 Écriture de requêtes :*sqlquery

11.1 Rechercher

recherchons les volumes dont la date de dernière écriture est avant le 01 mars 2015

Enter SQL query: select VolumeName,LastWritten,VolRetention/(3600*24*30) as VolRetMois from media where LastWritten < '2015-03-01' order by LastWritten;

VolumeName LastWritten VolRetMois

127.0.0.1-dir-full-0037 2015-01-21 14:50:25 3

127.0.0.1-dir-full-0038 2015-01-25 01:15:21 3

127.0.0.1-dir-full-0039 2015-01-25 01:34:46 3

127.0.0.1-dir-full-0040 2015-01-25 01:41:34 3

127.0.0.1-dir-full-0041 2015-01-25 01:47:28 3

127.0.0.1-dir-full-0042 2015-02-01 01:12:07 3

127.0.0.1-dir-full-0043 2015-02-01 01:35:08 3

127.0.0.1-dir-full-0044 2015-02-01 01:43:22 3


(3600*24*30) pour afficher la valeur en mois et non en seconde

Memo bconsole

127.0.0.1-dir-full-0045 2015-02-08 01:02:57 3

127.0.0.1-dir-full-0046 2015-02-08 01:26:26 3

127.0.0.1-dir-full-0047 2015-02-08 01:32:24 3

127.0.0.1-dir-full-0048 2015-02-08 01:38:44 3

127.0.0.1-dir-full-0049 2015-02-15 01:22:23 3

127.0.0.1-dir-full-0050 2015-02-22 01:02:00 3

127.0.0.1-dir-full-0051 2015-02-22 01:26:12 3

127.0.0.1-dir-diff-0071 2015-02-28 01:01:22 1

11.2 Préparation de requêtes pour exécuter en ligne de commande

11.2.1 prune (bconsole)

Enter SQL query: select 'prune yes volume=' || volumename from media where lastwritten < '2015-01-01';

'prune yes volume=' || volumename

prune yes volume=127.0.0.1-dir-full-0010





.

.

.

prune yes volume=127.0.0.1-dir-diff-0067




Memo bconsole


Copier puis coller dans un bloc note pour traitement :

faire du remplacement :

afin d'obtenir :





Memo bconsole




.

.

.







copier coller le résultat dans bconsole

11.2.2 delete (bconsole)

Enter SQL query: select 'delete yes volume=' || volumename from media where lastwritten < '2015-01-01';

'delete yes volume=' || volumename

delete yes volume=127.0.0.1-dir-full-0010





.

.

.


Memo bconsole

delete yes volume=127.0.0.1-dir-diff-0067




Copier puis coller dans un bloc note et procéder comme pour « prune » page 14 .

11.2.3 rm (batch)

Enter SQL query: select 'rm -f ' || volumename from media where lastwritten < '2015-01-01';

'rm -f' || volumename

rm -f 127.0.0.1-dir-full-0010

rm -f 127.0.0.1-dir-full-0011

rm -f 127.0.0.1-dir-full-0012

rm -f 127.0.0.1-dir-full-0014

rm -f 127.0.0.1-dir-full-0015

.

.

.

rm -f 127.0.0.1-dir-diff-0067

rm -f 127.0.0.1-dir-diff-0068

rm -f 127.0.0.1-dir-diff-0069

rm -f 127.0.0.1-dir-diff-0070

Copier puis coller dans un bloc note et procéder comme pour « prune » page 14 .


Memo bconsole

11.3 Exécuter les commandes précédentes

11.3.1 Dans bconsole

*prune yes volume=127.0.0.1-dir-full-0010

The current Volume retention period is: 6 months

There are no more Jobs associated with Volume "127.0.0.1-dir-full-0010". Marking it purged.

*delete yes volume=127.0.0.1-dir-full-0010

This command will delete volume 127.0.0.1-dir-full-0010

and all Jobs saved on that volume from the Catalog

11.3.2 Dans un terminal batch

root@scribe-macon:/mnt/sauvegardes# rm -f 127.0.0.1-dir-full-0010


Memo bconsole

12 Modifier le temps de rétention des volumes

12.1.1 Avant

Enter SQL query: select VolumeName,LastWritten,VolRetention/(3600*24*30) as VolRetMois from media where volumename like '127.0.0.1-dir-full%' order by LastWritten;


127.0.0.1-dir-full-0034 2015-01-21 14:08:07 6

127.0.0.1-dir-full-0035 2015-01-21 14:31:58 6

127.0.0.1-dir-full-0036 2015-01-21 14:39:43 6

127.0.0.1-dir-full-0037 2015-01-21 14:50:25 6

.

.

.

127.0.0.1-dir-full-0004 2015-04-07 21:22:00 6

127.0.0.1-dir-full-0005 2015-04-07 21:50:48 6

127.0.0.1-dir-full-0006 2015-04-07 21:55:24 6

12.1.2 modification

Enter SQL query: update media set volretention='7776000' where volumename like '127.0.0.1-dir-full%';

No results to list.

12.1.3 après

Enter SQL query: select VolumeName,LastWritten,VolRetention/(3600*24*30) as VolRetMois from media where volumename like '127.0.0.1-dir-full%' order by LastWritten;


Memo bconsole

12.3 Liste des champs disponibles dans la table 'Media'

Enter SQL query: select sql from sqlite_master where name='Media';

+---------------------------------------------------------------------------------------+

| sql

+---------------------------------------------------------------------------------------+

| CREATE TABLE Media (

MediaId INTEGER,

VolumeName VARCHAR(128) NOT NULL,

Slot INTEGER DEFAULT 0,

PoolId INTEGER UNSIGNED REFERENCES Pool DEFAULT 0,

MediaType VARCHAR(128) NOT NULL,

MediaTypeId INTEGER UNSIGNED REFERENCES MediaType DEFAULT 0,

LabelType TINYINT DEFAULT 0,

FirstWritten DATETIME DEFAULT 0,

LastWritten DATETIME DEFAULT 0,

LabelDate DATETIME DEFAULT 0,

VolJobs INTEGER UNSIGNED DEFAULT 0,

VolFiles INTEGER UNSIGNED DEFAULT 0,

VolBlocks INTEGER UNSIGNED DEFAULT 0,

VolMounts INTEGER UNSIGNED DEFAULT 0,

VolBytes BIGINT UNSIGNED DEFAULT 0,

VolParts INTEGER UNSIGNED DEFAULT 0,

VolErrors INTEGER UNSIGNED DEFAULT 0,

VolWrites INTEGER UNSIGNED DEFAULT 0,

VolCapacityBytes BIGINT UNSIGNED DEFAULT 0,

VolStatus VARCHAR(20) NOT NULL,

Enabled TINYINT DEFAULT 1,

Recycle TINYINT DEFAULT 0,

ActionOnPurge TINYINT DEFAULT 0,

VolRetention BIGINT UNSIGNED DEFAULT 0,

VolUseDuration BIGINT UNSIGNED DEFAULT 0,


Memo bconsole

MaxVolJobs INTEGER UNSIGNED DEFAULT 0,

MaxVolFiles INTEGER UNSIGNED DEFAULT 0,

MaxVolBytes BIGINT UNSIGNED DEFAULT 0,

InChanger TINYINT DEFAULT 0,

StorageId INTEGER UNSIGNED REFERENCES Storage DEFAULT 0,

DeviceId INTEGER UNSIGNED REFERENCES Device DEFAULT 0,

MediaAddressing TINYINT DEFAULT 0,

VolReadTime BIGINT UNSIGNED DEFAULT 0,

VolWriteTime BIGINT UNSIGNED DEFAULT 0,

EndFile INTEGER UNSIGNED DEFAULT 0,

EndBlock INTEGER UNSIGNED DEFAULT 0,

LocationId INTEGER UNSIGNED REFERENCES Location DEFAULT 0,

RecycleCount INTEGER UNSIGNED DEFAULT 0,

InitialWrite DATETIME DEFAULT 0,

ScratchPoolId INTEGER UNSIGNED REFERENCES Pool DEFAULT 0,

RecyclePoolId INTEGER UNSIGNED REFERENCES Pool DEFAULT 0,

Comment TEXT,

PRIMARY KEY(MediaId)

) |

+---------------------------------------------------------------------------------------+


https://dan.langille.org/2013/03/07/deleting-old-bacula-volumes/@@

https://dan.langille.org/2013/03/07/deleting-old-bacula-volumes/

Memo bconsole

13 Estimer la taille de la prochaine sauvegardes*estimate job=JobSauvegarde


Connecting to Client 127.0.0.1-fd at 127.0.0.1:9102

2000 OK estimate files=44,394 bytes=5,223,375,000

14 Lancer une commande bconsole depuis un terminalroot@scribe-macon:~# echo "list jobs" | bconsole

Connexion au Director 127.0.0.1:9101

1000 OK: 127.0.0.1-dir Version: 5.0.1 (24 February 2010)

Tapez un point (.) pour annuler une commande.

list jobs

Automatically selected Catalog: MyCatalog


+-------+-----------------+---------------------+------+-------+----------+------------+-----------+

| JobId | Name | StartTime | Type | Level | JobFiles | JobBytes | JobStatus |

+-------+-----------------+---------------------+------+-------+----------+------------+-----------+

| 2 | JobSauvegarde | 2015-04-07 19:45:31 | B | F | 40612 | 3452565385 | T |

| 5 | JobSauvegarde | 2015-04-07 20:26:10 | B | I | 38 | 95126219 | T |



| 14 | JobSauvegarde | 2015-04-08 01:00:34 | B | D | 604 | 2177332 | T |








| 42 | BackupCatalog | 2015-04-14 02:17:19 | B | F | 6 | 37490838 | T |

| 43 | JobSchedulePost | 2015-04-14 02:17:30 | B | F | 0 | 0 | T |

+-------+-----------------+---------------------+------+-------+----------+------------+-----------+


Memo bconsole

15 Annuler une commandeTapez un point (.) pour annuler une commande.


Tapez un point .!!

fiche de procédure - accueil -...

Documents