Using rsync:

shutdown db
rsync all data to backup disk/raid/machine
start db
amanda backup the backup disk/raid/machine

The first run of rsync will be the slowest - must send all data to make a 
complete copy. The next run of rsync will be much faster. rsync only sends 
new or changed data. So if 3 bytes in a 1G file are changed, only the 
changed 3 bytes are sent. Plus you have the lastest backup copy in an 
easily retrieved format. Your rsync speed will depend on the size of the 
db & the amount of daily changes.


This is how I backup an Oracle application using amanda. 


-----------------------------------------------------
toby bluhm
it support, development systems
philips medical systems, cleveland ohio
tobias.bluhm AT philips DOT com
440-483-5323

Celeron:
Derived from the latin word, 'celer', meaning 'fast' or 'swift', as in 
'celery' - the fastest of all vegetables.