Overview One of the major responsibilities of a database administrator (DBA) is to ensure that the database is available for use. The DBA can take precautions to minimize failure of the system. In spite of the precautions, it is naive to think that failures will never occur. The DBA must make the database operational as quickly as possible in case of a failure and minimize the loss of data. To protect the data from the various types of failures that can occur, the DBA must back up the database regularly. Without a current backup, it is impossible for the DBA to. | Backup and Recovery Overview Objectives After completing this lesson, you should be able to do the following: Describe the basics of database backup, restore, and recovery List the types of failures that may occur in an Oracle environment Define a backup and recovery strategy 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 Overview One of the major responsibilities of a database administrator (DBA) is to ensure that the database is available for use. The DBA can take precautions to minimize failure of the system. In spite of the precautions, it is naive to think that failures will never occur. The DBA must make the database operational as quickly as possible in case of a failure and minimize the loss of data. To protect the data from the various types of failures that can occur, the DBA must back up the database regularly. Without a current backup, it is impossible for the DBA to get the database up and running if there is a file loss, without losing data. Backups are critical for recovering from different types of failures. The task of validating backups cannot be overemphasized. Making an assumption that a backup exists without actually checking its existence can prove very costly if it is not valid. Categories of Failures Statement failure User process failure User error Network failure Instance failure Media failure Categories of Failures Different types of failures may occur in an Oracle database environment. These include: Statement failure User process failure User error Instance failure Media failure Network failure Each type of failure requires a varying level of involvement by the DBA to recover effectively from the situation. In some cases, recovery depends on the type of backup strategy that has been implemented. For example, a statement failure requires little DBA intervention, whereas a media failure requires the DBA to . | Backup and Recovery Overview Objectives After completing this lesson, you should be able to do the following: Describe the basics of database backup, restore, and recovery List the types of failures that may occur in an Oracle environment Define a backup and recovery strategy 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 Overview One of the major responsibilities of a database administrator (DBA) is to ensure that the database is available for use. The DBA can take precautions to minimize failure of the system. In spite of the precautions, it is naive to think that failures will never occur. The DBA must make the database operational as quickly as possible in case of a failure and minimize the loss of data. To protect the data from the various types of failures that can occur, the DBA must back up the database regularly. Without a current backup, it is .
