Database Software

After i restored my database on different host(its exactly the same with main host) with rman successfully, when i tried to startup database, facing with this problem above.

Total System Global Area 1653518336 bytes
Fixed Size 2227032 bytes
Variable Size 956302504 bytes
Database Buffers 687865856 bytes
Redo Buffers 7122944 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 31030
Session ID: 191 Serial number: 3


what i have done so far to overcome this problem;

tried to run catupgrd.sql

TO_NUMBER(value$) != (SELECT tz_version from registry$database))
*
ERROR at line 6:
ORA-00942: table or view does not exist


Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

----------------------------------------------------------------------------------------------------------------------------

btw theres a way of exporting schema when u open database with startup upgrade?... when i try to export with expdp ..getting another problem ;

ORA-39710: only connect AS SYSDBA is allowed when OPEN in UPGRADE mode

ORA-39710

Edited by: 828193 on 25.Oca.2012 04:05

Edited by: 828193 on 25.Oca.2012 04:06

Edited by: 828193 on 25.Oca.2012 04:07