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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-16 00:02:16 | 查看: 1564| 回复: 0
环境:oracle 10g,windows平台,非归档模式,没有备份
测试:手工删除current redo log,尝试恢复

恢复思路:修改pfile文件,加入_allow_resetlogs_corruption=true参数,在数据库不一致的情况下,强制打开数据库,做数据库的全库导出。新建数据库,再将数据导入。

问题:可以强制打开数据库,但数据库会很快宕掉,exp根本来不及完成。alert日志里有大量ora-600报错。

兄弟们有没有好的办法,给个建议


数据库既然已经强制启动,此时再去掉_allow_resetlogs_corruption还对实例有影响么?
Wed Mar 21 15:54:47 2012
DEBUG: Replaying xcb 0x1fa014cc, pmd 0x1fbc09bc for failed op 8
Doing block recovery for file 2 block 97
Block recovery from logseq 7, block 63 to scn 1606949
Wed Mar 21 15:54:47 2012
Recovery of Online Redo Log: Thread 1 Group 1 Seq 7 Reading mem 0
  Mem# 0 errs 0: F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Block recovery completed at rba 7.70.16, scn 0.1606952
Wed Mar 21 15:54:48 2012
Errors in file f:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4208.trc:
ORA-00600: internal error code, arguments: [4194], [57], [13], [], [], [], [], []

Wed Mar 21 15:54:50 2012
Errors in file f:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4208.trc:
ORA-00600: internal error code, arguments: [4194], [57], [13], [], [], [], [], []

PMON: terminating instance due to error 472
Wed Mar 21 15:54:50 2012
Errors in file f:\oracle\product\10.2.0\admin\orcl\bdump\orcl_q001_4696.trc:
ORA-00472: PMON  process terminated with error

Wed Mar 21 15:54:50 2012
Errors in file f:\oracle\product\10.2.0\admin\orcl\bdump\orcl_ctwr_216.trc:
ORA-00472: PMON  process terminated with error

Wed Mar 21 15:54:51 2012
Errors in file f:\oracle\product\10.2.0\admin\orcl\bdump\orcl_lgwr_1784.trc:
ORA-00472: PMON  process terminated with error

Wed Mar 21 15:54:52 2012
Errors in file f:\oracle\product\10.2.0\admin\orcl\bdump\orcl_psp0_6132.trc:
ORA-00472: PMON  process terminated with error

Wed Mar 21 15:54:52 2012
Errors in file f:\oracle\product\10.2.0\admin\orcl\bdump\orcl_dbw0_1792.trc:
ORA-00472: PMON  process terminated with error

Wed Mar 21 15:54:52 2012
Errors in file f:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mman_680.trc:
ORA-00472: PMON  process terminated with error

Wed Mar 21 15:54:53 2012
Errors in file f:\oracle\product\10.2.0\admin\orcl\bdump\orcl_ckpt_6064.trc:
ORA-00472: PMON  process terminated with error

Wed Mar 21 15:54:56 2012
Errors in file f:\oracle\product\10.2.0\admin\orcl\bdump\orcl_reco_4596.trc:
ORA-00472: PMON  process terminated with error

Wed Mar 21 15:54:56 2012
Errors in file f:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_4184.trc:
ORA-00472: PMON  process terminated with error

Wed Mar 21 15:54:57 2012
Instance terminated by PMON, pid = 4208

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

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

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

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

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

GMT+8, 2024-5-20 05:59 , Processed in 0.045641 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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