Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Contact Sales

Oracle DBA II Mastery: Advanced Administration & Recovery

This advanced course guides you through Oracle Database Administration II (1Z0-083) topics.

You will master multitenant architecture, backup/recovery strategies, patching/upgrading, performance tuning, RMAN, and diagnostics. You will work in hands-on labs with real Oracle environments. After the course you will be able to manage CDBs/PDBs, perform recovery, apply patches, troubleshoot RMAN, and optimize performance.

GK# 848001 Vendor# TTOR20530
Vendor Credits:
No matching courses available.
Start learning as soon as today! Click Add To Cart to continue shopping or Buy Now to check out immediately.
Access Period:
Scheduling a custom training event for your team is fast and easy! Click here to get started.

Who Should Attend?

  • Senior DBAs
  • Architects managing multitenant deployments

What You'll Learn

In this course you will learn to:

  • Configure, manage, clone, and plug/unplug CDBs and PDBs
  • Control resource usage and connectivity in a multitenant environment
  • Plan and execute backups, restores, and flashback strategies using RMAN
  • Duplicate databases, transport data, and patch the Oracle infrastructure
  • Perform upgrades and manage Grid Infrastructure / Oracle Restart
  • Diagnose failures, tune RMAN, use AWR/ADDM, and optimize SQL performance

Course Outline

Module 1: Multitenant Architecture & CDB / PDB Management

  • Concepts: CDBs, PDBs, application containers, root, seed
  • Creating CDBs and PDBs (from seed, cloning)
  • Plugging/unplugging PDBs, relocating, cloning
  • PDB service names, initialization parameters
  • Resource Manager for CDBs / PDBs, resource plans

Lab

  • Create a CDB, seed PDB, new PDB from seed
  • Clone a PDB, unplug and plug it to another container
  • Configure PDB service names
  • Use Resource Manager to limit CPU or memory to PDBs

Module 2: Security & Policy in Multitenant Environments

  • Managing security in CDB and PDB layers
  • PDB lockdown profiles
  • Audit configuration across containers
  • Policies in application containers

Lab

  • Apply a lockdown profile to a PDB
  • Set up audits (login, DDL) at container scope
  • Create and apply container policies

Module 3: Backup, Recovery & Flashback

  • RMAN fundamentals (full, incremental, cumulative)
  • Backup strategies: compression, encryption, multiplexing
  • Flashback features: DB flashback, PDB flashback
  • Recovery scenarios: complete, point-in-time, media failure

Lab

  • Configure RMAN backups, test restores
  • Use flashback to undo data corruption
  • Recover a PDB and a CDB after failure

Module 4: Database Duplication & Data Transport

  • Duplicate databases and PDBs (RMAN duplicate)
  • Transportable tablespaces and transportable PDBs
  • Data movement across platforms

Lab

  • Duplicate a live PDB or CDB using RMAN
  • Transport a tablespace or PDB to a different container or host

Module 5: Upgrades, Patching & Grid Infrastructure

  • Oracle software installation and patching strategies
  • Upgrading CDB/PDBs (manual and automatic)
  • Oracle Grid Infrastructure, Oracle Restart
  • Rolling upgrades in multitenant

Lab

  • Patch Oracle software and apply DB PSU
  • Upgrade a database version within multitenant
  • Configure Oracle Restart and verify auto start

Module 6: Performance Monitoring & RMAN Tuning

  • AWR, ADDM, advisory framework
  • Wait events, metrics, threshold alerts
  • SQL tuning: optimizer, statistics, SQL Tuning Advisor
  • RMAN message interpretation and tuning

Lab

  • Run AWR reports, analyze top wait events
  • Use SQL Tuning Advisor on a sample SQL
  • Capture RMAN logs, diagnose performance bottlenecks

Module 7: Diagnostics, Failure Analysis & Wrap-Up

  • Common failure scenarios and diagnostic methods
  • Data block corruption detection and repair
  • Using DBVERIFY, RMAN validate, block recovery
  • Exam review, integrated workflows

Lab

  • Intentionally corrupt a block and repair
  • Use RMAN VALIDATE, recovery catalog validation
  • Complete an end-to-end exercise: setup CDB/PDB, backup, failure, recovery, tuning

Prerequisites

  • TTOR20510 - Oracle Database Foundations
  • TTOR20520 - Oracle Database Administration Fundamentals