- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-15 23:52:21
|
查看: 1578 |
回复: 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
|
|