Objectives After completing this lesson, you should be able to do the following: Define requirements for a backup and recovery strategy Articulate the importance of management concurrence for the strategy Identify the components of a disaster recovery plan List Oracle Server features in the context of high availability Objectives List the strengths of different database configurations for recoverability Discuss the importance of testing a backup and recovery plan Backup and Recovery Issues Protect the database from numerous types of failures Increase Mean-Time-Between-Failures (MTBF) Decrease Mean-Time-To-Recover (MTTR) Minimize data loss Defining a Backup and Recovery Strategy Business requirements Technical requirements Operational requirements Management concurrence Business Requirements Mean-Time-To-Recover Mean-Time-Between-Failure Evolutionary process Operational Requirements 24-hour operations User and operator appreciation Testing and validating backups Technical Requirements Resources: Hardware, software, manpower, and time Physical image copies of the operating system files Logical copies of the objects in the database Database configurations Transaction volume affects desired frequency of backups Disaster Recovery Issues How will your business be affected in the event of a major disaster? Earthquake, flood, fire, or complete loss of machine Malfunction of storage hardware or software Loss of key personnel, such as the database administrator Do you have a plan for testing your strategy periodically? Do you perform the strategy tests? Oracle Features Oracle features for maintaining high availability of database include: Oracle Parallel Server Oracle FailSafe Summary In this lesson, you should have learned how to: Develop a strategy dictated by business, operational, and technical requirements Consider a test plan for a backup and recovery strategy Constitute an effective strategy Take advantage of new Oracle8i features for availability