Course Overview

The Oracle Advanced DBA Training aims to provide participants with in-depth knowledge and hands-on skills essential for managing and administering Oracle DBA, RAC, Dataguard and (Advanced DBA) environments efficiently.

By the end of the course, participants will be able to:

Oracle Database Architecture: Understand the core architecture, including memory structures, background processes, logical and physical storage, and multitenant environments.
Database Creation & Management: Learn to create and manage standard databases, CDBs, and PDBs, including cloning, unplugging, and plugging PDBs.
Database Connectivity & Security: Gain expertise in database connectivity, user account management, granting roles and privileges, and configuring authentication mechanisms.
Tablespace & Storage Management: Master creating, altering, and encrypting tablespaces, managing storage space, and reclaiming unused space.
Oracle Net Services & Network Configuration: Configure and manage Oracle Net Services, listeners, database links, and troubleshoot connectivity using tools like tnsping.
Backup & Recovery Using RMAN: Learn RMAN backup concepts, incremental backups, retention policies, and perform complete/incomplete database recovery scenarios.
High Availability with Data Guard: Configure and manage Data Guard for high availability, perform switchover/failover using DGMGRL, and maintain snapshot standby databases.
Oracle RAC & Clusterware Administration: Deploy and manage Oracle RAC clusters, administer ASM instances, manage backup and recovery for RAC, and configure load balancing.
Exadata Database Machine: Understand Exadata architecture, hardware configurations, smart scan, smart flash cache, and migrate databases to Exadata.
Patching, Upgrading & Database Cloning: Perform database patching, upgrade from Oracle 12.2 to 19c, manage rolling upgrades, and duplicate databases using RMAN.

✅ Real-time case studies | ✅ Practical hands-on labs | ✅ Certification Guidance

Who should go for this training?
The following professionals can go for this course:

Oracle DBA's having minimum 2+ years work experience.

What are the pre-requisites for this Course?

Oracle DBA

Course Content

Expand All

Module 1 - Database Administration

1) Oracle Database Architecture

List the major architectural components of Oracle Database
Explain memory structures
Describe background processes
Correlate logical and physical storage structures
Describe multitenant architecture

2) Creating Standard Database, CDB's and PDBs

Describe the methods and tools used to create PDBs
Create PDBs from seed by using SQL*Plus
Clone PDBs by using SQL*Plus
Unplug and plug in PDBs and Drop PDBs by using SQL*Plus

3) Accessing an Oracle Database

Connect to an Oracle Database
Describe the tools used to access an Oracle Database
Describe the Oracle-supplied user accounts for Oracle Database
Query the data dictionary in an Oracle Database

4) Managing Database Instances

Describe initialization parameter files and parameters
View and modify initialization parameters in SQL*Plus
Start up and shut down Oracle databases
Open and close PDBs
Work with the Automatic Diagnostic Repository (ADR)
Query dynamic performance views

5) Oracle Net Services

Describe Oracle Net Services
Explain how listeners work
Configure listeners for dynamic or static service registration
Configure local naming for database connections
Test Oracle Net connectivity with tnsping
Configure communication between databases by creating database links

6) Administering User Security

Create database users, Grant privileges to users
Create and grant roles to users or other roles
Revoke privileges and roles from users and other roles
Create and assign profiles to users
Explain the various authentication options for users
Assign quota to users

7) Creating and Managing Tablespaces

Explain how table data is stored in the database
Create and drop tablespaces
Alter tablespaces, view tablespace information
Implement Oracle Managed Files (OMF)
Use SQL*Plus to move and rename online data files
Implement tablespace encryption

8) Managing Storage Space

Describe how the Oracle Database server automatically manages space
Save space by using compression
Proactively monitor and manage tablespace space usage
Describe segment creation in the Oracle database
Control deferred segment creation
Reclaim wasted space from tables and indexes by using the segment shrink functionality
Manage resumable space allocation

9) Managing Undo Data

Explain DML and undo data generation
Monitor and administer undo data
Describe the difference between undo data and redo data
Configure undo retention
Guarantee undo retention
Enable temporary undo
Use the Undo Advisor

10) Moving Data

