Newsletters Archive - All

If you would like to know more about the Newsletter, please email me.

  Data Protection Modes - (Oracle9i Release 2) — (05-September-2006)

With the introduction of 9i Release 2, Oracle Data Guard provides the ability 
to run the standby database in one of the following three mutually exclusive 
data protection modes: Maximum Protection, Maximum Availability, Maximum 
Performance. These three new modes replaced the Guaranteed, Instance, Rapid, 
and Delayed modes of data protection available in Oracle9i Release 1 (9.0.1). 
Each of the three modes provides a high degree of data protection; however they 
differ with regards to data availability and performance of the primary 
database. The DBA needs to carefully take into account the need to protect the 
data against any loss vs. availability and performance expectations of the 
primary database.

The following article provides complete coverage of the three data protections 
modes available in Oracle9i Release 2 and can be used when trying to decide on 
the one that best meets the needs of your business. Also explained in this 
article is how Log Transport Services works to support these new protection 
modes as well as the steps necessary to configure the standby database to the 
desired protection mode.

Jeffrey M. Hunter
Sr. Database Administrator