Open resetlogs操作对Oracle数据库恢复的影响

Influence of Open Resetlogs on Oracle Database Recovery

目的:讨论Open resetlogs操作对Oracle数据库恢复的影响。方法:利用resetlogs操作前的备份进行数据库恢复,Oracle9i之前主要采用两段式方法执行恢复操作;Oracle10g中利用其归档日志的新格式。结果:2种方法均可以利用resetlogs操作前的备份进行数据库恢复。结论:Oracle9i之前分段实现数据库的恢复,步骤繁琐,建议用resetlogs操作打开数据库后,做一个一致性的全库备份;利用Oracle10g的改进特性,可以轻易地跨越resetlogs点进行恢复。

Objective To discuss the influence of Open resetlogs on Oracle database recovery. Methods Database backup was used to recover database before resetlogs. Before Oracle 9i, Oracle database was recovered through two steps; after Oracle10g, Oracle archived redo log by new format. Results Both methods could recover Oracle database by using backups before resetlogs. Conclusion Before Oracle9i, the recovery steps are complex, so it is suggested a consistent database backup should be made after resetlogs. By using the new archived redo log format after Oracle10g, it is easy to recover database through resetlogs. [Chinese Medical Equipment Journal, 2008,29（4） ： 52-53,55]