← All Training Programs

Oracle Database Administration

Comprehensive curriculum · 27 topics incl. ASM & advanced RMAN

1–5 — Architecture, Installation & Instance Management

Oracle Database and ASM architecture; process and memory structures
Installing Oracle software with OUI and Grid Infrastructure (incl. silent installs)
Creating databases with DBCA; templates and security
Managing the Oracle instance; startup/shutdown stages, alert logs, ASM
Configuring the Oracle network environment and the Listener

6–11 — Storage, Security & Performance

Managing storage structures, tablespaces and Oracle Managed Files (OMF)
Administering user security, roles and profiles
Managing data concurrency, locks and deadlocks
Managing undo data and retention
Database auditing and audit trail maintenance
Performance management: AWR, ADDM, AMM and tuning views

12–16 — Backup, Recovery & Data Movement

Backup & recovery concepts; instance recovery and MTTR Advisor
Performing backups with RMAN and the Flash Recovery Area
Database recovery and the Data Recovery Advisor
Data movement: SQL*Loader, external tables and Oracle Data Pump
Working with Oracle Support and managing patches

17–23 — Advanced RMAN

RMAN recovery catalog, stored scripts and virtual private catalog
Configuring backup specifications, channels and optimization
Image copies, incremental, compressed and encrypted backups
User-managed backup and recovery scenarios
RMAN recovery operations, restoring to a new host
RMAN database duplication and cloning
Monitoring and tuning RMAN performance

24–27 — ASM & Advanced Topics

Automatic Storage Management fundamentals and disk groups
Failure groups, redundancy and disk group management
Creating and managing databases on ASM
Advanced RMAN: strategies, troubleshooting and best practices