Data Guard is an Oracle feature that primarily provides database redundancy. This is done by having a standby (physical copy) database, preferably in another location and on separate disk. This standby database is maintained by applying the changes from the primary database to it. Standby databases can be maintained with either Redo (Physical standby) or SQL (Logical standby). Here, we will be doing a Physical Standby.
Why Use Data Guard?
Each Oracle High Availability tool has its purpose. The reasons we have used Data Guard for the system that prompted this paper, are:
• Full database redundancy
• Fast recovery in the case of a failure
• Ability for clients to automatically reconnect after a failure
• Ability to offload the backup process to another server
• Provides very good Mean Time to Repair
• Not overly complex
Dear friends,
I have a detailed video presentation and the steps involved in the setup as below:
YouTube Links:
https://www.youtube.com/watch?v=UACsUEgvRU4
https://www.youtube.com/watch?v=DztBchYtwlQ
Document and Video Links:
https://drive.google.com/folderview?id=0BxVnIed8wZv1cDhUOE85NVh5OWM&usp=drive_web
configure-dataguard-broker