Oracle administration: recovery, performance, and production

Objectives and progression

Initial course with nine lessons and 70 original decisions, including ten fictional APS/L3 and technical-management cases. Internal assessment of 37 decisions in 90 minutes. The 60 regular questions follow the five 1Z0-183 domain weights. Technical reference is 26ai without assuming availability in 19c. Initial depth; labs and complete mocks remain to be developed. Focus on 1Z0-183: 65 questions, 120 minutes, a 60% passing score, and five domains weighted 20/20/25/15/20, according to the official page inspected 2026-09-30. No explicit revision date is published. 1Z0-182, 1Z0-082, and 1Z0-083 are separately listed; retirement or prerequisites are not inferred.

Audience: DBAs, APS/L3 teams, and technical managers responsible for production databases.

Prerequisites: SQL, Linux, networking, and database-operation fundamentals. These are learning prerequisites; consult Oracle for official certification requirements.

540 estimated study minutes

• Confirm administrative scope and protect services sharing a CDB.
• Plan clones, transport, and restrictions with acceptance criteria.
• Distinguish backup execution, validation, and service return.
• Choose recovery scope and protect valid later work.
• Connect business duration with sessions, plans, and resources.
• Choose measurable interventions and assess the complete workload.
• Plan installation, validation, and return with explicit boundaries.
• Assess relevance, resources, and authorization in approximate search.
• Recognize consistency, concurrency, and integrity limits of new features.

Modules

1. Containers, services, and resources
2. PDB lifecycle and isolation
3. Backup and recovery evidence
4. Selective recovery and isolated rehearsals
5. Performance diagnosis and evidence
6. Tuning and change acceptance
7. Patches, upgrades, and handover
8. Vector search and model migration
9. True Cache, reservations, and audit evidence

Continue learning

Databases

• Oracle Database SQL
• SQL
• Production Support L3
• Middleware

References and version

1Z0-183 public objectives inspected 2026-09-30; revision date not published

• 1Z0-183 Professional · 2026-09-30
• 1Z0-182 Associate · 2026-09-30
• 1Z0-082 Administration I · 2026-09-30
• 1Z0-083 Administration II · 2026-09-30
• Current Oracle certification catalogue · 2026-09-30
• PDB scope and open state · 2026-09-30
• CDB scope · 2026-09-30
• Parameter modifiability · 2026-09-30
• Common and local privileges · 2026-09-30
• Resource Manager · 2026-09-30
• Application container synchronization · 2026-09-30
• Hot PDB cloning · 2026-09-30
• Plugging a PDB · 2026-09-30
• Lockdown profiles · 2026-09-30
• RMAN restore and recovery · 2026-09-30
• RMAN configuration and control file autobackup · 2026-09-30
• RMAN retention and recovery area · 2026-09-30
• Backup validation · 2026-09-30
• Complete recovery and restore validation · 2026-09-30
• Point in time recovery · 2026-09-30
• Flashback and restore points · 2026-09-30
• RMAN encryption modes · 2026-09-30
• Backup bottlenecks · 2026-09-30
• Database duplication · 2026-09-30
• Time model and wait events · 2026-09-30
• Application activity and average active sessions · 2026-09-30
• Feature licensing by offering · 2026-09-30
• Real time SQL monitoring · 2026-09-30
• Scalable bind based execution · 2026-09-30
• Execution plans and runtime statistics · 2026-09-30
• Undo retention trade-offs · 2026-09-30
• Baselines and profiles · 2026-09-30
• Column store and row store · 2026-09-30
• Real Application Testing · 2026-09-30
• Patch maintenance guidelines · 2026-09-30
• AutoUpgrade patching and logs · 2026-09-30
• Single instance restart · 2026-09-30
• CDB creation · 2026-09-30
• Post patch SQL actions · 2026-09-30
• Compatibility and downgrade boundaries · 2026-09-30
• Vector indexes and target accuracy · 2026-09-30
• Embedding model consistency · 2026-09-30
• True Cache consistency and freshness · 2026-09-30
• True Cache apply lag and DATA_TIME · 2026-09-30
• Lock free reservations and transaction semantics · 2026-09-30
• Blockchain table retention and hash chains · 2026-09-30
• Unified audit archival and purge · 2026-09-30
• TDE key availability when moving and cloning PDBs · 2026-09-30