⚙️ Day 1: Architecture & RMAN Catalog
- Lesson 1 : Database Architecture and ASM (Automatic Storage Management Setup)
- Lesson 2 : Configuring for Recoverability (ARCHIVELOG Mode, Flash Recovery Area)
- Lesson 3 : Using the RMAN Recovery Catalog (Creation, Registration, Catalog Scripts)
- Lesson 4 : Configuring Backup Specifications (Autobackup, Channel Allocation, Optimization)
⚙️ Day 2: Backups & Recovery Exercises
- Lesson 5 : Using RMAN to Create Backups (Backupsets, Image copies, Compress backups)
- Lesson 6 : Performing User-Managed Backup and Recovery (Offline/Online tablespace backups)
- Lesson 7 : Using RMAN to Perform Recovery (Critical files, Non-critical files restoration)
- Lesson 8 : Using RMAN to Duplicate a Database (Cloning DB)
⚙️ Day 3: Point-in-Time Recovery & Flashback
- Lesson 9 : Performing Tablespace Point-in-Time Recovery (TSPITR)
- Lesson 10 : Monitoring and Tuning RMAN (RMAN performance bottlenecks)
- Lesson 11 : Using Flashback Technology (Flashback Query, Flashback Table, Flashback Drop)
- Lesson 12 : Additional Flashback Operations (Flashback Database, Flashback Archive)
⚙️ Day 4: Diagnostics & Performance
- Lesson 13 : Diagnosing the Database (Automatic Diagnostic Repository ADR, Block corruption)
- Lesson 14 : Managing Memory (AMM, ASMM, PGA/SGA parameters configuration)
- Lesson 15 : Managing Database Performance (AWR, ADDM, SQL Tuning Advisor)
- Lesson 16 : Space Management (Tablespace resizing, Segment shrink, Resumable Space Allocation)
⚙️ Day 5: Resource Management & Scheduler
- Lesson 17 : Managing Resources (Database Resource Manager, Resource Consumer Groups)
- Lesson 18 : Automating Tasks with the Scheduler (Schedules, Programs, Jobs creation)
- Lesson 19 : Administering the Scheduler (Events, Chains, Window priorities)
- Lesson 20 : Globalization (Character sets, NLS settings)