Oracle Database Administration II study guide
Oracle Database Administration II · Work through your exam, one topic at a time.
Oracle Database Administration II is the second-tier administration exam in Oracle's certification path for database professionals. It is aimed at DBAs who already manage a single instance comfortably and now need to operate backup and recovery, multitenant environments, and performance diagnostics at production scale. The Oracle Database Administration II study guide has 8 sections and about 3,058 words.
01RMAN Configuration and Backup Strategies
This domain tests how you configure RMAN persistently and choose a backup strategy that satisfies a stated recovery requirement. Expect questions on retention policies, incremental levels, archived log backups, and the difference between what RMAN reports as obsolete and what is physically deleted.
418 words, about 2 min02Restore and Recovery Operations
This domain examines whether you can choose the correct restore and recover sequence for lost datafiles, lost control files, and logical damage requiring point-in-time recovery. The exam distinguishes restoring files from applying redo.
368 words, about 2 min03Flashback Technologies and Data Recovery Advisor
This domain tests selecting the right flashback feature for a user error versus media failure, and using Data Recovery Advisor to diagnose and repair failures through RMAN. Know the prerequisites and limits of each feature.
413 words, about 2 min04CDB and PDB Management
This domain tests the multitenant container model: what is shared, what is local to a PDB, how users and privileges differ between root and PDB, and how PDBs are opened and navigated. A container database (CDB) has one root ( CDB ROOT ), one read-only seed ( PDB SEED ), and one or more pluggable databases (PDBs).
402 words, about 2 min05Provisioning, Cloning, and Resource Management
This domain covers creating and cloning PDBs and controlling their CPU and I/O consumption. Expect questions on the seed, file name conversion, hot cloning prerequisites, unplug/plug metadata, and CDB resource plan directives.
361 words, about 2 min06Data Movement and Transportable Tablespaces
This domain tests moving tablespaces and data between databases efficiently, including the self-contained check, Data Pump transport syntax, and cross-platform conversion. Make the set read-only, then verify it is self-contained with DBMS TTS.TRANSPORT SET CHECK and query TRANSPORT SET VIOLATIONS .
331 words, about 2 min07Performance Monitoring and SQL Tuning
This domain tests using AWR, ASH, and the advisors to find high-load SQL and improve its execution plan without guessing. Know which tool produces which output and which recommendation changes the plan.
375 words, about 2 min08Resource Manager, Scheduler, and Automated Maintenance Tasks
This domain tests allocating resources with Resource Manager, scheduling work with DBMS SCHEDULER, and controlling the automatic maintenance clients that run in maintenance windows. Changes are made in a pending area: CREATE PENDING AREA , create or modify plans, consumer groups, and plan directives, then VALIDATE PENDING AREA and SUBMIT PENDING AREA .
390 words, about 2 min