Oracle Data Guard online training course provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions.
Instructor-Led Live Online Training
Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Data Guard maintains these standby databases as transactionally consistent copies of the production database.
Oracle Data Guard Training Curriculum
Introduction to Data Guard
Causes of Data Loss, Oracle Data Guard Architecture, Types of Standby Databases (benefits of each type), Using the Data Guard Broker, Differentiating Between Standby Databases and Data Guard Broker Configuration, Data Protection Modes, Performing Role Transitions
Creating a Physical Standby (SQL & RMAN)
Preparing the Primary, Force Logging, Configuring Standby Redo Logs, Logfiles on the Standby, Standby Redo Logs, Using SQL to Create SRLs, Initialization Parameters on Primary, Role-Based Destinations, Redo Transport Mode, Oracle Net for Physical Standby, Creating a Listener Entry, Copying the Primary’s Password File, Standby Init.ora File, Directory Path on the Target, Starting the Physical Standby, Invoking RMAN, Real-Time Apply, Starting Redo Apply, Standby on the Same Server, Data Corruption, Lost Write Detection
Overview of Data Guard Broker
Data Guard Broker Components, Broker Configuration, Data Guard Broker Architecture, DMON Process, Benefits of Using Data Guard Broker, DGMRL Commands, Enterprise Manager
Creating a Data Guard Broker Configuration
Requirements, Configuration File, Log Files, Workflow, Changing Properties, Database Properties, Disable Broker Management
Creating a Physical Standby Using Enterprise Manager
Creating Physical Standby, Physical Standby via EM
Configuring Data Protection Modes
Data Protection Modes, Maximum Protection, Maximum Availability, Maximum Performance, Comparisons, How to Set the Mode, Using Grid Control to Set the Mode
Monitoring a Data Guard Configuration
Monitoring Using Enterprise Manager, Viewing Data Guard Status, Data Guard Performance, Viewing Data Guard Performance, Viewing Log Files, Data Guard Metrics, Viewing Diagnostic Information, Destination Settings
Optimizing a Data Guard Configuration
Monitoring Performance, Optimizing Redo Transport, Optimizing Redo Transmissions, MaxConnections Database Property, RedoCompression Property, Delaying the Application of Redo
Using Flashback Database in a Data Guard Configuration
Flashback Database, Configuring Flashback Database, Enable Flashback Database, Flash Recovery Area, Flashback and Role Transitions, Flashback Database After Failover, Flashback Database Scenario
Performing Role Transitions
Role Transitions, Role Management Services, Switchover, Switchover Using DGMGRL, Switchover Using Enterprise Manager, Problems, Failover, Failover Using DGMGRL, Re-enable Disabled Databases, Failover Using Enterprise Manager, Failover – Back on the Standby
Backup and Recovery Considerations
RMAN in Data Guard, Maximum Availability Architecture (MAA), Offload Backups to a Physical Standby, Usage, RMAN Recovery Catalog, Create the Recovery Catalog, Register the Primary Database, Persistent Configuration Settings, RMAN Parameters for Primary, RMAN Parameters for Standby, Daily Incremental, RMAN Script, Loss of Data File on Primary, Using a Backup, Using the Physical Standby, Recovering a File on the Standby, Block Media Recovery
Managing Client Connectivity
Client Connectivity Issues, Helping Make the Right Connection, Managing Services, Client Failover, Automating Client Failover, Client Failover Components, Automatic Failover to a New Primary, Data Guard Broker and FAN, OCI Clients, OLE DB Clients, JDBC Clients, AFTER STARTUP Trigger, Service Names and tnsnames.ora File
Patching & Upgrading Databases in a Data Guard Configuration
Data Guard Broker, Upgrading with a Physical Standby, Rolling Upgrade Workflow, Rolling Upgrade
The online course session was good with a lot of discussion on the subject in depth. Demo's were good and the trainer cleared my doubts clearly.The trainer having a very good command on the subject.
Real time/live scenario's were included in the training sessions. The trainer's has very good command on the subject. Thank you..
I like the training period from Tekslate. The course is very well designed that helps to keep track until we demonstrate subject mastery.
Using most innovative teaching techniques, Tekslate intended to help students to learn through online. A great part of the coursework is allowed to use and earn certification by the time they finish t ...