ORA-01092 ORA-00704 ORA-39700 database must be opened with UPGRADE option

冷备份恢复数据库报错

SQL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 15638
Session ID: 191 Serial number: 1
 

/*

解决办法：
以STARTUP UPGRADE启动实例
执行@ORACLE_HOME/rdbms/admin/catupgrd.sql 修改数据字典即可

这步执行时间较长。

*/

SQL>startup upgrade
SQL>@?/rdbms/admin/catupgrd.sql
SQL>@?/rdbms/admin/catalog.sql
SQL>@?/rdbms/admin/catproc.sql
SQL>@?/rdbms/admin/utlrp.sql
SQL>shutdown immediate
SQL>startup