ORACLE数据库恢复策略分析

On Analysis of Recovery Strategies of Oracle Database

Oracle数据库恢复是保证数据库完整性及高可用性的重要一环,根据故障现象及恢复方法、目的的不同,分为一致性恢复和非一致性恢复。非归档模式下的恢复只能用冷备份对数据库进行复原;归档模式下的恢复有较多的选择,可根据需要任意选择恢复的时间点对数据库进行恢复,其前提是归档日志必须保存完好。

The recovery of Oracle database is a key link to guarantee high availability and integrahty.The recovery includes consistent recovery and non--cosistent recovery according to different trouble phenomenon, recovery methods and recovery objectives. The recovery in non--interfiling model is only carried out by cold backup, while the recovery in interfiling model may be carried out with more choices. The recovery time can arbitrarily be chosen according to needs with a prerequisite that the interfiling daily record must be kept well.