oracle定时崩溃 共享,求救，数据库好像一直在自动崩溃 - Oracle数据库管理 - Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软件旗下...

之前应该是断电了一次，然后就起不来了，照着网上的资料做了下恢复，但是即使起来了，一分钟左右又会自动崩溃掉。

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 277600850 generated at 05/31/2013 14:03:31 needed for thread

1

ORA-00289: suggestion : /oradata1/tjepkg/archive/1_2_816875765.dbf

ORA-00280: change 277600850 for thread 1 is in sequence #2

Specify log: {=suggested | filename | AUTO | CANCEL}

/oradata1/tjepkg/redo02.log

Log applied.

Media recovery complete.

SQL> alter database open resetlogs;

Database altered.

SQL> select status from v$instance;------------在这检查了下实例状态，结果是open的。

STATUS

------------

OPEN

SQL> select status from v$instance;-------什么都没干，放了一分钟左右，又检查次，就失去连接了。

select status from v$instance

*

ERROR at line 1:

ORA-03135: connection lost contact

SQL> shutdown immediate------------------------尝试关机，但是报错了

ORA-24324: service handle not initialized

ORA-01041: internal error. hostdef extension doesn't exist

SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 31 14:19:40 2013----------退出后重新连接了

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> select status from v$instance;------这时就报无效的了

select status from v$instance

*

ERROR at line 1:

ORA-01034: ORACLE not available

SQL> startup mount---------------然后又可以启动到mount,应该是刚才open后自动崩溃了

ORACLE instance started.

Total System Global Area  578813952 bytes

Fixed Size                  2022544 bytes

Variable Size             163578736 bytes

Database Buffers          406847488 bytes

Redo Buffers                6365184 bytes

Database mounted.

SQL> alter database open;------再想打开就直接出错了。

alter database open

*

ERROR at line 1:

ORA-00607: Internal error occurred while making a change to a data block

ORA-00600: internal error code, arguments: [4194], [36], [39], [], [], [], [],

[]

大体就是这问题，然后就是不断的重复这步骤，每次即使open起来，不出一分钟就崩溃了，这到底是啥毛病啊？？