OracleDataguardNewFeatures历程10g19c

Oracle DataGuard已从最初只是做为一种容灾功能，到后期分担Primary SITE的负载，实现读写分离，在实时性，可用性，灵活性，分析诊断、功能种类引入了大量的特性，逐渐已成本了一个oracle生产环境标配, 这篇简单记录从10.1 到19c dataguard的主要新特性。

New Features Data Guard 10.1

✔ Data Guard Broker Support for RAC

✔ Automatc LogMiner Confguraton

✔ Log Miner Support for Index-Organized Tables

✔ LogMiner Support for More Types: LONG, Multbyte CLOB and NCLOB

✔ Fine-Grained Supplemental Logging

✔ Secured Redo Transmission

✔ Uniquely Named Databases with DB_UNIQUE_NAME

✔ Simplifed Zero Data Loss for Data Guard SQL Apply

✔ Zero Downtme Instantaton for SQL Apply

✔ Real Time Apply

✔ Automatng Recovery Through Open Resetlogs in Standby Databases

New Features Data Guard 10.2

✔ Fast-Start Failover

✔ Automatc Conversion of the Primary Database to a Standby Database Upon Failover

✔ Optmized Asynchronous Redo Transmission

✔ Faster Redo Apply Failover

✔ Faster SQL Apply Failover

✔ Additonal Data Type Support in LogMiner and SQL Apply

✔ Automatc Deleton of Applied Archive Logs

✔ Data Guard: Improved Manageability for Redo Transport, Log Apply, and Broker

✔ Easy Conversion of a Physical Standby Database to a Reportng Database

✔ Flashback Across Data Guard Switchovers

✔ Fine-Grained, Automated Tracking of SQL Apply Runtme Performance

✔ Optmized Creaton of Logical Standby Database

New Features Data Guard 11.1

✔ Fast-Start Failover for Maximum Performance Mode

✔ Compression of Redo Trafc (Only for Gap Resoluton)

✔ Real-Time Query Capability of Physical Standby Database

✔ Fast Role Transitons in a Data Guard Confguraton

✔ User Confgurable Conditons to Initate Fast-Start Failover

✔ Dynamic Setng of Oracle Data Guard SQL Apply Parameters

✔ Enhanced Data Guard Broker Based Management Framework

✔ Enhanced Data Guard Management Interface (Using SQL*Plus)

✔ Histogram for Redo Transport Response Time

✔ Snapshot Standby

✔ Strong Authentcaton for Data Guard Redo Transport

✔ Enhanced DDL Handling in Oracle Data Guard SQL Apply

✔ Enhanced Oracle RAC Switchover Support for Logical Standby Databases

✔ Oracle Scheduler Support in Data Guard SQL Apply

✔ Fine-Grained Auditng (FGA) Support in Data Guard SQL Apply

✔ Support Transparent Data Encrypton (TDE) with Data Guard SQL Apply

✔ Support XMLType Data Type (Only CLOB) in Data Guard SQL Apply

✔ Virtual Private Database (VPD) Support in Data Guard SQL Apply

✔ SMP Scalable Redo Apply

✔ Archive Log Management Improvements

New Features Data Guard 11.2

✔ Automatc Block Repair

✔ Compressed Table Support in Logical Standby Databases and Oracle LogMiner

✔ Confgurable Real-Time Query Apply Lag Limit

✔ Integrated Support for Applicaton Failover in a Data Guard Confguraton

✔ Support Up to 30 Standby Databases

✔ Universal Connecton Pool (UCP) Integraton with Oracle Data Guard

✔ Enable Sampling for Actve Data Guard

✔ SQL Apply Support for Object Relatonal Model

✔ SQL Apply Support for Binary XML

New Features Data Guard 12.1

✔ Global Data Services (GDS),transparent to failover / switchover no client reconfiguration required.

✔ Data Guard Support for Separaton of Duty (SoD)

