Đang chuẩn bị liên kết để tải về tài liệu:
Backup and Recovery Concepts

.Objectives After completing this lesson, you should be able to do the following: • Identify the types of failure that may occur in an Oracle database • Describe | Backup and Recovery Concepts Objectives After completing this lesson, you should be able to do the following: Identify the types of failure that may occur in an Oracle database Describe ways to tune instance recovery Identify the importance of checkpoints, redo log files, and archive log files Configure ARCHIVELOG mode Part of Your Job The administrator’s duties are to: Protect the database from failure wherever possible Increase the Mean-Time-Between-Failures (MTBF) Decrease the Mean-Time-To-Recover (MTTR) Minimize the loss of data Part of Your Job The database administrator’s (DBA’s) goal is to ensure that the database is open and available when users need it. To achieve that goal, the DBA (usually working with the system administrator): Anticipates and works to avoid common causes of failure Works to increase the Mean-Time-Between-Failures (MTBF), ensuring that hardware is as reliable as possible, that critical components are protected by redundancy, and that operating system maintenance is performed in a timely manner. The Oracle database provides advanced configuration options to increase MTBF, including: Real Application Clusters (discussed in the Oracle Database 10g: Real Application Clusters course) Streams (discussed in the Oracle Database 10g: Implement Streams course) Decreases the Mean-Time-To-Recover (MTTR), practicing recovery procedures in advance and configuring backups so that they are readily available when needed Minimizes the loss of data. DBAs, who follow accepted best practices, can configure their databases so that no committed transaction is ever lost. Entities that assist in guaranteeing this include: Archive log files (discussed later in this lesson) Standby databases and Oracle Data Guard (discussed in the Oracle Database 10g: Data Guard Administration course) Categories of Failures Failures can generally be divided into the following categories: Statement failure User process failure Network failure User error Instance failure Media . | Backup and Recovery Concepts Objectives After completing this lesson, you should be able to do the following: Identify the types of failure that may occur in an Oracle database Describe ways to tune instance recovery Identify the importance of checkpoints, redo log files, and archive log files Configure ARCHIVELOG mode Part of Your Job The administrator’s duties are to: Protect the database from failure wherever possible Increase the Mean-Time-Between-Failures (MTBF) Decrease the Mean-Time-To-Recover (MTTR) Minimize the loss of data Part of Your Job The database administrator’s (DBA’s) goal is to ensure that the database is open and available when users need it. To achieve that goal, the DBA (usually working with the system administrator): Anticipates and works to avoid common causes of failure Works to increase the Mean-Time-Between-Failures (MTBF), ensuring that hardware is as reliable as possible, that critical components are protected by redundancy, and that operating system .