Master Oracle 19c: Advanced DBA Techniques

Elevate your Oracle 19c database skills to expertly manage, tune, and secure robust database environments, perfect for seasoned DBAs.

Course Thumbnail

Essential Skills Gained

Checkmark

Master creation and management of CDBs (Container Databases) and PDBs (Pluggable Databases).

Checkmark

Implement effective backup, recovery, and database duplication strategies.

Checkmark

Optimize database performance with advanced tuning and monitoring techniques.

Checkmark

Enhance database security and manage RMAN (Recovery Manager) configurations.

Format

  • Instructor-led
  • 5 days with lectures and hands-on labs.

Audience

  • Seasoned Oracle DBAs
  • Database Performance Analysts
  • System Administrators
  • SQL Developers

Description

This course builds on foundational Oracle 19c DBA skills, guiding participants through advanced database administration concepts. You'll work hands-on with contemporary Oracle database features, tuning performance for efficiency, mastering Multitenant architecture, and securing your data. Whether upgrading existing skills or learning new, in-demand techniques, this course provides the critical insights needed to maintain powerful, dependable database systems.

Calendar icon

Upcoming Course Dates

September 22-26, 2025

10:00 AM - 6:00 PM

Virtual: Online - US/Eastern

Enroll

$2095

Course Outline

Download PDF

Mastering CDBs and PDBs

  1. Setup and configure a Container Database (CDB)

  2. Initiate Pluggable Databases (PDBs) from seeds

  3. Examine PDB structure

Administering CDBs and PDBs

  1. Oversee PDB service and connectivity

  2. Control CDB/PDB startup, shutdown, and access

  3. Adjust PDB settings and modes

  4. Assess changes to parameter values

  5. Manage CDB/PDB resource usage with Oracle Resource Manager

Advanced Backup and Duplication

  1. Execute backup and recovery for CDBs and PDBs

  2. Perform PDB duplication

  3. Clone databases

CDB/PDB Upgrades and Data Transport

  1. Manage Oracle database upgrades

  2. Implement data transport solutions

Comprehensive Backup Strategies

  1. Conduct full and incremental backups

  2. Utilize RMAN for compressing and encrypting data

  3. Create multi-section and duplexed backup sets

  4. Archive backups and manage ASM (Automatic Storage Management) metadata

Advanced Recovery Concepts

  1. Apply best recovery practices for various data loss scenarios

  2. Utilize crash, complete, and point-in-time recovery technologies

Flashback Technologies Utilization

  1. Configure database for Flashback operations

  2. Conduct flashback operations

Duplication of Databases

  1. Clone databases efficiently

Grid Infrastructure and Database Installation

  1. Set up grid infrastructure for standalone servers

  2. Install Oracle Database software

Patching and Upgrading Grid Infrastructure

  1. Apply patches to grid infrastructure

  2. Upgrade grid infrastructure effectively

Implementing Database Enhancements

  1. Install and manage databases with DBCA (Database Configuration Assistant)

  2. Explore new features in Oracle 19c

Database Performance Monitoring and Tuning

  1. Manage database memory components

  2. Leverage the Automatic Workload Repository (AWR)

  3. Employ the Advisory Framework for performance insights

  4. Track performance metrics and alerts

Application PDB Management

  1. Define and manage application PDBs

  2. Handle PDB cloning and migration

  3. Utilize local and shared undo modes

Multitenant Database Security Management

  1. Configure security policies and lockdown profiles

  2. Conduct user audits

In-depth Recovery and Flashback Techniques

  1. Utilize RMAN for database restoration and recovery

  2. Perform flashback operations on CDBs and PDBs

Configuring RMAN for Recovery

  1. Set up RMAN and recovery catalogs

Addressing Failures

  1. Identify and rectify database corruption issues

Advanced Recovery Performance

  1. Manage recovery with and without RMAN

Data Transportation Strategies

  1. Deploy data transportation techniques

RMAN Optimization and Issue Resolution

  1. Analyze RMAN outputs for performance adjustments

SQL Tuning Improvement

  1. Use Oracle Optimizer and SQL Tuning Advisor

  2. Manage optimizer statistics

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.