I have to agree. Dumping the database is the way. In fact, although there are
third party utilities that will allow you to backup a live Oracle database
without stopping it, they cost a fortune, they are only licensed on an
individual machine basis, and they do not have support for AMANDA.
I backup our 24*7*365 Oracle9i database by doing an export (the Oracle equiv.
to MySQL's dump) and backing up the resulting .dmp file. In the event a
recovery is required I can then drop the schema contents and import the dump
file to restore to the latest backup.
Yes, I am backing up a live Oracle instance with AMANDA via SAMBA.
Keith
D. Keith Higgs <mailto:dkh2 AT cwru DOT edu> x0559
Case Western Reserve University, Webmaster - University Library
Additional Information at http://www.cwru.edu/UL/ and http://keith.cwru.edu/
"Follow the white rabbit."
> -----Original Message-----
> From: owner-amanda-users AT amanda DOT org
> [mailto:owner-amanda-users AT amanda DOT org] On Behalf Of Bort, Paul
> Sent: Wednesday, April 02, 2003 03:40 PM
> To: amanda-users AT amanda DOT org
> Subject: RE: Backing up MySQL tables
>
>
> Dumping the database and then backing up the dump is the
> right way to go.
> Think of the dump as a snapshot of the database. By backing
> up the snapshot,
> you know you're getting a consistent and restorable backup. If you're
> worried about the disk space it takes, you can compress it.
> I've seen this
> method used for MySQL, PostgreSQL, MS SQL, and Oracle.
>
> > -----Original Message-----
> > From: Alex Thurlow [mailto:alex.thurlow AT skylist DOT net]
> > Sent: Wednesday, April 02, 2003 1:28 PM
> > To: amanda-users AT amanda DOT org
> > Subject: Backing up MySQL tables
> >
> >
> > I need to start backing up MySQL tables on one of my
> > machines, but I've
> > heard that to you run the risk of table corruption if you
> > just copy the
> > mysql directory while MySQL is running. Stopping the
> > database is not an
> > option, and the only solution I've come up with is having
> > another script do
> > a mysql dump and then backing up that. It seems like a waste
> > of time and
> > resources to basically do 2 backups though. I was just
> > wondering what
> > anyone here does for MySQL backups on their own systems?
> >
> > Alex Thurlow
> >
>
|