What You’ll Learn
Advanced Oracle DBA Course is designed for experienced database administrators who want to deepen their expertise in managing complex Oracle database environments. Such courses focus on advanced database architecture, performance tuning, high availability, disaster recovery and cloud.
In this course, you will learn Oracle Clusterware architecture and ASM, RAC and Data Guard/Standby Database Administration and Performance Tuning and OCI Foundation.
After completing this course, students will be able to carry out:
Installation of Clusterware and RAC database, Grid Infrastructure pre-installation
tasks, Patching and Upgrading existing Grid Home and Dataguard installation and administration and
General Troubleshooting Concept of Clusterware and RAC database, Standby Database configuration and Performance Tuning
Oracle Database Advance Course Details
Oracle Database Important Link
Oracle Standby Database Oracle Performance tuning and AWR interpretation Oracle RAC Database Patching
Oracle Clusterware/RAC
- Introduction of Clusterware and Terminology
- Advantage of RAC database
- RAC Database Configuration
- OCR,Voting Disk,VIP and Interconnect and GPNP Profile
- Oracle Clusterware and Database HOME Installation
- SCAN Concepts,GRD,GCS,GES, Cache Fusion
- Clusterware Startup sequence
- Load Balancing and Failover and TAF
- Node Eviction
- Basic RAC Command
- RAC Performance Tuning, RAC Wait Events
- Clusterware/Grid and RAC Database Patching
- Basic Troubleshooting and log files location
- TFA, OSWatcher, ORACHK With Lab Session
- Difference Between 12c & 19c Clusterware/RAC/ASM Features.
DataGuard
- Data Guard Overview
- Types of Standby Databases
- Types of Data Guard Services
- Data Guard Background Processes
- Data Protection Mode
- Preparing the primary database for standby setup and setting up physical Standby Database
- Starting Database in snapshot mode
- Oracle Standby Switch over and Switch Back activity
- Detail Active Data Guard
- Basic Command for Monitoring
- Troubleshooting common Data Guard issues.
Oracle ASM
- Basics of Oracle ASM and its benefits.
- ASM Disk and Disk Group and redundancy
- Adding, resizing, and dropping disks in ASM disk groups
- Basic Command for ASM
Database Upgrade and Migration and Others
- Handling corrupted block recovery and point-in-time recovery.
- Upgrading databases to Oracle 19c or 21c
- Cross-platform migration using Data Pump
- V4 Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup
- Implementing advanced security features like Transparent Data Encryption (TDE) And Data Masking
- Basic of OCI Cloud.
Database Performance Tuning
- Performance Tuning Overview
- Oracle Database Internal
- Oracle Memory Evaluation from 9i to 12c
- Oracle Database Wait Event
- ASH and ADDM Analysis
- Oracle Memory Tuning/Instance Tuning
Understanding SQL Tuning Tools
(Explain Plan ,Trace and TKPROF - AWR Interpretation and Analysis with Real Time Scenarios
- Oracle performance troubleshooting.
