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 <[EMAIL PROTECTED]> 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 >
