TTOR20530: Oracle DBA Mastery: Advanced Administration & Recovery
About this Course
This advanced boot camp 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.
Objectives
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
Audience Profile
Senior DBAs
Architects managing multitenant deployments
At Course Completion
Outline
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
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
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
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
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
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
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
Strong Oracle DBA I experience
Familiarity with SQL and OS administration
TTOR20510 Oracle Database Foundations
TTOR20520 Oracle Database Administration Fundamentals