- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-14 18:38:01
|
查看: 1260 |
回复: 0
之前应该是断电了一次,然后就起不来了,照着网上的资料做了下恢复,但是即使起来了,一分钟左右又会自动崩溃掉。
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: {<RET>=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起来,不出一分钟就崩溃了,这到底是啥毛病啊??
|
|