Describe ways to move data
Explain the general architecture of Oracle Data Pump
Use Data Pump to move data between Oracle databases
Use SQL*Loader to load data from a non-Oracle database (or user files)
Use external tables to move data via platform-independent files

11) Backup and Recovery Concepts

Identify DBA responsibilities regarding database backup and recovery
Identify the types of failure that can occur in an Oracle database
Describe instance recovery
Describe complete and incomplete recovery

12) Backup and Recovery Configuration

Configuring the Fast Recovery Area
Multiplex the control file & redo log files
Configure ARCHIVELOG mode
Configuring the Backup Retention Policy
Backup Optimization and the CONFIGURE command
Configuring an Archived Redo Log Deletion Policy

13) RMAN Backup Concepts

About Consistent and Inconsistent RMAN Backups
About Online Backups and Backup Mode
About Backup Sets & Image Copies
About Multiple Copies of RMAN Backups
About RMAN Control File and Server Parameter File Auto backups
About RMAN Incremental Backups & Retention Policies

14) Backing Up the Database

Overview of RMAN Backups
Specifying Backup Output Options
Backing Up Database Files with RMAN
Backing Up CDBs and PDBs
Backing Up Archived Redo Logs with RMAN
Making and Updating RMAN Incremental Backups

15) Managing a Recovery Catalog

Overview of the RMAN Recovery Catalog
Creating a Recovery Catalog
Registering a Database in the Recovery Catalog
Managing Stored Scripts
Maintaining & dropping the Recovery Catalog

16) Performing Database Recovery

Determine the need for performing recovery
Describe and use available options, such as Recovery Manager (RMAN) and the Data Recovery Advisor and Recovery datafiles

17) Performing Complete Database Recovery

Overview of Complete Database Recovery
Performing Complete Database Recovery
Performing Complete Recovery of CDBs
Performing Recovery of Non-Critical datafiles
Performing Recovery of Critical datafiles

18) Performing In-Complete Recovery Scenarios

Incomplete Recovery scenarios Loss of Redologs
Incomplete Recovery scenarios Loss of Control files
Incomplete Recovery scenarios Loss of All Files

19) RMAN Incremental Backups and Point-in-Time Recovery

Overview of RMAN Incremental Backups
Performing Incremental Backups & recovery scenario
Performing point-in-time Recovery (PITR) scenarios

20) Understand Database Patching & Upgrade

Understand Database Patching & Upgrade

21) Duplicating a Database / Database Cloning

List the purposes and create duplicate database with RMAN
Duplicate a database based on a running instance

Module 2- High Availability With DataGuard

22) Understand Hiigh Availability and the requirement of Data Guard

Manually configure and manage Dataguard Setup
Understanding Dataguard Roles & types of Modes

23) Using DGMGRL

Configuration DGMGRL
Using DGMGRL for monitoring and configuring Dataguard setup
Performing switchover and failover tasks using DGMGRL

24) Configuring Standby Modes

Configure Snapshot standby database
perfrom switchover and switchback from snapshot to physical standby
Monitor snapshot standby databases

Module 3- Clusterware And RAC Administration

25) Introduction to Clusterware

Explain the principles and purposes of clusters
Describe cluster hardware best practices
Describe the Oracle Clusterware architecture

26) Oracle Clusterware Architecture

High Availability with RAC design
RAC Architecture and purpose of VIP’s
SCAN NAME, SCAN VIPs, SCAN Listeners architecture
Standard cluster and Flex Cluster concepts
Components of Clusterware
Understanding Processes architecture

27) Grid Infrastructure: Preinstallation Tasks

perform preinstallation tasks for Grid Infrastructure.

28) Grid Infrastructure Installation

Perform an image-based Grid Infrastructure installation
Verify the installation
Configure Automatic Storage Management (ASM) disk groups

29) Traditional Clusterware Management

Demonstrate your Clusterware management proficiency
Demonstrate Oracle Cluster Registry (OCR) backup and recovery techniques
Manage network settings
Describe the scope and capabilities of what-if command evaluation

30) Flex ASM

Describe the architecture and components of Flex ASM
Install and configure Flex ASM
Administer Flex ASM

31) Administering ASM Instances

