Oracle Database Backup Recovery Overview

1, the meaning of the backup

1 protection of data, to avoid loss of data due to various failures

2. Introduction to Basic terms

Mean Time Between Failure--MTBF

Mean Time to Repair--mttr

Mean Time to Failure--mttf

(1) The mtbf--full name is mean time Between failure, that is, the mean fault interval.

Is the average of the time when the new product starts working under the prescribed working conditions and the first failure occurs. The longer the MTBF, the higher the reliability, the stronger the correct working ability.

(2) The mttr--full name is mean time to Repair, that is, the average recovery period.

is from the time of failure to the middle of the recovery period. The shorter the mttr, the better the ease of recoverability.

(3) The mttf--full name is mean time to failure, that is, the average no downtime.

The average system can run normally for a long time before a failure occurs. The higher the reliability of the system, the longer the average fault-free time is. (MTBF = MTTF + MTTR)

Reliability is a standard that initially determines the probability of a system running efficiently within a specific operating time. The measurement of reliability requires the system to remain in normal operation for a certain period of time.

This article URL address: http://www.bianceng.cn/database/Oracle/201410/45403.htm

At present, one of the most widely used parameters for measuring reliability is mttf (mean time to failure, average expiration date), defined as "expected value" of random variable, error time, etc. However, MTTF is often wrongly understood as "the shortest life cycle that can be guaranteed." The length of the MTTF is usually related to the product in the use cycle, which does not include aging failure.

MTTR (mean time to restoration), which originates from the average maintenance time in IEC 61508 (mean times to repair), is designed to clearly define the concept of time in the term, MTTR is expected for the recovery time of a random variable. It includes the time required to confirm the failure to occur, and the time required to maintain it. Mttr must also include time to get accessories, repair team response time, record all task time, and time to put the device back into use.

MTBF (Mean time between failures, mean fault interval) is defined as the average time required for failure or maintenance, including the time of failure and the time to detect and maintain the device. For a simple maintainable component, MTBF = MTTF + MTTR. Because mttr is usually much smaller than MTTF, MTBF is approximately equal to MTTF and is usually replaced by MTTF. MTBF is used in systems that are maintainable and not maintainable.

3, the type of database failure

1) Statement failure

2 User process Failure:pmon Automatic processing

3 User errors: Must be restored by DBA through backup

4) Instance failure:instance recover Smon Automatic Processing

5 Media recover: Restore via Backup

4, the development of your backup and recovery plan

1 according to the recovery cycle of the production environment, make a detailed backup plan, and then strictly implement

2 to backup, in a certain period of time to take advantage of the test environment, the practice of recovery