Overview
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
- Senior DBAs
- Architects managing multitenant deployments
Pre-Reqs
- Strong Oracle DBA I experience
- Familiarity with SQL and OS administration
Agenda
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