Re: SV: Logical standby transaction_consistency parameter to none
- From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
- To: birkir@xxxxxxxx
- Date: Fri, 18 Feb 2005 20:18:38 +0100
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxx=
> rg] Fyrir h=F6nd Mark Bole
> Sent: 18. febr=FAar 2005 14:17
> Samrit: oracle-l@xxxxxxxxxxxxx
> Efni: Re: Logical standby transaction_consistency parameter to none
>
> Birkir Bjornsson wrote:
> > =3D =
>
> > =
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
