Transcript Workshop Scenario 2

Workshop
Copyright © Oracle Corporation, 2004. All rights reserved.
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
18-2
Copyright © Oracle Corporation, 2004. All rights reserved.
Workshop Methodology
•
•
•
•
•
18-3
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
Copyright © Oracle Corporation, 2004. All rights reserved.
Business Requirements
•
•
•
•
18-5
Twenty-four hour availability
Peak usage varies across all time zones
Daily backups are required
Complete database recovery is required
Copyright © Oracle Corporation, 2004. All rights reserved.
Database Configuration
•
•
•
•
•
•
18-6
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
Database performance thresholds set to meet
business requirements
Full backup of the database exists, including
archive log files
Copyright © Oracle Corporation, 2004. All rights reserved.
Simulated Application
•
•
•
18-7
One or more jobs will be scheduled to simulate
application users.
The jobs will run queries and DML operations
against application tables.
Some scenarios may use sessions spawned
through shell scripts.
Copyright © Oracle Corporation, 2004. All rights reserved.
Method for Resolving Database Issues
•
•
•
•
18-8
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
Copyright © Oracle Corporation, 2004. All rights reserved.
Summary
•
•
•
•
Instructor-facilitated workshop
Team-oriented
Hands-on approach
Use tools and diagnostics to:
– Monitor database performance
– Identify problems and potential problems
•
18-10
Minimize down time and data loss
Copyright © Oracle Corporation, 2004. All rights reserved.
Practice 18 Overview: Workshop Setup
This practice covers the following topics:
• Restore the database to a previous point in time
• Perform a physical investigation of the database:
– Use the Enterprise Manager Database Control
Console
– Use views and tools
– View command output and log files
– View trace files and the alert log
•
•
18-11
Modify the database configuration to meet
business requirements
Resolve typical database administrative issues
Copyright © Oracle Corporation, 2004. All rights reserved.