ORA-39700: database must be opened with UPGRADE

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 07/15/2013 11:22:31
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 4308
Session ID: 3726 Serial number: 7
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-03114: not connected to ORACLE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 07/15/2013 11:22:31
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 4308
Session ID: 3726 Serial number: 7


[oracle11@hostname ~]$ sqlplus

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 15 11:22:57 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup mount with pfile='/u01/neeraj_backup/neer.ora'
ORACLE instance started.

Total System Global Area 1238732800 bytes
Fixed Size                  1344624 bytes
Variable Size            1140853648 bytes
Database Buffers           83886080 bytes
Redo Buffers               12648448 bytes
ORA-02231: missing or invalid option to ALTER DATABASE


SQL> alter database mount;

Database altered.

SQL> create spfile from pfile='/u01/neeraj_backup/neer.ora';

File created.


SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.


SQL> conn
Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup upgrade
ORACLE instance started.

Total System Global Area 1238732800 bytes
Fixed Size                  1344624 bytes
Variable Size            1140853648 bytes
Database Buffers           83886080 bytes
Redo Buffers               12648448 bytes
Database mounted.
Database opened.

SQL> spool upgrade.log
SQL>
SQL> @ /u01/app/oracle11/product/11.2.0/dbhome_1/rdbms/admin/catupgrd.sql

connect with sqlplus
and login .....




The catupgrd.sql script determines which upgrade scripts must be run, runs them, and then shuts down the database. You must run the script in the Oracle Database 11g Release 2 (11.2) environment.

The upgrade script creates and alters certain data dictionary tables. It also upgrades or installs the following database components in the new Oracle Database 11g Release 2 (11.2) database:

•     Oracle Database Catalog Views
•     Oracle Database Packages and Types
•     JServer JAVA Virtual Machine
•     Oracle Database Java Packages
•     Oracle XDK
•     Oracle Real Application Clusters
•     Oracle Workspace Manager
•     Oracle Multimedia
•     Oracle XML Database
•     OLAP Analytic Workspace
•     Oracle OLAP API
•     OLAP Catalog
•     Oracle Text
•     Spatial
•     Oracle Data Mining
•     Oracle Label Security
•     Messaging Gateway
•     Oracle Expression Filter
•     Oracle Rules Manager
•     Oracle Enterprise Manager Repository
•    Oracle Database Vault
• Oracle Application Express

All the best...... :)