What is oracle Data Guard ?
- Data Guard Configurations
- Types of standby databases
- Data Guard Protection Modes
- Switchover and Failover
- Summary of Data Guard Benefits
So, just what is Data Guard?
"An application-transparent high-performance low-impact asymmetrical online reliable Redo or SQL level background standby database transaction exchange utility capable of reporting, switchover and Failover."
Data Guard helps you protect your Data.
Takes your data and automatically puts it elsewhere
Makes it available for Failover in case of failure.
The other capabilities are pure bonus.
Switchover for Maintenance
Protects from Data corruption
Types of standby databases
Physical standby database
Logical standby database
Snapshot Standby Database
Switchover and Failover
There are two ways to change roles in a standby configuration
Changing roles with someone else and letting them take over while you become a standby
Planned role reversal, never any data loss
Used for database upgrades, OS patching, data center moves, etc.
Assigning someone else to take over when the original boss is gone
Unplanned failure of primary
Summary of Data Guard Benefits
Disaster recovery and high availability
Complete data protection
Efficient use of system resources
Flexibility in data protection to balance availability against performance requirements
Automatic gap detection and resolution
Centralized and simple management
Automatic role transitions