Getting More Value from Oracle Data Guard
Learn how - with Data Guard - to get more Performance from your Oracle Database and also possibly save money on Licensing Costs!
Chapters
00:00 - Introduction
01:58 - What Can Data Guard Do?
03:32 - Data Guard Architecture Review
16:49 - Getting Value from Standby Systems - Offload Query Processing to the Standby
23:01 - Apply Process - Forcing the Read Only Standby to Catch Up
26:19 - Active Data Guard - Automatic Apply of REDO
30:50 - Writing (DML) to the Standby - Open Read Write to Create a Test, Development DB
37:47 - Read Mostly Standby - Transparently Redirect DML to Primary
43:58 - Summary
The primary usage case for Data Guard is a physical standby in mount mode, to enable zero data loss. Excellent stuff! But Data Guard can do a lot more than that. A snapshot standby can be your test or dev system, open read-write without compromising the data loss objective. A logical standby, optimized for big queries, is a perfect near-real-time data warehouse. And if you have the Active Data Guard license, then many more possibilities open up. Judicious use of the various Data Guard options can improve the performance seen by your users and perhaps reduce your license footprint by reducing the need to license additional machines or processors.
Presenters
John Watson, Oracle Certified Master DBA, SkillBuilders Director of All Things Oracle Database
Dave Anderson, SkillBuilders’ Founder, Oracle Database Technologist
Attend instructor-led online class with this instructor, Oracle Certified Master John Watson of SkillBuilders! https://skillbuilders.com/oracle-dba-...
Hire John for Oracle DBA Services...for more info visit: https://skillbuilders.com/database-ad...
About Skillbuilders:
SkillBuilders, 25 years of success stories for Oracle Database Administration, APEX Development, APEX Hosting on AWS and Training.
Subscribe to our YouTube Channel and see hundreds of SkillBuilders Free Tutorials or watch on web site: https://skillbuilders.com/free-oracle...