Re: Using LVM to snapshot Oracle

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/

[Index of Archives]     [Gluster Users]     [Kernel Development]     [Linux Clusters]     [Device Mapper]     [Security]     [Bugtraq]     [MIPS Linux]     [ARM Linux]     [Linux Security]     [Linux RAID]

  Powered by Linux