What is oracle Data Guard ?
We all hear about Database protection in huge databases like Oracle and others.
Lets understand and see how the Oracle Data Guard helps what it is and how it benefit us.
Its been used in big organisation which stores lot of information and data on their Databases.
What is oracle Data Guard ?
- Data Guard Configurations
- Types of standby databases
- Data Guard Protection Modes
- Switchover and Failover
- Summary of Data Guard BenefitsSo, 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
Reporting
Off-loading Queries
Backups
Protects from Data corruptionTypes of standby databases
Physical standby database
Logical standby database
Snapshot Standby DatabaseSwitchover and Failover
There are two ways to change roles in a standby configuration
Switchover
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.
Failover
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