oracle@linux-l4nt:~> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Sat Jan 23 10:58:31 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
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
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...
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.trc
KCRA: 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
*** 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_HOME/rdbms/admin/catalog.sql 和@$ORACLE_HOME/rdbms/admin/catproc.sql)
处理过程:
oracle@linux-l4nt:~> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Sat Jan 23 11:06:22 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup upgrade
ORACLE instance started.
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.
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.
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.
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.
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.
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.
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.
Fixed Size 1267044 bytes
Variable Size 130026140 bytes
Database Buffers 146800640 bytes
Redo Buffers 7118848 bytes
Database mounted.
Database opened.
处理完毕!!!!!!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22779291/viewspace-625825/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22779291/viewspace-625825/