oracle@linux-l4nt:~> sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Sat Jan 23 10:58:31 2010Copyright (c) 1982, 2007,
Oracle. All Rights Reserved.Connected to an idle instance.SQL> startup
ORACLE instance started.Total System Global Area 285212672 bytes
Fixed Size 1267044 bytes
Variable Size 130026140 bytes
Database Buffers 146800640 bytes
Redo Buffers 7118848 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced查看alert_orcl.log檔案Errors in file /opt/oracle/admin/orcl/udump/orcl_ora_8281.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Sat Jan 23 10:08:05 2010
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 8281
ORA-1092 signalled during: ALTER DATABASE OPEN...查看/opt/oracle/admin/orcl/udump/orcl_ora_8281.trcKCRA: start recovery claims for 96 data blocks
*** 2010-01-23 10:08:04.520
KCRA: blocks processed = 96/96, claimed = 96, eliminated = 0
*** 2010-01-23 10:08:04.520
Recovery of Online Redo Log: Thread 1 Group 1 Seq 2 Reading mem 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 96/96 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 1283/1287 = 1.0
----------------------------------------------
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option原因：因為今天進行了
資料庫升級，資料字典的一些基表內容被修改了。解決方案：執行$ORACLE_HOME/rdbms/admin/catupgrd.sql(如果報錯，執行
@$ORACLE_HOME/rdbms/admin/catalog.sql 和@$ORACLE_HOME/rdbms/admin/catproc.sql)處理過程：oracle@linux-l4nt:~> sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Sat Jan 23 11:06:22 2010Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to an idle instance.SQL> startup upgrade
ORACLE instance started.Total System Global Area 285212672 bytes
Fixed Size 1267044 bytes
Variable Size 130026140 bytes
Database Buffers 146800640 bytes
Redo Buffers 7118848 bytes
Database mounted.
Database opened.
SQL>@ORACLE_HOME/rdbms/admin/catupgrd.sql
....
沒有報錯
SQL>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.SQL>startup
ORACLE instance started.Total System Global Area 285212672 bytes
Fixed Size 1267044 bytes
Variable Size 130026140 bytes
Database Buffers 146800640 bytes
Redo Buffers 7118848 bytes
Database mounted.
Database opened.成功啟動資料庫。
備份資料。如果執行過程中有錯誤，完成後仍然無法正常啟動，則這個指令碼不可用，換其他兩個指令碼執行SQL> startup upgrade
ORACLE instance started.Total System Global Area 285212672 bytes
Fixed Size 1267044 bytes
Variable Size 130026140 bytes
Database Buffers 146800640 bytes
Redo Buffers 7118848 bytes
Database mounted.
Database opened.
SQL>@$ORACLE_HOME/rdbms/admin/catalog.sql
.....
SQL>@$ORACLE_HOME/rdbms/admin/catproc.sql
.....
SQL>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.SQL>startup
ORACLE instance started.Total System Global Area 285212672 bytes
Fixed Size 1267044 bytes
Variable Size 130026140 bytes
Database Buffers 146800640 bytes
Redo Buffers 7118848 bytes
Database mounted.
Database opened.處理完畢！！！！！！
