oracle取去年年末,年终难终 - 记年底前的几则数据恢复案例

年终难终 - 记年底前的几则数据恢复案例

1.SYSTEM表空间损坏

类似的案例本站之前描述过：

Mon Dec 19 12:00:16 2011

ALTER DATABASE OPEN

Mon Dec 19 12:00:16 2011

Beginning crash recovery of 1 threads

Mon Dec 19 12:00:16 2011

Started first pass scan

Mon Dec 19 12:00:17 2011

Completed first pass scan

3953 redo blocks read, 365 data blocks need recovery

Mon Dec 19 12:00:17 2011

Started recovery at

Thread 1: logseq 2866, block 2, scn 0.288668733

Recovery of Online Redo Log: Thread 1 Group 3 Seq 2866 Reading mem 0

Mem# 0 errs 0: D:\ORACLE\ORADATA\TH\REDO03.LOG

RECOVERY OF THREAD 1 STUCK AT BLOCK 9 OF FILE 1

ORA-1172 signalled during: ALTER DATABASE OPEN...

Sat Dec 24 10:05:35 2011

alter database open

Sat Dec 24 10:05:35 2011

Beginning crash recovery of 1 threads

Sat Dec 24 10:05:35 2011

Started first pass scan

Sat Dec 24 10:05:36 2011

Completed first pass scan

3953 redo blocks read, 365 data blocks need recovery

Sat Dec 24 10:05:36 2011

Started recovery at

Thread 1: logseq 2866, block 2, scn 0.288668733

Recovery of Online Redo Log: Thread 1 Group 3 Seq 2866 Reading mem 0

Mem# 0 errs 0: D:\ORACLE\ORADATA\TH\REDO03.LOG

RECOVERY OF THREAD 1 STUCK AT BLOCK 9 OF FILE 1

ORA-1172 signalled during: alter database open...

Sat Dec 24 10:05:59 2011

ALTER DATABASE RECOVER  datafile 1

Sat Dec 24 10:05:59 2011

Media Recovery Datafile: 1

Media Recovery Start

Starting datafile 1 recovery in thread 1 sequence 2866

Datafile 1: 'D:\ORACLE\ORADATA\TH\SYSTEM01.DBF'

Media Recovery Log

Recovery of Online Redo Log: Thread 1 Group 3 Seq 2866 Reading mem 0

Mem# 0 errs 0: D:\ORACLE\ORADATA\TH\REDO03.LOG

Sat Dec 24 10:06:08 2011

Errors in file d:\oracle\admin\th\udump\th_ora_3672.trc:

ORA-00600: 内部错误代码，参数: [3020], [4194313], [1], [2866], [3], [16], [], []

ORA-10567: Redo is inconsistent with data block (file# 1, block# 9)

ORA-10564: tablespace SYSTEM

ORA-01110: 数据文件 1: 'D:\ORACLE\ORADATA\TH\SYSTEM01.DBF'

ORA-10560: block type 'KTU UNDO HEADER W/UNLIMITED EXTENTS'

Errors with log .

Media Recovery failed with error 600

ORA-283 signalled during: ALTER DATABASE RECOVER  datafile 1  ...2.SYSTEM表空间恢复

数据库不能启动，信息不多：

oracle 9206,windows 2003 SP2

电压不稳,电脑突然断电后,ORACLE数据库无法加载

ORA-03113: end-of-file on communication channel

ORA-01113: file 1 needs media recovery为了数据安全，再多一份的备份也值得，请大家注意数据安全。

By eygle on 2011-12-25 21:27 |

Comments (0) |

Backup&Recovery | 2938 |