环境:
DB: Oracle9i Enterprise Edition Release 9.2.0.4.0
OS: Red Hat Enterprise Linux AS release 3 (Taroon Update 2)
Kernel 2.4.21-15.EL on an i686
状况:
sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Sep 2 16:22:40 2004
Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.
SQL> connect SYS/change_on_install as SYSDBA
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area185668648 bytes
Fixed Size
451624 bytes
Variable Size
100663296 bytes
Database Buffers 83886080 bytes
Redo Buffers
667648 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
日志:
alert_bidb.log:
。。。。。。。。。。。。
Thu Sep2 16:19:37 2004
SMON: enabling cache recovery
Thu Sep2 16:19:38 2004
Errors in file /oracle/app/oracle/admin/bidb/udump/bidb_ora_8450.trc:
ORA-30012: undo tablespace '3.0' does not exist or of wrong type
Thu Sep2 16:19:38 2004
Error 30012 happened during db open, shutting down database
USER: terminating instance due to error 30012
Instance terminated by USER, pid = 8450
ORA-1092 signalled during: alter database open...
bidb_ora_8450.trc内容:
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 0Kb in 0.03s => 0.00 Mb/sec
Longest record: 0Kb, moves: 0/1 (0%)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
*** 2004-09-02 16:19:37.810
KCRA: start recovery claims for 0 data blocks
*** 2004-09-02 16:19:37.811
KCRA: buffers claimed = 0/0, eliminated = 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
ORA-30012: undo tablespace '3.0' does not exist or of wrong type
问题:
日志中的undo tablespace '3.0' 我数据库里没有啊,这是个什么玩意?
数据库起不来了怎样解决?
|