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 | Workshop Objectives After completing this lesson, you should be able to do the following: Document a database configuration by using the Database Configuration Worksheet Configure an Oracle9i database to support stated business requirements Recover a failed database while minimizing down time and data loss Objectives Enable and use trace output for troubleshooting Identify and troubleshoot: Listener problems Client configuration issues Workshop Methodology Group-oriented and interactive Intensive hands-on diagnosis and problem resolution Variety of failure scenarios Recovery solutions Variety of configuration errors Develop troubleshooting 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 . | Workshop Objectives After completing this lesson, you should be able to do the following: Document a database configuration by using the Database Configuration Worksheet Configure an Oracle9i database to support stated business requirements Recover a failed database while minimizing down time and data loss Objectives Enable and use trace output for troubleshooting Identify and troubleshoot: Listener problems Client configuration issues Workshop Methodology Group-oriented and interactive Intensive hands-on diagnosis and problem resolution Variety of failure scenarios Recovery solutions Variety of configuration errors Develop troubleshooting 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. Workshop Methodology (continued) Variety of Failure Scenarios During this workshop, the instructor will induce configuration errors by running a series of shell scripts. The objective is to diagnose the nature of the failure and to make the necessary corrections. During this workshop, the instructor will also induce failure scenarios without informing the class. The objective is to diagnose the nature of the failure and to perform the appropriate recovery process. The types of failures that you may encounter include: Loss of a redo log group Loss of datafiles Loss of control files Media loss Loss of a table Loss of an online undo segment datafile Recovery Solutions This workshop simulates a real-world environment .
