|
== Disadvantages ==
Version 11.2.0.1.0 and earlier is somewhat unreliable and buggy when dealing with physical-standby operations.{{Citation needed|date=April 2012}}
If the network link connecting primary and standby is over-subscribed, the redo logs are not applied in chronological order, which can result in large gaps appearing in the available redo at the standby. Such a condition results in the standby being behind the primary.
Active Data Guard, an added-cost option bundled within "Enterprise Edition" of the version 11 [[Oracle RDBMS]], allows purely read-only access.<ref name="Oracle Active data Guard"/>
Substantial cost-savings are possible using Oracle Standard Edition (SE), Oracle Standard Edition One (SE1) or even Oracle Express (XE) with use of third-party products like Trivadis TVD-Standby<ref>
http://www.trivadis.com/en/produkte/datenbank-tools/tvd-standbytm.html
{{cite web
| title = Trivadis TVD-Standby
| url = http://www.trivadis.com/en/produkte/datenbank-tools/tvd-standbytm.html
| work =
| publisher = Trivadis AG
| date =
| year = 2012
| month = 05
| archivedate =
| accessdate = 2012-08
| quote =
}}</ref>
to provide [[high availability]] for a database system.<ref>
{{cite web
| title = Consider Oracle Standard Edition to Reduce Database Management System Costs
| url = http://www.gartner.com/DisplayDocument?id=1312417
| work = Gartner RAS Core Research Note G00174599
| publisher = Gartner Publicationzs
| date = 03/2010
| year =
| month =
| archivedate =
| accessdate = 2010-03
| quote = With servers becoming more powerful, Oracle Standard Edition One and Oracle Standard Edition should be considered as an alternative to Oracle Enterprise Edition as a DBMS platform with potentially large cost savings.
}}</ref>
== See also ==
| 