In this Document
Symptoms |
Cause |
Solution |
References |
APPLIES TO:
Oracle Database - Enterprise Edition - Version 10.2.0.3 and laterInformation in this document applies to any platform.
SYMPTOMS
Recovery of an older database version backup results in error upon database open:
ORA-39700: database must be opened with UPGRADE option
....
ORA-01092: ORACLE instance terminated. Disconnection forced
CAUSE
Error occurs because the current database version is newer than the backup datafiles, upgrade
steps must be taken which require the database to be started with the UPGRADE option.
When a database is upgraded from one version to another, the database must be started with UPGRADE
option to execute the necessary upgrade steps. The database cannot be opened in read write under
the new version until these steps are taken. This justifies cause.
If incomplete recovery is required, the database should be opened with:
If an attempt to open the database without the upgrade option, the error will occur. This can be resolved with the steps documented below.
SOLUTION
To implement the solution, please execute the following steps:
1. Perform restore and recovery.
2. Open the database with resetlogs:
NOTE: this will fail with ORA-1092. The alert.log will show the ORA-39700: database must be
opened with UPGRADE option error.
3. Open the database with upgrade option:
NOTE: due to the ORA-1092, the current sqlplus session must be exited and new connection made.
4. Perform necessary upgrade steps as documented in the readme file for the patch/upgrade you applied. For example, catupgrd.sql.
5. Once upgrade steps are complete, shutdown and open the database:
SQL> startup
NOTE: any attempts to recover after the upgrade steps (especially with 'using backup
controlfile') will result in error. In addition, there is no need to use the RESETLOGS option
upon open. The key here is after the upgrade, the database should be opened with STARTUP.
Instance recovery and the fact that the controlfile is now CURRENT, will allow Oracle to apply the
necessary information in the online redo log files and startup the database.