✔ Advanced Data Guard Broker Manageability

✔ Oracle Data Guard Broker Support for Cascaded Standby Databases

✔ Fast Sync

✔ Single Command Role Transitons

✔ Real-Time Apply is Default Setng for Data Guard

✔ Resumable Switchover Operatons

✔ Actve Data Guard Enhanced Security

✔ Actve Data Guard Support for DML on Global Temporary Tables

✔ Actve Data Guard Support for Sequences

✔ Actve Data Guard Real-Time Cascade

✔ Actve Data Guard Far Sync

✔ SQL Apply Extended Data Type Support (EDS)

✔ SQL Apply Support for Objects, Collectons, and XMLType

✔ SQL Apply Support for XMLType

✔ SQL Apply Support for SecureFiles LOBs

✔ Data Guard Rolling Upgrade Support for Advanced Data Types

✔ Data Guard Rolling Upgrade Support for XDB Repository

✔ Disaster Protecton During Database Rolling Upgrade

✔ Oracle Advanced Queuing (AQ) Support for Data Guard Database Rolling Upgrade

✔ Oracle Data Guard Broker Support for Database Rolling Upgrades

✔ Oracle Scheduler Support for Data Guard Database Rolling Upgrade

✔ Rolling Upgrade Using Actve Data Guard

New Features Data Guard 12.2

✔ Create a Standby Database with DBCA

✔ Support for Diagnostic Pack with ADG

✔ Support for SQL Tuning Advisor

✔ Distributed Operatons on CLOB, BLOB and XMLType

✔ OCI Support for Distributed LOBs

✔ Minimizing Impact on Primary Database When Using Multple SYNC Standby Databases

✔ Oracle Data Guard Database Compare

✔ Subset Standby

✔ Oracle Data Guard Broker Support for Multple Automatc Failover Targets

✔ Oracle Data Guard Broker Support for Multple Observers

✔ Simplifying Observer Management for Multple Fast-Start Failover Confguratons

✔ Oracle Data Guard Broker Support for Transport Destnatons of Diferent Endianess Than the Primary

✔ Oracle Data Guard Broker Support for Oracle Data Guard Multple Instance Apply

✔ Oracle Data Guard Broker Support for Enhanced Alternate Destnaton

✔ Fast-Start Failover in Maximum Protecton Mode

✔ Block Comparison Tool Support in Oracle Data Guard Broker DGMGRL Interface

✔ Oracle Data Guard Broker Support for Executng DGMGRL Command Scripts

✔ Broker ConfguratonWideServiceName Confguraton Property

✔ Enhancing Support for Alternate Destnatons

✔ Automatcally Synchronize Password Files in Oracle Data Guard Confguratons

✔ Preserving Applicaton Connectons to An Actve Data Guard Standby During Role Changes

✔ NoLogging Changes for Data Guard

✔ Multiple Instance Redo Apply (MIRA) in RAC

✔ Automatic Password File Synchronization

✔ In-Memory Support for ADG

✔ Connection Preservation During Role Changes

✔ DUPLICATE Command Enhancements for DG

New Features Data Guard 18C

✔ In Memory Column store works with multi-instance redo apply

✔ Multi-instance redo apply support with Block Change Tracking (BCT)

✔ Global Temporary Table support from Standby.

✔ DML operations on Standby Redirection to Primary without ACID compromise.

✔ Preserve buffer cache during role-change.

✔ Nologging enhancement Performance mode and Availability mode.

✔ New RECOVER STANDBY DATABASE FROM SERVICE

✔ New Broker VALIDATE commands VALIDATE Network Configuration… Parameters… etc…

New Features Data Guard 19C

✔ Automatic Flashback Of Standby Database

✔ Restore Point Replication From Primary To Standby

✔ Active Data Guard-DML Redirection

✔ Tuning Automatic Outage Resolution With Data Guard

✔ Automatically Deleting Flashback Logs

…