Re: [linux-lvm] Using LVM to snapshot Oracle

[Luca Berra <bluca comedia it>]

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 comedia it
       Communication Media & Services S.r.l.
/"\
\ /     ASCII RIBBON CAMPAIGN
 X        AGAINST HTML MAIL
/ \