Explain and apply Automatic Storage Management (ASM) initialization parameters
Manage ASM instances and associated processes
Monitor ASM

32) Installing and Configuring Oracle RAC

Install the Oracle database software
Create a cluster database
Convert a single-instance Oracle database to RAC

33) Oracle RAC Administration

Use Enterprise Manager Cluster Database pages
Define redo log files in a RAC environment
Define undo tablespaces in a RAC environment
Explain the benefits of Local Temporary Tablespaces
Start and stop RAC databases and instances
Modify initialization parameters in a RAC environment

34) Managing Backup and Recovery for RAC

The RAC database to use ARCHIVELOG mode and the fast recovery area
RMAN for the RAC environment

35) Global Resource Management Concepts

Describe the need for global concurrency control
Describe Global Resource Directory
Explain how global resources are managed
Describe about RAC global resource access coordination

36) Managing High Availability of Services

Configure and manage services in a RAC environment
Use services with client applications
Use services with the Database Resource Manager
Use services with the Scheduler
Configure services aggregation and tracing

37) High Availability for Connections and Applications

Configure client-side connect-time load balancing
Configure client-side connect-time failover
Configure server-side connect-time load balancing
Configure Transparent Application Failover (TAF)
Describe the purpose of Transaction Guard and Application Continuity
Describe the key concepts relating to Application Continuity

38) Oracle RAC One Node

Perform an online database relocation
Add an Oracle RAC One Node Database to an existing Cluster
Convert an Oracle RAC One Node database to a RAC database
Use DBCA to convert a single instance database to a RAC One Node database

39) Multitenant Architecture and RAC

Describe the multitenant architecture in a non-RAC environment
Describe the multitenant architecture in a RAC environment
Create a RAC multitenant container database (CDB)
Create a pluggable database (PDB) in a RAC CDB
Use default CDB and PDB services
Create PDB services to associate PDB services with server pools
Drop a pluggable database (PDB) from a RAC CDB

40) Upgrading and Patching Grid Infrastructure

Describe the types of patches and upgrades available
Plan for rolling patches and rolling upgrades
Compare software versions with the active version
Install a patch with the opatch utility
Upgrade clusterware from 12.2 to 19c including practice

41) Upgrading and Patching Oracle RAC

Describe the types of patches available
Install a patch set with the Oracle Universal Installer (OUI) utility
Install a patch with the opatch utility
Patching and Upgrading database from 12.2 to 19c including practice

Module 4- Understanding & Managing Exadata

42) Exadata Database Machine: Overview

Provide an overview-level description of Exadata Storage Server and the different Exadata Database Machine configurations
Exadata X8M Hardware
Exadata Database Machine X8M-2
Exadata Database Machine X8M-8
RDMA Over Converged Ethernet (RoCE): Overview
Outline the key capacity and performance specifications for Exadata Database Machine

43) Exadata Database Machine Architecture

The Exadata network architecture
RDMA over Converged Ethernet (RoCE)
How multiple Exadata racks can be interconnected
The Exadata software architecture
The Exadata Storage Server storage entities and their relationships
Disk Group Configuration

44) Key Capabilities of Exadata Database Machine

Exadata Smart Scan Model
Exadata Storage Index: Overview
Hybrid Columnar Compression: Overview
Exadata Smart Flash Cache: Overview
Persistent Memory (PMEM)
In-Memory Columnar Caching on Storage Servers
Exafusion Direct-to-Wire Protocol
Exadata X8M RoCE: High Priority Networking
I/O Resource Management: Overview

45) Exadata Storage Server Configuration

Configure Exadata Storage Server software
Create and configure ASM disk groups using Exadata storage

46) Using Smart Scan

Describe Smart Scan and the query processing that can be offloaded to Exadata Storage Server
Describe the requirements for Smart Scan
Describe the circumstances that prevent using Smart Scan
Identify Smart Scan in SQL execution plans
Use database statistics and wait events to confirm how queries are processed

47) Migrating Databases to Exadata Database Machine

Describe the general steps to migrate your database to Exadata
Performing Capacity Planning
Exadata Migration Considerations
List the main approaches for migrating your database to Exadata
Identify the most appropriate approach for different circumstances

