Enhanced features of Oracle 11g R2 data guard

We have provided an overview of the unique features of Oracle 11g R2. At the same time, we also describe the enhancement of the data warehouse performance related to Oracle 11g R2. The following describes the enhanced features of Data guard in Oracle 11g R2:

The backup database management is improved. Data guard specifically improves the data warehouse business. Oracle 11g R2 provides many management functions for backup databases, including physical backup, logical backup, and snapshot backup databases.

Integrated Application failover. Early data guard provided relatively fast Application session Failover, and used the Transparent Application Failover, TAF) feature during Failover and Failover, but Oracle 11g R2 now provides Fast Application Notification, FAN) function, making Application failover faster.

Real-time application and lagging application restrictions. As part of the independent license activity data guard option, Oracle 11g R1 provides the Real-Time Real-time application function to redo logs to the physical standby database in real time, even if it is read-only ), this function is similar to the function of querying read-only standby databases when redo logs are being applied in real time. It provides an optional solution for the read-only data warehouse to use basic replication.

But there is an important exception:

There is no way to deal with any significant delay in redo logs on the physical standby database. Oracle 11gR2 provides a new session-level parameter STANDBY_MAX_DATA_DELAY, which specifies an acceptable delay time unit: seconds). If the data becomes invalid due to timeout, oracle 11g R2 simply rejects queries and throws an exception ORA-03172 ).

Supports table compression and SecureFiles. Oracle 11g R2 now supports application redo and logical backup databases. The primary database either uses basic tables to compress DSS or uses advanced tables to compress OLTP ), because LogMiner also supports conversion of redo entries, LogMiner and SQL applications now support redo of applications in the logical backup database containing SecureFile LOB.

The above content describes the enhanced features of Oracle 11g R2 data guard, hoping to help you in this regard.