Oracle DBA II Mastery: Advanced Administration & Recovery

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