DataGuard Enhancements in Oracle Releases
Oracle has been great in terms of enhancing it's Dataguard feature.
Here is list what has been seen from the release of 12c
This will update you with what all changes / enhancements Oracle has come up in past few years from1 11g.
12.1.0.1
GDS - Global Data Services
Automatic Workload Management by deploying a Global Service spawning the replication set.
https://docs.oracle.com/database/121/NEWFT/chapter12101.htm#NEWFT275
Dataguard Enhancements
1. DG Broker now supports Cascaded Standbys configuration and management
2. Fast Sync - NOAFFIRM with SYNC redo transport supported i.e. Primary does not wait for the write to complete at the Stanby Site (Probably few milliseconds of RPO?)
3. Single Command Role Transitions
4. Real Time Apply Default Setting
5. Resumable Switchover Operations (in case you encounter an issue)
6. ADG supports DML on GTT (Great enhancement), so your standby is not readonly, you can do some changes but only to temporary tables
7. ADG Cascade - Cascade Redo in Cascaded configuration directly from Standby Redo log files
8. Far Sync Instance - To support low B.W far away network configurations DataGuard
(More - https://docs.oracle.com/database/121/NEWFT/chapter12101.htm#NEWFT291)
12.2.0.1
1. DB Compare - Compare blocks in primary and Standby (not so useful in Big databases I guess?)
2. Subset Standby - Only 2 out of 4 PDB's are in Standby configuration
3. DG Broker Multiple Observers (Good now we use them like quorum?)
4. Multi Instance Redo Apply (Wow 2 instances now can mount the recovery thread, but there is a cache which is resolved in 18c)
5. DG Broker support for Hetrogeneous Endiancess configuration (is it really great - Obviously, as cloud migration experts)
6. Automatic Synchronize Password files (really love it)
(More - https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-A6211BAC-0534-44B9-B988-A7CC2B97044F)
18c (181)
1. Multi Instance Redo apply supports Block Change Tracking (this is what I was really looking for)
2. Automatic Correction of Non-Logged Blocks at Standby.
Two modes
i. Standby Nologging for Load Performance
ii. Standby Nologging for Data Availability
(More - https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/new-features.html#GUID-1C4BE6BE-B58C-46EA-87D2-D222E772B58E)
Oracle has been great in terms of enhancing it's Dataguard feature.
Here is list what has been seen from the release of 12c
This will update you with what all changes / enhancements Oracle has come up in past few years from1 11g.
12.1.0.1
GDS - Global Data Services
Automatic Workload Management by deploying a Global Service spawning the replication set.
https://docs.oracle.com/database/121/NEWFT/chapter12101.htm#NEWFT275
Dataguard Enhancements
1. DG Broker now supports Cascaded Standbys configuration and management
2. Fast Sync - NOAFFIRM with SYNC redo transport supported i.e. Primary does not wait for the write to complete at the Stanby Site (Probably few milliseconds of RPO?)
3. Single Command Role Transitions
4. Real Time Apply Default Setting
5. Resumable Switchover Operations (in case you encounter an issue)
6. ADG supports DML on GTT (Great enhancement), so your standby is not readonly, you can do some changes but only to temporary tables
7. ADG Cascade - Cascade Redo in Cascaded configuration directly from Standby Redo log files
8. Far Sync Instance - To support low B.W far away network configurations DataGuard
(More - https://docs.oracle.com/database/121/NEWFT/chapter12101.htm#NEWFT291)
12.2.0.1
1. DB Compare - Compare blocks in primary and Standby (not so useful in Big databases I guess?)
2. Subset Standby - Only 2 out of 4 PDB's are in Standby configuration
3. DG Broker Multiple Observers (Good now we use them like quorum?)
4. Multi Instance Redo Apply (Wow 2 instances now can mount the recovery thread, but there is a cache which is resolved in 18c)
5. DG Broker support for Hetrogeneous Endiancess configuration (is it really great - Obviously, as cloud migration experts)
6. Automatic Synchronize Password files (really love it)
(More - https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-A6211BAC-0534-44B9-B988-A7CC2B97044F)
18c (181)
1. Multi Instance Redo apply supports Block Change Tracking (this is what I was really looking for)
2. Automatic Correction of Non-Logged Blocks at Standby.
Two modes
i. Standby Nologging for Load Performance
ii. Standby Nologging for Data Availability
(More - https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/new-features.html#GUID-1C4BE6BE-B58C-46EA-87D2-D222E772B58E)
No comments:
Write comments