Hi Jerry

I will add a database server to the disklist soon. We have mirror disks 
and Solaris Disk Suit (SDS). This is aplicable also to linux raidtools.

I will:
- stop oracle; metaoffline a submirror and mount it read-only elsewhere
- start oracle
- Run amanda (over the off-lined submirror)
- Stop oracle; umount the submirror and metaonline it
- Start again oracle.

(Its posible that even stop/start oracle is not necesary but
I'm not sure, so I will stop it :)

If you dont have mirror, I agree with Jon LaBadie about wrapping
the tar/dump itself. I did it with smbclient (with a uggly workaround 
to avoid the passwords pipe) and it works, it can do different
things based on the command parameters (host/disk...)

Regards
Jordi


>On Wed, 27 Nov 2002 17:46:21  0100 Andreas Baier
<andreas.baier AT mindmatics DOT de> wrote.
>Hi Jerry,
>
>what a about a very different idea?
>
> > ... of putting a wrapper around amandad,
>
>have you ever tried the Logical Volume Manager?
>
>- shut down the mysql before amanda is going to run
>- issue a snapshot and restart your database
>- mount that snapshot to a specific mountpoint
>- now let amanda perform the backup on the consistent snapshot
>   of your database from that mountpoint
>
>Your benefit would be, that your database is up running while the 
>backup is performed - your downtime would reduced.
>
>Another way - perfrom mysql-dump, this can be done while the database 
>is running, backup the folder to where the dumps did go.
>
>Bye
>
>
>
>-- 
>Andreas Baier
>