今天在恢复数据库的时候，出现如下错误:
Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs
2 ;
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: 17269
Session ID: 17 Serial number: 55
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 714627217 generated at 07/01/2013 13:07:34 needed for thread
1
ORA-00289: suggestion : /mnt/db1/arch/1_1600_799170678.dbf
ORA-00280: change 714627217 for thread 1 is in sequence #1600
[@more@]
ORA-00279: change 714627217 generated at 07/01/2013 13:07:34 needed for thread
1
ORA-00289: suggestion : /mnt/db1/arch/1_1600_799170678.dbf
ORA-00280: change 714627217 for thread 1 is in sequence #1600
Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs
2 ;
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: 17269
Session ID: 17 Serial number: 55
原来的数据库版本为11.2.0.1,现在的数据库版本为11.2.0.3。
所以需要执行如下几个脚本。
SQL> startup upgrade
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@testdb ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 2 09:12:35 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 672256000 bytes
Fixed Size 2231392 bytes
Variable Size 402654112 bytes
Database Buffers 264241152 bytes
Redo Buffers 3129344 bytes
Database mounted.
SQL> startup upgrade
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> @startup upgrade
SP2-0310: unable to open file "startup.sql"
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 672256000 bytes
Fixed Size 2231392 bytes
Variable Size 402654112 bytes
Database Buffers 264241152 bytes
Redo Buffers 3129344 bytes
Database mounted.
Database opened.
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@testdb ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 2 09:12:35 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 672256000 bytes
Fixed Size 2231392 bytes
Variable Size 402654112 bytes
Database Buffers 264241152 bytes
Redo Buffers 3129344 bytes
Database mounted.
SQL> startup upgrade
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> @startup upgrade
SP2-0310: unable to open file "startup.sql"
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 672256000 bytes
Fixed Size 2231392 bytes
Variable Size 402654112 bytes
Database Buffers 264241152 bytes
Redo Buffers 3129344 bytes
Database mounted.
Database opened.
问题解决
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24237320/viewspace-1060651/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- [Linux7] HA Package Yum源配置
- [ASM] ORA-15032 ORA-15260
- [RAC] Oracle11g RAC禁止DB自动启动
- [Oracle] Device Checks for ASM - This is a pre-check........
- [Linux7] Centos7 multipath 盘权限绑定.
- [Linux7] zabbix 3.2.11安装
- [Oracle] Error in invoking target 'agent nmhs' of makefile
- [Linux] 查看环境变量
- [HPUX] HP Unix server vg自动激活
- [HPUX] UX:vxfs mount: ERROR: V-3-21264
