[linux-lvm] Using LVM to snapshot Oracle

Luca Berra bluca at comedia.it
Mon Feb 20 22:11:14 UTC 2006


On Mon, Feb 20, 2006 at 11:05:32PM +0100, Luca Berra wrote:
to clarify:
>you can do hot backup, but you will need to tell oracle you are doing
>so:
>
>you will need to have oracle in archive log mode
>
>you will need to manually set all tablespaces in backup mode:
>alter tablespace XXX begin backup; (for all tablespaces)
>alter system switch logfile;
the snapshot creation part goes here

NO >do your backup including the archive logs

>alter tablespace XXX end backup; (for all tablespaces)

do your backup here including the archive logs
destroy the snapshot here.

>it is a simple sql script to code
>

-- 
Luca Berra -- bluca at comedia.it
        Communication Media & Services S.r.l.
 /"\
 \ /     ASCII RIBBON CAMPAIGN
  X        AGAINST HTML MAIL
 / \




More information about the linux-lvm mailing list