Brochure Download

Modes of Training

Classroom Training

Lives interactive sessions delivered in our classroom by our expert trainers with real-time scenarios.

Online Training

Learn from anywhere over internet, joining the live sessions delivered by our expert trainers.

Self-Pace Training

Learn through pre-recorded video sessions delivered by experts with your own pace and timings

For Coporate Training, We provide customized content and delivered by industry experts with complete practical demonstration, discussions and exercises based on practical use cases.

Our Key Highlights

Unique Benefits included in this training

BEST TRAINER : OCM Certified, 24 exp and delivered more than 700 batches
QUALITY CONTENT : Covers in-depth and industry-relevant advance topics.
LAB ACCESS : Practice hands-on with dedicated online servers, anytime, anywhere.
BEST PRICE : Best value training at a competitive price.
SESSION RECORDINGS : Access to session recordings for easy revision.
REAL-TIME SCENARIOS : Learn through practical scenarios and live projects.

Upcoming Batches

CLASSROOM TRAINING

This Course Includes:

Delivered by OCM Certified 24 yrs exp trainer
40 Live classroom sessions
Access for most of the Recorded videos
Reading material and Lab activity guide
One-to-one dedicated server
100 Hrs of Lab practices
100% practical-oriented classes
Real-time projects and certification guidance
Get certificate on course completion
Job assistance
Certified technical assistance

Not yet scheduled

Course Fee : ₹ 35,000/-

Discount : ₹ 10,000/- (29%)

Offer Price : ₹25,000/-

ONLINE TRAINING

This Course Includes:

Delivered by OCM Certified 24 yrs exp trainer
40 Virtual online sessions
Access for 60 Hrs of Recorded videos
Reading material and Lab activity guide
24x7 one-to-one dedicated online Server access
100 Hrs of Lab practices
100% practical-oriented classes
Real-time projects and certification guidance
Get certificate on course completion
Job assistance
Technical support thru chat and email

Not yet scheduled

Course Fee : ₹ 45,000/-

Discount : ₹ 10,000/- (22%)

Offer Price : ₹35,000/- $413

SELF-PACED LEARNING

This Course Includes:

Access for 60 Hrs of Recorded videos
Reading material and Lab activity guide
24x7 dedicate online AksWave server access
100 Hrs of Lab practices
Real-time projects and certification guidance
Technical support thru chat and email

₹32,000/-

ORACLE ADVANCE DBA

Learn 19c Oracle DBA, RAC, Dataguard, Exadata, Database Upgrade and Patching ✅ OCM trainer ✅ 24 yrs exp ✅ 44 Hrs Live sessions ✅80 Hrs Lab Practice ✅ 24/7 Online LAB Access

Course Overview

Course Content

Module 1 - Database Administration

Module 2- High Availability With DataGuard

Module 3- Clusterware And RAC Administration

Module 4- Understanding & Managing Exadata

Modes of Training

Classroom Training

Online Training

Self-Pace Training

For Coporate Training, We provide customized content and delivered by industry experts with complete practical demonstration, discussions and exercises based on practical use cases.

Our Key Highlights

Unique Benefits included in this training

Upcoming Batches

Our Instructor

Akal Singh

Oracle Certified Master

Demo Video

Certification Guidence

Faq

Combo Offers

Enroll Now

Oracle 12C DBA + RAC Administration

22,000/-

Enroll Now

RAC Administration + 12c Goldengate

21,000/-

Enroll Now

RAC Administration + Exadata X8M & X10M

40,000/-

Enroll Now

Oracle 12C DBA + Apps DBA 12.2

20,000/-

Related Courses

Performance Tuning

22,000/-

PostgreSQL DBA

22,000/-

RAC Administration

24,000/-

Dataguard 12c

18,000/-

Exadata X8M & X10M

24,000/-

19c RAC Hyderabad

0/-

Testimonials

Google Ratings

Facebook Ratings

Twitter Ratings

Oracle 12C DBA +
RAC Administration

RAC Administration +
12c Goldengate

RAC Administration +
Exadata X8M & X10M

Oracle 12C DBA +
Apps DBA 12.2