Oracle Database Administration II study plan

Configure persistent RMAN settings (retention policy, backup destination, encryption, compression, channels) and explain the effect of each on backup size and recoverability

Compare full, incremental, cumulative incremental, and differential incremental backups and choose the right level for a given RPO

Build a backup strategy that combines image copies, backup sets, and archived redo log backups, and justify the choice in writing

Enable and interpret block change tracking, fast incremental backup, and backup validation output

Run consistent and inconsistent backups against a practice database and verify them with RESTORE ... VALIDATE and LIST output

Perform complete and incomplete recovery from backup sets, including point-in-time recovery using SET UNTIL

Diagnose and repair common restore failures such as missing archived logs, wrong SCN, and channel misconfiguration

Explain how the control file autobackup and recovery catalog change restore behavior

Recover a dropped or truncated table using both tablespace point-in-time recovery and Flashback Table, and state when each is legal

Use Flashback Database, Flashback Drop, Flashback Query, and Flashback Transaction Query to undo different classes of error

Configure the flashback recovery area and size it correctly for the retention guarantee you need

Interpret Data Recovery Advisor findings from RMAN and ADRCI and act on the recommended repair

Create a CDB with at least two PDBs and describe the CDB root, seed, and PDB$SEED roles

Switch containers with ALTER SESSION SET CONTAINER, connect locally, and explain which operations are legal only in the root

Manage PDB lifecycle states (open, mounted, read-only, restricted) and start them automatically at instance startup

Explain common users, local users, and the CONTAINER clause, and create each type correctly

Clone a PDB from a local PDB, from a remote PDB over a database link, and from a non-CDB, and state the prerequisites for each

Plug and unplug a PDB, including generating and applying the XML manifest and handling version compatibility

Create and manage a PDB snapshot copy and explain how it differs from a full clone

Configure PDB-level resource limits with shares, caps, and profiles, then observe the effect under load

Run a transportable tablespace export and import, including making tablespaces read-only, converting endianness, and handling dependencies

Use Data Pump with NETWORK_LINK and REMAP options to move a schema between databases

Read an AWR or Statspack-style report and identify the top wait events and SQL by elapsed time

Use SQL Tuning Advisor and SQL Access Advisor output to decide between a rewrite, an index, or a plan change

Interpret execution plans with DBMS_XPLAN and explain the difference between estimated and actual rows

Use SQL Plan Management to capture, evolve, and pin a plan, and explain when a baseline is preferable to a hint

Configure Resource Manager consumer groups, plans, and directives and verify enforcement with a running workload

Create and monitor Scheduler jobs and windows, and explain how maintenance windows drive automated tasks

Re-run one lab from each of the eight domains under time pressure without notes

Review every missed practice question and write the underlying rule rather than the answer

Rehearse the multitenant, backup, and flashback command syntax that is most easily confused

Take two timed full-length practice tests and record scores by domain