Re: Database mirroring
From: gazzag <gareth_at_jamms.org>
Date: Tue, 18 Mar 2008 04:43:01 -0700 (PDT)
Message-ID: <30506c2a-974b-4094-899e-39ae9f2e5fe1@d62g2000hsf.googlegroups.com>
Date: Tue, 18 Mar 2008 04:43:01 -0700 (PDT)
Message-ID: <30506c2a-974b-4094-899e-39ae9f2e5fe1@d62g2000hsf.googlegroups.com>
On 17 Mar, 21:19, "astalavista" <nob..._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
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