Workshop

1. Workshop

2. Objectives • After completing this lesson, you should be able to do the following: • Document a database configuration by using a Database Configuration Worksheet • Recover data while minimizing down time and data loss • Use database tools and features to monitor and improve database performance

3. Workshop Methodology • Team-oriented and interactive • Tools used to keep the database performance at specified levels • Hands-on diagnosis and problem resolution for a variety of failure scenarios • Multiple solutions possible for each scenario • Develop troubleshooting and administration skills

4. Business Requirements • Twenty-four hour availability • Varying peak usage across all time zones • Daily backups required • Complete database recovery required

5. Database Configuration • Archiving is enabled. • Log files are mirrored and distributed across multiple devices. • Control files are mirrored and distributed across multiple devices. • Flashback Database is enabled. • Full backup of the database exists, including archive log files.

6. Method for Resolving Database Issues • Phase I: Diagnose the problem. • Phase II: Determine the appropriate method to resolve the problem. • Phase III: Resolve the problem. • Phase IV: Back up the database, if needed.

7. Summary • Instructor-facilitated workshop • Team-oriented • Hands-on approach • Use tools and diagnostics to: • Monitor database performance • Identify problems and potential problems • Minimize down time and data loss

8. Practice Overview: Workshop Setup • This practice covers the following topics: • Restoring the database to a previous point in time • Performing a physical investigation of the database: • Using the Enterprise Manager Database Control Console • Using views and tools • Viewing command output and log files • Viewing trace files and the alert log • Modifying the database configuration to meet business requirements • Resolving typical database administrative issues