Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
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起来,不出一分钟就崩溃了,这到底是啥毛病啊??


下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 14:31 , Processed in 0.046948 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569