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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-12 19:00:16 | 查看: 1157| 回复: 0
数据库版本为9.2.0.1
前几天数据库突能断开,一下是启动数据库时候的报错日志:
SMON: about to recover undo segment 2
SMON: about to recover undo segment 2
SMON: mark undo segment 2 as available
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as available
SMON: about to recover undo segment 14
Sat May 29 13:56:47 2010
Errors in file e:\oracle\admin\orcl\udump\orcl_p001_648.trc:
ORA-00600: internal error code, arguments: [6856], [0], [8], [], [], [], [], []

Sat May 29 13:56:48 2010
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
又见到600的错误拉,天啊我的数据还没有备份啊!现在只有sys和system可以连接上数据库,却无法用其他的用户连接数据库更无法将数据库的数据导出。
   
小弟尝试将数据库冷备份后放到别的服务器上去启动后的结果是一样的。  。
将数据库的版本从9.2.0.1升级的9.2.0.8也无济于事。

救命啊,我不想成为13或14或15跳者啊



下面是trace文件的内容的部分截取
Dumping next redo log in thread 1

DUMP OF REDO FROM FILE 'E:\ORACLE\ORADATA\ORCL\REDO02.LOG'
Opcodes *.*
DBA's: (file # 2, block # 17798) thru (file # 2, block # 17798)
RBA's: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCN's scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
Times: creation thru eternity
FILE HEADER:
        Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000
        Db ID=1236070665=0x49acf109, Db Name='ORCL'
        Activation ID=1236084489=0x49ad2709
        Control Seq=6407=0x1907, File size=204800=0x32000
        File Number=2, Blksiz=512, File Type=2 LOG
descrip:"Thread 0001, Seq# 0000001593, SCN 0x0a2de998ddb0-0x0a2de9992c07"
thread: 1 nab: 0x3a seq: 0x00000639 hws: 0x6 eot: 0 dis: 0
reset logs count: 0x2a37a58a scn: 0x0000.0002e872
Low scn: 0x0a2d.e998ddb0 05/29/2010 13:45:17
Next scn: 0x0a2d.e9992c07 05/29/2010 13:47:18
Enabled scn: 0x0000.0002e872 01/14/2010 19:12:10
Thread closed scn: 0x0a2d.e9992c06 05/29/2010 13:45:20
Log format vsn: 0x8000000 Disk cksum: 0xb088 Calc cksum: 0xb088
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
Most recent redo scn: 0x0000.00000000
Largest LWN: 0 blocks
End-of-redo stream : No
Unprotected mode
Miscellaneous flags: 0x0
END OF REDO DUMP
----- Redo read statistics for thread 1 -----
Read rate (ASYNC) = 28Kb/sec => 56 blocks in 1s
Read buffer = 8192Kb (16384 blocks)
Longest record = 0Kb
Record moves = 0/68 (0%)
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

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

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

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

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

GMT+8, 2024-12-20 16:29 , Processed in 0.047830 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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