Objective To upgrade Oracle database to Oracle 10g Release 2 in No.1 Military Medical Project. Methods Technologies such as database upgrade assistance, manual script upgrade, exp/imp(expdp/impdp)of DBUA, transportable tablespace, materialized view and table copy were used to upgrade Oracle database respectively. Results It showed that all of these methods could upgrade Oracle database. Conclusion Although all of these methods can upgrade Oracle database, there are differences in their procedures and efficencies, so suitable methods should be chosen according to practical situation.

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.