问题描述:
原数据库是11.2.0.1 版本,新数据库版本是11.2.0.4
今天准备把11.2.0.1 的数据库通过rman 恢复到11.2.0.4 数据库版本中去
在恢复完成之后,准备打开数据库的时候,报了如下错误:
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: 76308
Session ID: 149 Serial number: 3
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: 76308
Session ID: 149 Serial number: 3
解决方法:
1.使用 startup upgrade 打开数据库
2.执行:$ORACLE_HOME/rdbms/admin/catupgrd.sql //修改数据字典即可
这个过程时间比较长
执行完上面操作执行,重新正常打开数据库即可
SQL> startup
ORACLE instance started.
ORACLE instance started.
Total System Global Area 1406128128 bytes
Fixed Size 1336484 bytes
Variable Size 1174408028 bytes
Database Buffers 218103808 bytes
Redo Buffers 12279808 bytes
Database mounted.
Database opened.
Fixed Size 1336484 bytes
Variable Size 1174408028 bytes
Database Buffers 218103808 bytes
Redo Buffers 12279808 bytes
Database mounted.
Database opened.