首页 » ORACLE » Oracle Dataguard New Features 历程 10g-19c

Oracle Dataguard New Features 历程 10g-19c

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

打赏

对不起,这篇文章暂时关闭评论。