Oracle Data Guard 12c | 19c Certification Training
One of the top providers of online IT training worldwide is VISWA Online Trainings. To assist beginners and working professionals in achieving their career objectives and taking advantage of our best services, We provide a wide range of courses and online training.
Learners : 1080
Duration : 25 Days
About Course
Oracle Data Guard is primarily used for data protection, high availability, and disaster recovery in Oracle databases. It achieves this by creating and maintaining one or more standby databases that are transactionally consistent with the primary database. These standby databases can then be switched to the primary role in case of an outage, minimizing downtime and ensuring data integrity. Enroll today to earn your certification.
Oracle Data Guard Training Course Syllabus
✔ What Is Oracle Data Guard?
✔ Types of Standby Databases
✔ Types of Data Guard Services
✔ Role Transitions: Switchover and Failover
✔ Oracle Data Guard Broker Framework
✔ Choosing an Interface for Administering a Data Guard Configuration
✔ Oracle Data Guard: Architecture(Overview)
✔ Primary Database Processes
✔ Networking Overview
✔ Listener.ora Configuration
✔ Statics vs. Dynamic Registration
✔ Static Entries for Database Duplication and SQL Maintenance
✔ Static Entries for Broker Operations
✔ Oracle Network Configuration Tuning
✔ tnsnames.ora Configuration
✔ Steps to Create a Physical Standby Database
✔ Preparing the Primary Database
✔ FORCE LOGGING Mode
✔ Configuring Standby Redo Logs
✔ Creating Standby Redo Logs
✔ Using SQL to Create Standby Redo Logs
✔ Viewing Standby Redo Log Information
✔ Setting Initialization Parameters on the Primary Database to Control Redo Transport
✔ Oracle Data Guard Broker: Features
✔ Data Guard Broker: Components
✔ Data Guard Broker: Configurations
✔ Data Guard Broker: Management Model
✔ Data Guard Broker: Architecture
✔ Data Guard Monitor: DMON Process
✔ Benefits of Using the Data Guard Broker
✔ Comparing Configuration Management With and Without the Data Guard Broker
✔ Data Guard Broker: Requirements
✔ Data Guard Broker and the SPFILE
✔ Data Guard Monitor: Configuration File
✔ Data Guard Broker: Log Files
✔ Creating a Broker Configuration
✔ Defining the Broker Configuration and the Primary Database Profile
✔ Adding a Standby Database to the Configuration
✔ Enabling the Configuration
✔ Benefits of Implementing a Logical Standby Database
✔ Logical Standby Database: SQL Apply Architecture
✔ SQL Apply Process: Architecture
✔ Preparing to Create a Logical Standby Database
✔ Unsupported Objects
✔ Unsupported Data Types
✔ Checking for Unsupported Tables
✔ Checking for Tables with Unsupported Data Types
✔ Snapshot Standby Databases: Overview
✔ Snapshot Standby Database: Architecture
✔ Converting a Physical Standby Database to a Snapshot Standby Database
✔ Activating a Snapshot Standby Database: Issues and Cautions
✔ Snapshot Standby Database: Target Restrictions
✔ Viewing Snapshot Standby Database Information
✔ Using DGMGRL to View Snapshot Standby Database Information
✔ Converting a Snapshot Standby Database to a Physical Standby Database
✔ Oracle Active Data Guard
✔ Using Real-Time Query
✔ Checking the Standby’s Open Mode
✔ Understanding Lag in an Active Data Guard Configuration
✔ Monitoring Apply Lag: V$DATAGUARD_STATS
✔ Monitoring Apply Lag: V$STANDBY_EVENT_HISTOGRAM
✔ Setting a Predetermined Service Level for Currency of Standby Queries
✔ Configuring Zero Lag Between the Primary and Standby Databases
✔ Data Protection Modes and Redo Transport Modes
✔ Maximum Protection Mode
✔ Maximum Availability Mode
✔ Maximum Performance Mode
✔ Comparing Data Protection Modes
✔ Setting the Data Protection Mode by Using DGMGRL
✔ Setting the Data Protection Mode
✔ Role Management Services
✔ Role Transitions: Switchover and Failover
✔ Switchover
✔ Preparing for a Switchover
✔ Performing a Switchover by Using DGMGRL
✔ Considerations When Performing a Switchover to a Logical Standby Database
✔ Situations That Prevent a Switchover
✔ Using Flashback Database in a Data Guard Configuration
✔ Overview of Flashback Database
✔ Configuring Flashback Database
✔ Using Flashback Database Instead of Apply Delay
✔ Using Flashback Database and Real-Time Apply
✔ Using Flashback Database After RESETLOGS
✔ Flashback Through Standby Database Role Transitions
✔ Fast-Start Failover: Overview
✔ When Does Fast-Start Failover Occur?
✔ Installing the Observer Software
✔ Fast-Start Failover Prerequisites
✔ Configuring Fast-Start Failover
✔ Setting the Lag-Time Limit
✔ Configuring the Primary Database to Shut Down Automatically
✔ Automatic Reinstatement After Fast-Start Failover
✔ Backup and Recovery Considerations in an Oracle Data Guard Configuration
✔ Using RMAN to Back Up and Restore Files in a Data Guard Configuration
✔ Offloading Backups to a Physical Standby
✔ Restrictions and Usage Notes
✔ Using the RMAN Recovery Catalog in Oracle DataGuard Configuration
✔ Creating the Recovery Catalog Registering a Database in the Recovery Catalog
✔ Setting Persistent Configuration Settings
✔ Monitoring a Data Guard Broker Configuration
✔ Viewing the Data Guard Configuration Status
✔ Viewing Log File Details
✔ Oracle DataGuard Metrics
✔ Managing Data Guard Metrics
✔ Viewing Metric Value History
Live Instructor Based Training With Software |
Lifetime access and 24×7 support |
Certification Oriented content |
Hands-On complete Real-time training |
Get a certificate on course completion |
Flexible Schedules |
Live Recorded Videos Access |
Study Material Provided |
Oracle Data Guard Training - Upcoming Batches
Coming Soon
AM IST
Coming Soon
AM IST
Coming Soon
PM IST
Coming Soon
PM IST
Don't find suitable time ?
CHOOSE YOUR OWN COMFORTABLE LEARNING EXPERIENCE
Live Virtual Training
-
Schedule your sessions at your comfortable timings.
-
Instructor-led training, Real-time projects
-
Certification Guidance.
Self-Paced Learning
-
Complete set of live-online training sessions recorded videos.
-
Learn technology at your own pace.
-
Get access for lifetime.
Corporate Training
-
Learn As A Full Day Schedule With Discussions, Exercises,
-
Practical Use Cases
-
Design Your Own Syllabus Based
Oracle Data Guard Training FAQ'S
The following are the different benefits of using the Oracle Data Guard feature in your environment.
- High Availability.
- Data Protection.
- The off-loading Backup operation to standby database.
- Automatic Gap detection and Resolution in standby database.
- Automatic Role Transition using Data Guard Broker.
The following are the different Services available in the Oracle Data Guard of the Oracle database.
- Redo Transport Services.
- Log Apply Services.
- Role -Transitions.
Below are the protection modes available in DG
- Maximum Protection
- Maximum Availability
- Maximum Performance => This is the default protection mode. It provides the highest level of data protection that is possible without affecting the performance of a primary database. This is accomplished by allowing transactions to commit as soon as all redo data generated by those transactions has been written to the online log.
SELECT PROTECTION_MODE FROM V$DATABASE;
Get ahead in your career by learning Oracle DataGuard through VISWA Online Trainings
- High Availability.
- Load balancing (Backup and Reporting).
- Data Protection.
- Disaster Recovery.
Reviews
Amit Vishwakarma2025-04-09Trustindex verifies that the original source of the review is Google. I had a great experience with the Viswa Online Training. The course content was well-structured and covered all the essential topics in a very practical and easy-to-understand manner. The trainer was knowledgeable, approachable, and explained complex concepts with clarity. The mentor was also supportive throughout the training, always ready to guide and clarify doubts whenever needed. Their friendly and encouraging nature created a comfortable learning environment, which made the training even more effective. Overall, I highly recommend this training center to anyone looking to upskill. m Bhaskar2025-01-23Trustindex verifies that the original source of the review is Google. Best training institute. Golla Siva Lokesh Yadav2025-01-16Trustindex verifies that the original source of the review is Google. I am grateful for the opportunity to participate training with Viswa Online Training's. The training was highly informative, well-structured, and effectively covered the key concepts. The instructor's expertise and interactive approach made the learning experience engaging and practical. Rafi Shaik2025-01-08Trustindex verifies that the original source of the review is Google. Excellent training to immerse in Snaplogic. Benefiting from Trainer Subbu knowledge is a privilege. Mannepalli Satwik2024-12-25Trustindex verifies that the original source of the review is Google. Nice training institute. Thanks chaitanya Bharathi Neelam2024-12-16Trustindex verifies that the original source of the review is Google. VISWA Online Trainings is best IT training provider for SharePoint SPFX Training and best faculties with lot of patience and practical experience. Best place to work excellent training by experienced faculties awesome tech support. Naidu naidu Naidu naidu2024-11-27Trustindex verifies that the original source of the review is Google. It was a great learning experience for Oracle Apps DBA, Trainer has handy experience in the subject also his teaching style was perfect to grasp the knowledge. Study materials, Software and sample practical problems provided was excellent. I'll recommend VISWA Online Trainings for Apps DBA, already I have recommended to my friends and collogues.... Thanks, Chaitanya, for a great learning experience. T.yeswanth Reddy2024-11-26Trustindex verifies that the original source of the review is Google. The introduction to SAP Ariba with Rohith and the experience were wonderful. The instructor was really helpful and skilled. The course material was thoroughly and credibly covered. Many thanks, Team. Kamireddy bhanu Prakash reddy3212024-11-23Trustindex verifies that the original source of the review is Google. Excellent way of delivering concepts and PowerShell Online Training.