ve with a piece of software more complex than a simple
text editor?
Feel free to throw good money down the drain on an expensive backup
program that will be less feature rich and more buggy, and with a company
less responsive to bug reports than bacula if you like, but everyone else
here knows yo
o status=1.
>> ERR=Child exited with code 1
>
> (Client)RunBefore/AfterJob:
> sticking commands one after another on one line separated by semicolon
> seems not to work propperly.
Probably better therefore to write your own shell script to do everything
you want, save it somewher
4 - Configure Oracle DB in backup mode off.
> 5 - Destroy the Snapshot
You need to swap items 3 and 4 if you use a snapshot. You need to aim to
keep the database in backup mode for as short a time as possible, as
performance is impacted during that time.
--
Mike Holden
http://www.by-ang.c
Ulrich Leodolter wrote:
> PS: RTFM might help too
That sounds interesting. Where can I download that from?
:-)
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including Jewellery, Greetings Cards and Gi
Ulrich Leodolter wrote:
> On Wed, 2009-03-18 at 17:49 +0000, Mike Holden wrote:
>> Ulrich Leodolter wrote:
>> > PS: RTFM might help too
>>
>> That sounds interesting. Where can I download that from?
>>
>
> http://mysqltuner.pl
>
>
> Isn't it
till get
any bounces back anyway if the victim email addresses fail (unknown email
address, quota exceeded etc). A fair percentage of the spam I receive is
bounce messages from spam sent "on my behalf" (i.e. spoofed From address)
to invalid email addresses.
Not a lot I can do about it, unfortun
t need anyone to send me a personal
copy of an email they are sending to the list, because I just end up with
2 copies of it.
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items,
and sends a mail they want to see
a reply to, then it's up to them to ensure that they have a setup that
allows them to see those replies, surely. It's not MY responsibility you
ensure that YOU receive my email, it's yours.
--
Mike Holden
lieve I have anything further to add on the subject, and I respectfully
suggest we all get back to discussing bacula :-)
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including Jewellery, Gree
(my day job) that this can often
produce far more efficient results.
Of course, all options need testing for both speed of execution and
resource usage, bearing in mind that data varies from one installation to
another, and one size may not fit all!
--
M
loop goes round
several million times, the cumulative time becomes significant.
One general rule of thumb of SQL execution is that bulk processing is
almost always faster than processing records individually in a loop.
--
Mike Holden
--
ing a
Flash Recovery Area (FRA) for Oracle backups, rather than using an external
tool,
however good Bacula may be at simple file backups!
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted items,
including Jewellery, Greet
and check the r and x permissions allow the
appropriate user to browse into them.
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including Jewellery, Greetings Cards and Gifts
Charlie Reddington wrote:
> Okay, that makes sense. So if
ng them, I got no error from "estimate" command.
That first one is the suspect. The "find" command expects the first
parameter to be a directory. In that case, it is a filename.
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand cra
I know but this varies
significantly from one database to another), then look into setting up a
FLASH RECOVERY AREA and use that as a staging area for your backups.
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including Jewellery, Greetings Car
or
smaller, just because of recovery times when only a single file needs to
be recovered.
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including Jewellery, Greetings Cards and Gifts
--
aw was http://ubuntuforums.org/showthread.php?t=398332 which heads
towards xfs/jfs for your arena.
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including Jewellery, Greetings Card
mail address to an admin email address for the group.
That said though, Yahoo groups is a bit pants really, and I wouldn't have
subscribed at all if there was any other way!
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including J
on was finalised, and this forced
them to change their coding practices to cope with their final choice of
product. Barmy!
I used CVS for my own stuff at work (as a DBA/Unix guy I was outside the
main development loop so wasn't tied in with what they were using), and
was very happy with it.
You could also look at using iotop and iftop to check disk and network
throughtput at the problem times to see what is going on.
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including Jewellery, Greetings Cards and Gifts
stuff like that!
Be wary of using fancy labels that include the date etc when the volume can be
re-used
at a later date, because the violume name will then be very misleading. It's
only really
useful for volumes that will only be written once.
--
Mike Holden
http://www.by-ang.com - the pla
l
the other output columns in the query would need to be listed in the GROUP BY
clause.
If you want size by client, then you don't need to be listing any columns other
than
Client.Name and sum(JobBytes) in the SELECT clause.
--
Mike Holden
http://www.by-ang.co
list but not in the GROUP BY
clause. I
would suggest (to give standard SQL code), that you change the "GROUP BY clause
to
"GROUP BY Client.Name, Pool.Name". You might want to update the ORDER BY in the
same
way.
--
Mike Holden
http://www.by-ang.com -
t!!!
Automated removal as detailed by Marek above is difficult to implement simply,
because
you will probably have multiple retention periods on your files, and you need
to take
this into account in your deletion. Plus, deleting the files while they are
still listed
in the bacula database is possib
complicated but more accurate as you are
> letting bacula decide what gets removed instead of externally forcing
> the issue.
>
> John
I posted a script recently on another thread which takes care of purging,
deleting
volumes and deleting the files based on individual retention periods
"idiot limit" to stop people running huge queries that will cripple
the
database performance - I'm not suggesting you are an idiot, just that the
database maybe
thinks bacula is an idiot ;-)
Either this is due to a bug in bacula, or you are hitting some limit in your
database
configurati
ly not adequate, since
you need
execute permission as well. 666 gives rw-, while you need rwx to allow the
bacula server
to descend into the directories.
Assuming you are running bacula as root, and root owns both /mnt and /mnt/mnt1,
then
/mnt and /mnt/mnt1 should have 755 permissions, or even
y
> problem :) It looks like it's working first time after two months of trying
> to make it
> work.
store0001 -> store0010 should be files, not directories. That is your problem!
You are
now using a different destination creating files called "backup", so th
e entire array. Keep them separate and you only lose the disk that failed
and
the other 11 continue to work fine.
One "bug" partition could well be an aposite typo :-)
--
Mike Holden
http://www.by-ang.com - the place
n recover
more
than I am currently getting. Of course, Sod's Law dictates that the files I am
most
interested in are closer to the end of the volume than the beginning!
I should also mention that I am using bacula version 3.0.3 on fedora 12,
although
the backup was originally created under ba
Nobody got any clues at all? (Sorry for top-post, seemed more appropriate this
time!!!)
--
Mike Holden wrote:
> Been struggling with a difficult restore for a few days now, and need some
> help
> please.
>
> The short story is that I am trying to recover files from a disk archi
Martin Simmons wrote:
>>>>>> On Wed, 24 Feb 2010 20:45:01 -, Mike Holden said:
>>
>> bextract: record.c:465-0 Block=219743 Ver=2 size=64512
>> bextract: record.c:473-0 Enter read_record_block: remlen=56750 data_len=222
>> rem=0
>> blkver=2
- should backups be pruned, purged and truncated
automatically if
the backup fails?
--
Mike Holden
http://www.by-ang.com - the place to shop
for all manner of hand crafted items,
including Jewellery, Greetings Cards and Gifts
ytes=0
> MigTime=0 secs MigHiBytes=0 MigLoBytes=0
>
> Thanks.
If I read that right, you have retention set to 1 month as well, so
it will recycle after one month! Recycling happens at the first
limit reached, so 1 month happens before 45 volumes.
--
Mike Holden
http://w
ume Jobs = 1?
I appreciate that this is something of a corner case!
I also appreciate, before someone else point it out, that using
labels with dates in them etc is not a good idea due to recycling
files, but these files are not recycled, and only used once each, so
there is no future confu
mario parreño wrote:
> Check file /var/run/bacula-dir.9101.pid
Did you do this part?
If this file exists, and the director is not running, then the
startup script thinks that it _is_ running.
If the director is _not_ running, you can safely remove that file
and try again.
--
Mike Holden
h
e instances of the same extension in
different cases by using UPPER() like this:
OR UPPER((Filename.Name LIKE "%MPG"))
--
Mike Holden
http://www.by-ang.com - th
r: sqlite.c:178 Database
> /var/lib/bacula/bacula.db does not exist, please create it.
The sqlite.c error in the log would suggest that maybe it is trying
to use sqlite rather than mysql?
--
Mike Holden
http://www.by-
wer priority, so that it runs immediately after the first one
completes.
Not sure if concurrency could be an issue here? You may need to
ensure only 1 job runs at a time.
--
Mike Holden
http://www.by-ang.com - the place to shop
for all manner of hand crafted it
; necessary.
Have you downloaded and installed the various scripts mentioned on
that wiki (namely runbeforebackup.sh, runafterbackup.sh etc - there
are 5 named)?
If so, what path have you saved them at, and have you made the *.sh
scripts executable after downloading them (using the chmod command)
n of the appropriate sh or bash or ksh
executable file in this case.
5. sudo or some other security mechanism (SELinux etc) is blocking
execution. You may be able to check the logs for these applications
to see if this is the case.
--
Mike Holden
http://www.by-ang.com - the place to shop
for all manner
scripts we
may be able to spot what is wrong!
Can you run the hotbackup script directly in sqlplus using "@
runhotbackup.sql" from within sqlplus? If so, then the problem is
elsewhere, if not then error message sill
0)) is not big enough. I would
suggest increasing this value to 2 million, which is the maximum
value allowed. I've also go no idea why this is run as a separate
exec call at the top, rather than as the first line of the pl/sql
script!
If I can find how to regist
Mike Holden wrote:
> If I can find how to register as a wiki contributor, I'll update the
> page, otherwise somebody else may wish to take on these minor
> modifications?
I've registered and updated the wiki page at
http://wiki.bacula.org/doku.php?id=application_specific_backup
an Oracle
expert, as that is what I get paid for in my day job :-)
--
Mike Holden
http://www.by-ang.com - the place to shop
for all manner of hand crafted items,
including Jewellery, Greetings Cards and Gifts
--
This
e, which is
omitted in the second version? With my experience of Oracle, that
looks like an "execution hint", in other words a directive to help
the database choose the most efficient way of retrieveing the data.
It's a specially formed comment, hence the /* ... */, so you ei
this is
an email forum, and as such ought to be conducted in plain text, not
half-html. Dan isn't complaining that we won't read config files, or
that you shouldn't post them, but rather, the file that was posted
was difficult/impossible to read. If you want help, ask for it in a
t;> I think the Wiki has a list that is a bit more up to date:
>>
>> http://wiki.bacula.org/doku.php?id=faq#what_do_all_those_job_status_codes_mean
>
> I'm glad all the work is being recorded on the wiki. When I get my
> documentation hat on, the docs will be updated.
In a
48 matches
Mail list logo
