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

Influence of Open Resetlogs on Oracle Database Recovery

作　　者：梁昌明 袁功智 秦占伟 杨建光 

机构地区：[1]解放军第517医院,山西岢岚036301

出　　处：《医疗卫生装备》2008年第4期52-53,55,共3页Chinese Medical Equipment Journal

摘　　要：目的:讨论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]

关 键 词：ORACLE INCARNATION resetlogs 备份 恢复 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]