Re: Getting a consistent copy
Date: Tue, 21 Jul 2009 10:10:48 -0700 (PDT)
Message-ID: <7435f9c9-2e40-4fdd-9d11-bf85d9976cca_at_y7g2000yqa.googlegroups.com>
On Jul 21, 12:37 pm, gazzag <gar..._at_jamms.org> wrote:
snip
> > One thing we're considering trying here to achieve the same thing
> > though is to use SAN snapshotting, something like this:
>
> > 1) Leave the source running
> > 2) SNAP /u01 on the san
> > 3) Mount the SNAP on a different database server in read/write mode
> > 4) Restart Oracle over there
> > 5) Let it go through a recovery (since we did just crash it)
> > 6) Run a data pump export out of there.
>
> > Is anybody doing something like this? Does anybody know of any
> > subtleties that I should be aware of? In theory the above should work
> > fine, but as one of my colleagues is fond of pointing out, in theory
> > you shouldn't need practise.
...
> Use RMAN. http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/part3....
>
> HTH
Storage based techniques like this are a lot faster and use a lot less
overhead in terms of cpu, io ... etc.
Received on Tue Jul 21 2009 - 12:10:48 CDT