Re: rac vs dataguard
Date: Thu, 16 Jul 2009 21:27:55 +0200
Message-ID: <6a29f8b0907161227y6a4f27e7v6573b022dc0c8b83_at_mail.gmail.com>
2009/7/16 Stefan Knecht <knecht.stefan_at_gmail.com>
> Some other things to consider that have not yet been mentioned
>
> - You can turn on flashback database for your physical standby, and
> activate it to do your reporting or do tests (that write to the database),
> or you can open it read only. For example you can do this during office
> hours or at predefined times. Then, later on you flash it back and put it
> back into recovery mode during the night. In the event of failure of the
> primary site, you will have to apply all logs to bring the standby up to
> date before you can switch over. So there's a tradeoff of using the
> resources for reporting vs HA (switchover takes longer)
>
> - With 11g, you can even open the physical standby read only while it is in
> recovery mode (take a look at the active data guard option) -- for some
> environments, this may be reason enough to upgrade, as contrary to the
> physical standby that you only open read only at a given point in time (and
> therefore start lagging behind the primary) this is a near-realtime
> reporting solution.
>
> Just my CHF0.02 :-)
>
> Cheers
>
> Stefan
>
commit :)
I've tried to be 'release aware' in my comment, but of course, on each release all possible newer features should be used if you obtain a good benefit
D.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 16 2009 - 14:27:55 CDT