操作:
对表做了move后,没有rebuild index,然后就关闭数据库了,导致数据库不能重新启动
alter<sid>.log
Errors in file /space/oracle/admin/test/udump/test_ora_22836.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01502: index 'SYS.I_ACCESS1' or partition of such index is in unusable state
Mon May 28 16:31:10 2007
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 22836
ORA-1092 signalled during: ALTER DATABASE OPEN...
more /space/oracle/admin/test/udump/test_ora_22836.trc:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /space/oracle/product/9.2.0
System name: SunOS
Node name: test
Release: 5.10
Version: Generic
Machine: sun4u
Instance name: test
Redo thread mounted by this instance: 1
Oracle process number: 12
Unix process pid: 22836, image: oracle@test (TNS V1-V3)
*** SESSION ID

11.3) 2007-05-28 16:31:08.284
Thread 1 recovery from rba:0x000722.00000002.0010 scn:0x0000.0386d5a1
----- Redo read statistics for thread 1 -----
Read rate (ASYNC) = 0Kb/sec => 1 blocks in 1s
Read buffer = 8192Kb (16384 blocks)
Longest record = 0Kb
Record moves = 0/1 (0%)
----------------------------------------------
*** 2007-05-28 16:31:08.330
KCRA: start recovery claims for 0 data blocks
*** 2007-05-28 16:31:08.330
KCRA: buffers claimed = 0/0, eliminated = 0
- Created archivelog as '/space/oracle/archive/1_1824.dbf'
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01502: index 'SYS.I_ACCESS1' or partition of such index is in unusable state