Re: SV: Logical standby transaction_consistency parameter to none

Birkir,
How is this DWH using the Logical Standby? If you use it for E.G. ETL, you might consider switching to Physical Standby, and open that in Read Only mode periodically. It will easier keep up with the primary. When you create a cron job that sets the database in Read-only mode every morning, say at 7am, and switches it back to managed recovery at 7 pm, the DWH can be feeded, and you have a nice DR database available as well. Finally, you can get rid of the supplemental logging, which will save the amount of redo on your primary.

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

Upcoming appearances:

• Mar 6-10, 2005: Dallas, Hotsos Symposium: Data Guard Performance Issues On Fri, 2005-02-18 at 16:02, Birkir Bjornsson wrote:

> Hi
>
> Thanks for your reply. I will look at the white paper you suggested. The st=
> andby database in this case is used as a query database for a data warehous=
> e. I will probably try setting it to none and If that doesn=B4t help me I g=
> uess I will have to re-instantiate the Database.
>
> Thanks again for your reply =
>
> Birkir Bjornsson
>
> -----Upphafleg bo=F0-----
> Sendandi: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.o=
> rg] Fyrir h=F6nd Mark Bole
> Sent: 18. febr=FAar 2005 14:17
> Samrit: oracle-l_at_freelists.org
> Efni: Re: Logical standby transaction_consistency parameter to none
>
> Birkir Bjornsson wrote:
> > =3D =
>
> > =
>

--
http://www.freelists.org/webpage/oracle-l