Monday, March 14, 2016

ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option

ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option

alter database open
*
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: 26280000
Session ID: 753 Serial number: 5

After RMAN restore to another server. Please check the source and target database version you have.

In my case,
source:  11.2.0.3.0
target: 11.2.0.1.0

sqlplus / as sysdba

sql>startup upgrade

sql>@$ORACLE_HOME/rdbms/admin/catupgrd.sql

sql>@$ORACLE_HOME/rdbms/admin/utlrp.sql

sql>shut immediate

sql>startup

No comments:

Post a Comment