Implement Oracle Data Guard Synchronous Redo Transport with Confidence [THR3336].pdf

1、Implement Oracle Data Guard Synchronous Redo Transport with Confidence Ludovico CaldaraSenior Principal Product Manager,OracleSeptember 11th,2024Oracle CloudWorld Copyright 2024,Oracle and/or its affiliates12Oracle CloudWorld Copyright 2024,Oracle and/or its affiliatesThe Importance of a Zero Data L

2、oss StrategyCustomer riskCustomers who have a bad experience may not returnRegulatory riskRegulated businesses may face penalties for data lossMay also be subject to additional ongoing scrutinyFinancial riskRevenue lossReputational/brand damage can reduce market valueZero data loss requires synchron

3、ous replication Oracle Data Guard SYNC redo transportSYNC redo transport provides for Zero Data Loss.What is your workload profile?Depending on the workload,enabling SYNC replication might impact performance.Follow the Oracle MAAs recommendationsand implement Synchronous Redo Transport with confiden

4、ce.What level of workload do you have?It might be as easy as enabling SYNC.As always,it depends.High profile,very high workload SYNC deployments require special attention.Some planning is required to ensure network and system infrastructure supports high volume with minimum performance impact.Tens o

5、f thousands of customers implement SYNC without any Oracle assistance.Typically,they run smaller workloads:Single instance databases or 2-nodes RACRedo generation below 200 MB/secLatency below 5 msExtreme workloadsSome Oracle Data Guard customers run sustained workloads of1 GB/secwith synchronous tr

6、ansport(4 TB/hour).Oracle CloudWorld Copyright 2024,Oracle and/or its affiliates56Depending on the type of workload,you should pay attention to different metrics.Performance profile impactOracle CloudWorld Copyright 2024,Oracle and/or its affiliatesTransaction throughputLatencyElapsed TimeNetwork&I/