Re: Database mirroring

From: NetComrade <>
Date: Tue, 18 Mar 2008 00:28:21 GMT
Message-ID: <>

On Mon, 17 Mar 2008 22:19:57 +0100, "astalavista" <> wrote:

>I have a DW which is loaded every night
>The load process is very heavy so the database is not
>ready in the morning.
>How can I have a other database to open to the users in the morning
>until the loading is finished and then switch with updated database ?
>Somthing like a day-1 database....
>Standby database is a way to go ?
>Thanks in advance

Tune the loading.. You can do what you describe (with standby), but then I am pretty sure you'll be paying for 2 licenses.


We run Oracle 9iR2,10gR2, 10g2RAC on RH4/RH5 and Solaris 10 (Sparc) remove NSPAM to email Received on Mon Mar 17 2008 - 19:28:21 CDT

Original text of this message