免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 5553 | 回复: 2
打印 上一主题 下一主题

ORA-01578: ORACLE 数据块损坏(文件号1,块号344) [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2008-01-29 18:25 |只看该作者 |倒序浏览
操作系统win2000  数据库oracle9i

由于突然停电系统崩溃,从装系统后从见数据库、表空间。把原来的库文件考回来。数据库依旧没起来。朋友告诉让我从建控制文件。从建完了就出现这种情况了。下面是部分日志。请大家帮忙看看怎么解决。

Tue Jan 29 17:47:23 2008
Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Instance terminated by USER, pid = 1836
ORA-1092 signalled during: alter database open...
Tue Jan 29 17:47:46 2008
Starting ORACLE instance (normal)
Starting up ORACLE RDBMS Version: 9.0.1.1.1.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  shared_pool_size         = 46137344
  large_pool_size          = 1048576
  java_pool_size           = 33554432
  control_files            = D:\oracle\oradata\orcl\CONTROL01.CTL, D:\oracle\oradata\orcl\CONTROL02.CTL, D:\oracle\oradata\orcl\CONTROL03.CTL
  db_block_size            = 4096
  db_cache_size            = 33554432
  compatible               = 9.0.0
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  instance_name            = orcl
  dispatchers              = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
  background_dump_dest     = D:\oracle\admin\orcl\bdump
  user_dump_dest           = D:\oracle\admin\orcl\udump
  core_dump_dest           = D:\oracle\admin\orcl\cdump
  sort_area_size           = 524288
  db_name                  = orcl
  open_cursors             = 300
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Tue Jan 29 17:47:48 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Jan 29 17:47:49 2008
ALTER DATABASE   MOUNT
Tue Jan 29 17:47:56 2008
Successful mount of redo thread 1, with mount id 1173056712.
Tue Jan 29 17:47:56 2008
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Tue Jan 29 17:48:00 2008
alter database open
Tue Jan 29 17:48:00 2008
Beginning crash recovery of 1 threads
Tue Jan 29 17:48:00 2008
Started first pass scan
Tue Jan 29 17:48:00 2008
Completed first pass scan
Tue Jan 29 17:48:00 2008
Started recovery at
Thread 1: logseq 683, block 2, scn 0.7776372
Recovery of Online Redo Log: Thread 1 Group 1 Seq 683 Reading mem 0
  Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Tue Jan 29 17:48:00 2008
Ended recovery at
Thread 1: logseq 683, block 65, scn 0.7796620
8 data blocks read, 8 data blocks written, 63 redo blocks read
Crash recovery completed successfully
Tue Jan 29 17:48:00 2008
Thread 1 advanced to log sequence 684
Thread 1 opened at log sequence 684
  Current log# 2 seq# 684 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1.
Tue Jan 29 17:48:00 2008
SMON: enabling cache recovery
Tue Jan 29 17:48:01 2008
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Jan 29 17:48:01 2008
SMON: enabling tx recovery
Tue Jan 29 17:48:03 2008
Errors in file D:\oracle\admin\orcl\udump\ORA00296.TRC:
ORA-00604: 递归 SQL 层 1 出现错误
ORA-01578: ORACLE 数据块损坏(文件号1,块号344)
ORA-01110: 数据文件 1: 'D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF'

Tue Jan 29 17:48:03 2008
Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Instance terminated by USER, pid = 296
ORA-1092 signalled during: alter database open...

论坛徽章:
0
2 [报告]
发表于 2008-01-30 12:46 |只看该作者
system.dbf有备份吗?能否先startup mount,然后recover datafile system.dbf,然后open

论坛徽章:
0
3 [报告]
发表于 2008-01-30 22:26 |只看该作者
没有备份,能startup mount,然后recover datafile system01.dbf 但OPEN的时候就报上面的错误了。说我的system01.dba有坏块。。。。
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP