Influence of Open Resetlogs on Oracle Database Recovery
- VernacularTitle:Open resetlogs操作对Oracle数据库恢复的影响
- Author:
Changming LIANG
;
Gongzhi YUAN
;
Zhanwei QIN
;
Jianguang YANG
- Publication Type:Journal Article
- Keywords:
Oracle incarnation;
resetlogs;
backup;
recovery
- From:
Chinese Medical Equipment Journal
1989;0(04):-
- CountryChina
- Language:Chinese
-
Abstract:
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.
