Re: Database mirroring

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

>Hi,
>
>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.

-a

.......
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