Technical training on advanced Oracle Database administration, specifically covering the following topics: Data Guard, Backup & Recovery, and Performance & Tuning.

Topics

1° module (Data Guard)

• Introduction to Oracle Data Guard: architectures, topologies, services, and brokers.

2° module (Data Guard)

• Configuration: requirements, setup, administration, DR testing, definition of RTO and RPO, troubleshooting.

3° module (Backup)

• Definition of backup policies, configuration of backups for environments (e.g., FRA, ZFSS, etc.), monitoring, and troubleshooting.

4° module (Restore&Recovery)

• Definitions and overview, preparation of restore environments, management of restore tests, restore and recovery methods (e.g., databases, tables, etc.), definition of RTO and RPO, troubleshooting.

5° module (Performance & Tuning)

• Definitions and Concepts: Performance and Tuning, query analysis, interpretations and insights on AWR and ASH, SQL profiles and useful tools (toolkit) for DBAs.

6° module (Performance & Tuning)

• Analysis and Troubleshooting: presentation of use cases, best practices, STS and RAT.