Oracle + LVM = Mirrored Backups?

From: <fpuhan_at_my-deja.com>
Date: Fri, 19 Nov 1999 02:21:58 GMT
Message-ID: <812c83$pm9$1@nnrp1.deja.com>

During a recent discussion with a tech from Hewlett Packard, I was informed that it is possible to perform backups on VLDBs with a minimum of downtime by using LVM (Logical Volume Manager) to create mirrored copies of Oracle's data files, then by "breaking" the mirror, backup the mirror copies of the data files, and the re-sync the mirror once the backup is complete. The total downtime I'm told is in the minutes, if not seconds.

This looks like a potential answer for me to offer to some of my company's clients who are running multi-gigabyte databases, where backup time stretches into the hours.

Does anyone know of any white papers, web sites, or detailed information on how to do this? If it helps, our clients are using HP-UX, either 10.20 or 11.00 and Oracle 7.3.4, or 8.0.5.

Many thanks in advance,

=Fred=

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 18 1999 - 20:21:58 CST