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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-15 23:52:21 | 查看: 1311| 回复: 0


遇到一數據庫:
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.

錯誤信息如下、請大牛們幫忙看看,【沒有備份】是否還有救!

Tue Feb 21 11:18:44 2012
Thread 1 advanced to log sequence 456658
  Current log# 1 seq# 456658 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Tue Feb 21 11:19:20 2012
Errors in file D:\Oracle\admin\ORCL\bdump\orclCKPT.TRC:
ORA-01110: data file 27: 'D:\ORACLE\ORADATA\ORCL\EXAM_IMAGE2009_1.ORA'
ORA-01114: IO error writing block to file 27 (block # 1)
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile()
O/S-Error: (OS 5)
Tue Feb 21 11:19:21 2012
Thread 1 advanced to log sequence 456659
  Current log# 2 seq# 456659 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Tue Feb 21 11:20:09 2012
Thread 1 advanced to log sequence 456660
  Current log# 3 seq# 456660 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Tue Feb 21 11:20:12 2012
CKPT: terminating instance due to error 1242
Tue Feb 21 11:20:14 2012
Errors in file D:\Oracle\admin\ORCL\udump\ORA46664.TRC:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode


In ARCHIVELOG mode, the database records an error in the database writer trace file and takes the affected datafile offline. (All other datafiles in the tablespace containing this datafile remain online.) You can then rectify the underlying problem and restore and recover the affected tablespace.

In NOARCHIVELOG mode, the database writer background process DBWR fails, and the instance fails, the cause of the problem determines the required response. If the problem is temporary (for example, a disk controller was powered off), then crash recovery usually can be performed using the online redo log files. In such situations, the instance can be restarted without resorting to media recovery. However, if a datafile is damaged, then you must restore a consistent backup of the entire database.

當前數據文件為offline狀態,并且archivelog切換次數遠大于redolog的組數,有沒有方法減少數據丟失;【沒有備份】


‘MOUNT模式下将损坏的数据文件下线’是alter database datafile xx offline drop;嗎?
這樣操作的話、查詢該表空間的表數據出現:ORA-00376   ORA-01110
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

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

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

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

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

GMT+8, 2024-5-17 18:46 , Processed in 0.044793 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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