Active Data Guard: Disaster recovery tips and tricks
summary
Oracle Active Data Guard claims zero data loss with maximum availability and can span long distances using Far Sync and FastSYNC; it supports automated failover via Fast-Start Failover/Observer and automated reinstate with Automatic Resynchronization. Key tools and features: automatic block repair (bidirectional), DBMS_ROLLING for rolling upgrades, Snapshot Standby for testing, MIRA for RAC redo apply, AWR-unified snapshots, and DML redirection for read-mostly updates (recommended ≤3–5% of ops).
AI-written summary · about
chapters (14)
- 0:00Introduction to data guard
- 2:10Data guard vs other solutions
- 4:31Data protection modes
- 7:00Automating with fast-start
- 8:59Automatic block repair
- 10:13Maintenance and upgrades
- 14:09Switching to active data guard
- 15:29Tuning and diagnostics
- 18:04Flexible deployment scenarios
- 20:36In-memory and EM integration
- 22:28Multi-instance redo apply
- 24:43Offloading read/write workload
- 27:46Cloud capacity management
- 30:14Hands-on lab and conclusion
related talks
21mNever-down applications with Oracle Maximum Availability Architecture
24mHigh Availability and Disaster Recovery Smart Features
16mOracle MAA for Data Resiliency Across Hyperscalers
11mProtect and Recover with Autonomous Recovery
24mSimplify application development with Oracle Real Application Clusters
19mMission-critical databases made simple
31mOracle Maximum Availability Architecture (MAA) best practices for OCI
24mAutomate Data Management with Autonomous Database