tailieunhanh - workshop - 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 | Workshop 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 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 Workshop Methodology Group-Oriented and Interactive Structure The workshop is structured to allow individuals to work in groups to perform database backup, restore, and recovery operations. Each group is encouraged to share its approach to resolving database failures with other groups in the class. Intensive Hands-On Diagnosis and Problem Resolution The intent is to provide you with as much hands-on experience | Workshop 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 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 Workshop Methodology Group-Oriented and Interactive Structure The workshop is structured to allow individuals to work in groups to perform database backup, restore, and recovery operations. Each group is encouraged to share its approach to resolving database failures with other groups in the class. Intensive Hands-On Diagnosis and Problem Resolution The intent is to provide you with as much hands-on experience as possible to diagnose and work through backup and recovery scenarios. Experience and knowledge gained from the course will play a major role toward successfully completing the objectives of each session. Using the Right Tools Enterprise Manager Database Control for Oracle Database 10g provides a wealth of information to the DBA. Filtering through the information to identify problems and knowing what tool to use to resolve them can be a challenge. By simulating problems that are not known to you ahead of time, you gain experience in locating problems and resolving them on your own. Workshop Methodology (continued) Variety of Failure Scenarios During this workshop, you will induce configuration errors by running a series of shell scripts. Your objective is to diagnose the nature of the problem and to make the necessary corrections or perform the appropriate recovery process. The types of failures that you may encounter include: Loss of a redo log group Media loss Data block corruption