[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