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 / \ _______________________________________________ linux-lvm mailing list linux-lvm@redhat.com https://www.redhat.com/mailman/listinfo/linux-lvm read the LVM HOW-TO at http://tldp.org/HOWTO/LVM-HOWTO/