【Oracle数据恢复】ORA-00704: 引导程序进程失败 ORA-39700: 必须用 UPGRADE 选项打开数据库错误解析一例

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638    QQ号:47079569    邮箱:[email protected]

$ oerr ora 704
00704, 00000, "bootstrap process failure"
// *Cause:  Failure in processing bootstrap data - see accompanying error.
// *Action: Contact your customer support representative.

$ oerr ora 39700
39700, 00000, "database must be opened with UPGRADE option"
// *Cause:  A normal database open was attempted, but the database has not 
//          been upgraded to the current server version.
// *Action: Use the UPGRADE option when opening the database to run 
//          catupgrd.sql (for database upgrade), or to run catalog.sql 
//          and catproc.sql (after initial database creation).

Recovery of Online Redo Log: Thread 1 Group 3 Seq 9 Reading mem 0
  Mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\orcl\REDO03.LOG
Tue Dec 10 09:33:56 2013
Completed redo application
Tue Dec 10 09:33:56 2013
Completed crash recovery at
 Thread 1: logseq 9, block 5, scn 10226857380
 0 data blocks read, 0 data blocks written, 2 redo blocks read
Tue Dec 10 09:33:56 2013
Thread 1 advanced to log sequence 10 (thread open)
Thread 1 opened at log sequence 10
  Current log# 1 seq# 10 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\orcl\REDO01.LOG
Successful open of redo thread 1
Tue Dec 10 09:33:57 2013
SMON: enabling cache recovery
Tue Dec 10 09:33:57 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_1596.trc:
ORA-00704: 引导程序进程失败
ORA-39700: 必须用 UPGRADE 选项打开数据库

Tue Dec 10 09:33:57 2013
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Tue Dec 10 09:33:57 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mman_4060.trc:
ORA-00704: bootstrap process failure

Tue Dec 10 09:33:57 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_dbw0_1800.trc:
ORA-00704: bootstrap process failure

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

The following is observed in the sqlplus session

SQL> startup;
ORACLE instance started.

Total System Global Area 1954160640 bytes
Fixed Size                  2227752 bytes
Variable Size            1325400536 bytes
Database Buffers          620756992 bytes
Redo Buffers                5775360 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: 22861
Session ID: 1705 Serial number: 5

以上的ORA-00704和ORA-39700 2个错误一般出现在升级数据库数据字典操作不当的场景中,可能是使用了版本错误的ORACLE BINARY也可能是数据字典本身有严重的问题了。

 

一般建议调整正确的 ORACLE PATH ,同时重新运行字典升级的脚本例如 catupgrd.sql; 如仍无法解决,则可能需要手动patch 数据字典了。

 

 

 


Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *