Re: Database mirroring

From: gazzag <>
Date: Tue, 18 Mar 2008 04:43:01 -0700 (PDT)
Message-ID: <>

On 17 Mar, 21:19, "astalavista" <> 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

As Netcomrade suggested: tune your loading. How much data are you loading? How is your system configured? What O/S and Oracle versions?

HTH -g Received on Tue Mar 18 2008 - 06:43:01 CDT

Original text of this message