Adam.birds: Created page with "Create a file called '''reclaimspace.sh''' in the '''/root''' directory. To do this do the following:

 cd /root

 vi reclaimspace.sh

Then copy and pa..."

2016-04-28T10:13:56Z

Created page with "Create a file called '''reclaimspace.sh''' in the '''/root''' directory. To do this do the following: <pre> cd /root </pre> <pre> vi reclaimspace.sh </pre> Then copy and pa..."

New page

Create a file called '''reclaimspace.sh''' in the '''/root''' directory. To do this do the following:

<pre>
cd /root
</pre>

<pre>
vi reclaimspace.sh
</pre>

Then copy and paste the following in to that file:

<pre>
#***********************************************************
#!/bin/bash
## get a list of volumes that do exist on the disk but do not in the catalog.
CATALOGVOLS=$(mktemp -p /tmp catvols.XXXXXXXX);
DISKVOLS=$(mktemp -p /tmp diskvols.XXXXXXXX);
mysql -N -u root bacula <<<'SELECT VolumeName from Media' >$CATALOGVOLS;
find /home/bacula -name "srv-*" -printf "%f\n" | egrep -v \.bsr$ >$DISKVOLS;

## iterate through catalogvols and look for the diskvol entry
cat $DISKVOLS | while read VOL; do
if ! grep -q $VOL $CATALOGVOLS; then
echo -n $VOL does not exist! Deleting ..;
find /home/bacula -name $VOL -exec rm -f {} \;
echo "Deleted"
fi
done

## Get a list of jobs which failed and are using a volume unnecessarily.
mysql -N -u root bacula <<<'
SELECT DISTINCT Job.JobId,VolumeName FROM Media LEFT JOIN (Job, JobMedia)
ON (Media.MediaId = JobMedia.MediaId
AND Job.JobId = JobMedia.JobId
AND Job.JobStatus NOT IN ("C","R","e","T"))
WHERE Media.VolumeName LIKE "srv-%"' | while read DATA; do
JOBID=$(echo $DATA | tr -s " " | cut -d " " -f1)
VOL=$(echo $DATA | cut -d" " -f2)

COUNT=$(mysql -N -u root bacula <<<'SELECT COUNT(DISTINCT Job.JobId) from Job, Media, JobMedia WHERE VolumeName="'$VOL'" AND Media.MediaId = JobMedia.MediaId AND Job.JobId = JobMedia.JobId AND JobStatus IN ("C","R","e","T")')
if [ "$COUNT" -gt "0" ]; then
# the volumes in use. Don’t delete!
continue;
fi

if [ "$JOBID" != "NULL" ]; then
echo -e "delete job JobID=$JOBID\nyes\nquit\n" | /usr/sbin/bconsole 2>&1 >/dev/null
fi
echo -n "Deleting $VOL as unusable.. "
echo -e "delete volume=$VOL\nyes\nquit\n" | /usr/sbin/bconsole 2>&1> /dev/null
find /home/bacula -name $VOL -exec rm -f {} \;
echo "OK";
done
rm $CATALOGVOLS;
rm $DISKVOLS;
#***********************************************************
</pre>

Then use the following command to make the '''reclaimspace.sh''' script executable:

<pre>
chmod +x reclaimspace.sh
</pre>

Then execute the file using the following command:

<pre>
./reclaimspace.sh
</pre>

[[Category:Bacula]]
[[Category:Backups]]
[[Category:Bash Scripts]]
[[Category:Scripts]]
[[Category:Linux]]
[[Category:Contents]]

Bacula Reclaim Space Script - Revision history

Adam.birds: Created page with "Create a file called '''reclaimspace.sh''' in the '''/root''' directory. To do this do the following:
cd /root

vi reclaimspace.sh
Then copy and pa..."