Re: Getting a consistent copy
Date: Mon, 20 Jul 2009 20:23:32 +0200
On Mon, 20 Jul 2009 10:09:38 -0700 (PDT), Pat <pat.casey_at_service-now.com> wrote:
>We're running Oracle 10.2.0.4 on RedHat.
>We're supporting an application that requires completely consistent
>copies when it sets up what you can think of as additional cluster
>Our current process is:
>1) Stop the source application
>2) expdp the database (about 100G)
>3) restart the source application
>4) load the dump into the target server and let the app "catch up" on
>that node until it can come online
>This has a rather significant problem in that it requires we stop the
>source application (which is no-bueno).
>We tried using exp with the consistent flag, which dumped ok, but when
>we times the loads back into the system they taking > 1 day (whereas
>the data pump import takes about 2 hours).
>One thing we're considering trying here to achieve the same thing
>though is to use SAN snapshotting, something like this:
Didn't consider using a standby database?
Senior Oracle DBA Received on Mon Jul 20 2009 - 13:23:32 CDT