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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-13 12:35:32 | 查看: 1250| 回复: 1
一个库3T 数据库,一次突然断电导致数据库起不来了,很不幸运备份没有了.

ALERT 出现了如下错误,
但是在如何用BBED处理错误的过程比较简略,我查看了edw_ora_676102.trc 里面有有FLAG=-----的标志,跟盖国强描述的一致.
但是我看不明白文献里BBED如何处理的,也没用过BBED....现在要起这个库,我恳求ITPUB的兄弟帮帮我

-----ALERT--------------------------
Thread 1 advanced to log sequence 2
Thread 1 opened at log sequence 2
  Current log# 4 seq# 2 mem# 0: /oradata/pdb01/redo0401.log
  Current log# 4 seq# 2 mem# 1: /oradata/pdb02/redo0402.log
Successful open of redo thread 1
Fri Dec 12 17:49:07 2008
SMON: enabling cache recovery
Fri Dec 12 17:49:08 2008
Errors in file /u01/oracle/admin/db/udump/edw_ora_676102.trc:
ORA-00600: internal error code, arguments: [4000], [4], [], [], [], [], [], []
Fri Dec 12 17:49:11 2008
Errors in file /u01/oracle/admin/dbudump/edw_ora_676102.trc:
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00600: internal error code, arguments: [4000], [4], [], [], [], [], [], []
Fri Dec 12 17:49:11 2008
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 676102
ORA-1092 signalled during: alter database open...


-------------edw_ora_676102.trc部分内容--------------
*** 2008-12-12 17:49:08.293
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [4000], [4], [], [], [], [], [], []
Current SQL statement for this session:
select ctime, mtime, stime from obj$ where obj# = :1
----- Call Stack Trace -----
`````
...skipping...
0x02   0x0004.03e.00000d68  0x0280004a.16b9.73  --U-    1  fsc 0x0000.5864d104

data_block_dump,data header at 0x70000016f7d005c
===============
tsiz: 0x7fa0
hsiz: 0x340
pbl: 0x70000016f7d005c
bdba: 0x0040005e
     76543210
flag=--------
ntab=1
nrow=407
frre=-1
fsbo=0x340
fseo=0xa05
avsp=0xc83
tosp=0xc83
0xeti[0]      nrow=407        offs=0
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

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

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

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
2#
发表于 2017-4-13 12:36:37
之前用过_allow_resetlogs_corruption=TRUE,恢复过,希望能强拉起DB


Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced

我想问下,如何确定这个未提交的信息,在那个数据文件上啊.BBED是对数据文件的操作

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

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

GMT+8, 2024-12-20 13:20 , Processed in 0.120381 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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