[prev in list] [next in list] [prev in thread] [next in thread]
List: linux-lvm
Subject: Re: [linux-lvm] Using LVM to snapshot Oracle
From: Klaus Strebel <klaus.strebel () gmx ! net>
Date: 2006-02-21 10:21:14
Message-ID: 43FAE99A.4060609 () gmx ! net
[Download RAW message or body]
Luca Berra schrieb:
> 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
>>
>
Hi Mitchell, hi Luca,
well, despite i prefer using RMAN ( since 9iR2 it's once configured and
then you can always do your backup with a simple 'backup database' ) but
you need your database running in archived mode, which brings additional
space and backup needs.
The way Luca describes for a online-backup is the usual way that's
working since Oracle 7 ( or even 6, but just work with Oracle since 7.0
;-) ), but i think, if all ( really all !) files are on the same
snapshout and the snapshot is big enough( ;-) ), you should make a
logswitch, create a readonly snapshot, copy all the files ( including
control-files, and redo-logs ) and remove the snapshot. You can then
carefully try to use these files to restore the database. If you have
enough diskspace, you can shutdown your instance, rename all the files (
again incl. control-files and redo-logs ), restore the copies from the
snapshot and start the database carefully ( startup nomount; alter
database mount; select file#, name, status from v$datafile; -> all file
should be in status system or online ; alter database open; -> up again ).
I have nither the time nor the resources to test this on my own. But you
can share your results with us :-)
Ciao
Klaus
--
Mit freundlichen Grüssen / best regards
Klaus Strebel, Dipl.-Inform. (FH), mailto:klaus.strebel@gmx.net
/"\
\ / 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/
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic