Copying Oracle data files

[Paul Slootman]

On Wed 10 Nov 2004, Guilhem Bichot wrote:
> 
> What MySQL or Oracle can bear is if your copy is instant. On Linux
> there is LVM for that: you create the LVM snapshot, rsync files,
> discard the snapshot. It does work. Here's an intro to LVM:

It's also advisable to put oracle into "backup mode" before making the
snapshot. That's what we did at a large oracle place where I used to
work (using Solaris and a NetApp filer). Making the snapshot only takes
a couple of seconds, so this has negligible impact on the performance.


Paul Slootman