Oracle 19c Data Guard Admin
A focused, self-paced deep-dive on configuring and operating Oracle Data Guard. Build a physical standby from scratch, master redo transport and real-time apply, and practise switchover and failover — all streamed in your portal, on demand.
- Data Guard end to end — standby build to failover
- Hands-on labs across a real 19c estate — Protection Modes, Physical Standby Creation, Redo Transport & Real-Time Apply, Switchover & Failover, the Data Guard Broker (DGMGRL) & Monitoring & Troubleshooting
- Notes, assignments & interview Q&A included
What this course covers
Oracle Data Guard is how organisations protect their databases against failure, data loss and disaster — a standby database kept continuously in sync with production, ready to take over in seconds. It's one of the most asked-about topics in DBA interviews and one of the most valuable skills to own at work, because a Data Guard setup is what stands between a business and an extended outage when the primary site goes down.
This is a focused deep-dive on Oracle 19c Data Guard, recorded so you can learn it at your own pace. You'll follow our senior Oracle DBA instructors as they explain protection modes, build a physical standby from scratch, configure redo transport and real-time apply, run a controlled switchover and a failover, manage everything with the Data Guard Broker (DGMGRL), and troubleshoot the gaps and errors you'll meet in production. Every lesson streams in HD in your secure portal — rewatch any topic as often as you need, for life.
What you'll learn
- Explain Data Guard architecture and the role of a standby
- Choose between maximum protection, availability & performance modes
- Build a physical standby database from a primary
- Configure redo transport and real-time apply
- Manage standby redo logs and resolve redo gaps
- Perform a controlled switchover with zero data loss
- Perform a failover and reinstate the old primary
- Configure and operate the Data Guard Broker (DGMGRL)
- Monitor a Data Guard configuration and apply lag
- Troubleshoot common transport, apply and broker errors
Course contents
1Data Guard concepts & protection modesModule 1
- What Data Guard is and where it fits in HA / DR
- Primary, physical and logical standby databases
- Maximum protection, availability & performance modes
- Synchronous vs asynchronous redo transport
- Force logging and the role of standby redo logs
- Planning a Data Guard configuration
2Physical standby creationModule 2
- Preparing the primary database
- Init parameters for primary and standby
- Creating the standby with RMAN duplicate from active
- Configuring listeners and tnsnames for Data Guard
- Standby control file and password file setup
- Verifying the standby is in sync
3Redo transport & real-time applyModule 3
- How redo transport services work
- Configuring LOG_ARCHIVE_DEST for the standby
- Standby redo logs and real-time apply
- Managed Recovery Process (MRP) management
- Detecting and resolving redo gaps
- Monitoring transport and apply lag
4Switchover & failoverModule 4
- Switchover vs failover — when to use each
- Pre-switchover checks and readiness
- Performing a controlled switchover with no data loss
- Performing a failover after a primary loss
- Reinstating the old primary with Flashback
- Validating roles after a role transition
5Data Guard Broker (DGMGRL)Module 5
- What the Broker is and why to use it
- Enabling the Broker and creating a configuration
- Adding the standby to the Broker
- Switchover and failover with DGMGRL
- Fast-Start Failover (FSFO) and the observer
- Broker properties and configuration health
6Monitoring & troubleshootingModule 6
- Key views: V$DATAGUARD_STATS, V$ARCHIVE_GAP
- Reading the alert log and broker logs
- Diagnosing transport and apply failures
- Resolving archive log gaps manually
- Common broker and FSFO issues
- Best practices for a healthy Data Guard estate
What you get
- Lifetime accessStream every lesson in your student portal, for life
- Any deviceWatch on mobile, desktop & tablet
- Notes & scriptsCompanion material to follow along and reuse
- Hands-on assignmentsPractice tasks to cement every topic
- WhatsApp mentorshipAsk questions and get help as you learn
Who it's for
This course is for Oracle DBAs who want to own high availability and disaster recovery with confidence — whether you're preparing for an interview where Data Guard always comes up, or you're about to take responsibility for a standby at work. You'll get the most from it if you're already comfortable with core 19c administration and RMAN. No prior Data Guard experience is needed; the course builds a standby from first principles and takes you all the way through switchover, failover and the Broker.
What learners say
I'd configured Data Guard once before by copying commands without really understanding it. This course made the concepts finally land — protection modes, redo transport, real-time apply. Building the standby alongside the videos was exactly the practice I needed.
CMThe switchover and failover lessons are worth the price on their own. I practised a failover and reinstated the primary with Flashback in my own lab, then did the real thing at work without breaking a sweat. Lifetime access means I revise before every audit.
EPClear, focused and to the point. The DGMGRL and Fast-Start Failover section cleared up things I'd been confused about for years. At ₹2,000 with companion scripts and WhatsApp support, it's superb value.
GAPurchase & access
How do I get access after I pay?
Is it lifetime access?
Can I watch on mobile?
Can I download the videos?
What payment methods do you accept?
Do I get a certificate?
What is the refund policy?
About the course
Is it live or recorded?
Do I need prior experience?
Is support included?
Own Oracle high availability with Data Guard
Get lifetime streaming access to the full Oracle 19c Data Guard course for ₹2,000 — build a standby, practise switchover and failover, and revisit any lesson whenever you need it.