- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-13 19:37:43
|
查看: 2358 |
回复: 0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 87 Reading mem 0
Mem# 0 errs 0: /u01/product/oradata/wind/redo01.log
Mem# 1 errs 0: /data3/wind/redo01b.log
Doing block recovery for fno: 2 blk: 61
Wed Sep 26 18:00:01 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 87 Reading mem 0
Mem# 0 errs 0: /u01/product/oradata/wind/redo01.log
Mem# 1 errs 0: /data3/wind/redo01b.log
Wed Sep 26 18:00:01 2007
Errors in file /u01/product/admin/wind/bdump/wind_smon_1722.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [14], [2], [], [], [], [], []
Wed Sep 26 18:00:02 2007
ORA-607 signalled during: ALTER DATABASE OPEN...
Doing block recovery for fno: 46 blk: 824
Wed Sep 26 18:00:02 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 87 Reading mem 0
Mem# 0 errs 0: /u01/product/oradata/wind/redo01.log
Mem# 1 errs 0: /data3/wind/redo01b.log
Doing block recovery for fno: 2 blk: 45
Wed Sep 26 18:00:02 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 87 Reading mem 0
Mem# 0 errs 0: /u01/product/oradata/wind/redo01.log
SMON: enabling cache recovery
Wed Sep 26 18:09:34 2007
Successfully onlined Undo Tablespace 1.
Wed Sep 26 18:09:34 2007
SMON: enabling tx recovery
Wed Sep 26 18:09:34 2007
Database Characterset is UTF8
replication_dependency_tracking turned off (no async multimaster replication fou
nd)
Wed Sep 26 18:09:35 2007
Errors in file /u01/product/admin/wind/udump/wind_ora_1782.trc:
ORA-00600: internal error code, arguments: [4194], [51], [39], [], [], [], [], [
]
ORA-607 signalled during: alter database open ...
Doing block recovery for fno: 37 blk: 40
Wed Sep 26 18:09:36 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 87 Reading mem 0
Mem# 0 errs 0: /u01/product/oradata/wind/redo01.log
Mem# 1 errs 0: /data3/wind/redo01b.log
Doing block recovery for fno: 2 blk: 21
Wed Sep 26 18:09:36 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 87 Reading mem 0
Mem# 0 errs 0: /u01/product/oradata/wind/redo01.log
Mem# 1 errs 0: /data3/wind/redo01b.log
SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [51], [39], [], [], [], [],
[]
Oracle 9.2.0.7
Linux AS3.0
测试用数据库,正在数据写入的时候RAID发生问题,系统重新开机后,UNDO的一个数据文件file#=37 的第40个数据块发生问题,由于测试库 没有备份,晕,似乎没有其他方式恢复了 ? |
|