【Oracleデータリカバリ】ORA-00704: ガイドプログラムプロセスが失敗した ORA-39700: UPGRADE オプションでデータベースエラ解析の例をオープンする

プロのOracle Databaseの復旧サービスを提供
携帯番号： +86 13764045638 メール：service@parnassusdata.com

$ 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 二つのエラは一般的にデータベースデータディクショナリーを誤った操作した場合に、バーション違ったにもひどいトラブルがあるかも知れない。

一般的、正確なORACLE PATHを調整してください。同時に、ディクショナリーをアップグレードするスクリプトを再び実行する。例えば、 catupgrd.sql； まだ解決出来ない場合には、人工的にpatch データディクショナリーを調整してください。