offline的数据文件如何修复-凯发app官方网站

凯发app官方网站-凯发k8官网下载客户端中心 | | 凯发app官方网站-凯发k8官网下载客户端中心
  • 博客访问: 3502711
  • 博文数量: 718
  • 博客积分: 1860
  • 博客等级: 上尉
  • 技术积分: 7790
  • 用 户 组: 普通用户
  • 注册时间: 2008-04-07 08:51
个人简介

偶尔有空上来看看

文章分类

全部博文(718)

文章存档

2024年(4)

2023年(74)

2022年(134)

2021年(238)

2020年(115)

2019年(11)

2018年(9)

2017年(9)

2016年(17)

2015年(7)

2014年(4)

2013年(1)

2012年(11)

2011年(27)

2010年(35)

2009年(11)

2008年(11)

最近访客
相关博文
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·

分类: oracle

2021-04-12 16:14:17


aix平台 单机 10.2.0.4 突然实例宕机

alert.log 中记录

  1. mon apr 12 13:25:58 2021
  2. thread 1 advanced to log sequence 140477 (lgwr switch)
  3.   current log# 9 seq# 140477 mem# 0: /oradata/orcl/redo09.log
  4. mon apr 12 13:26:38 2021
  5. kcf: write/open error block=0x6706 online=1
  6.      file=38 /oradata/orcl/tsdat02_08.dbf
  7.      error=27063 txt: 'ibm aix risc system/6000 error: 16: device busy
  8. additional information: -1
  9. additional information: 8192'
  10. automatic datafile offline due to write error on
  11. file 38: /oradata/orcl/tsdat02_08.dbf
  12. mon apr 12 13:26:43 2021
  13. errors in file /home/oracle/admin/orcl/udump/orcl_ora_14155964.trc:
  14. ora-00376: file 38 cannot be read at this time
  15. ora-01110: data file 38: '/oradata/orcl/tsdat02_08.dbf'
  16. ora-00376: file 38 cannot be read at this time
  17. ora-01110: data file 38: '/oradata/orcl/tsdat02_08.dbf'
  18. mon apr 12 13:26:49 2021
  19. errors in file /home/oracle/admin/orcl/bdump/orcl_pmon_34537506.trc:
  20. ora-00376: file 38 cannot be read at this time
  21. ora-01110: data file 38: '/oradata/orcl/tsdat02_08.dbf'
  22. mon apr 12 13:42:08 2021
  23. errors in file /home/oracle/admin/orcl/bdump/orcl_lgwr_53149820.trc:
  24. ora-00494: enqueue [cf] held for too long (more than 900 seconds) by 'inst 1, osid 36307002'
  25. mon apr 12 13:42:09 2021
  26. system state dumped to trace file /home/oracle/admin/orcl/bdump/orcl_lgwr_53149820.trc
  27. killing enqueue blocker (pid=36307002) on resource cf-00000000-00000000
  28.  by killing session 552.1
  29. mon apr 12 13:47:11 2021
  30. errors in file /home/oracle/admin/orcl/bdump/orcl_lgwr_53149820.trc:
  31. ora-00494: enqueue [cf] held for too long (more than 900 seconds) by 'inst 1, osid 36307002'
  32. mon apr 12 13:47:12 2021
  33. system state dumped to trace file /home/oracle/admin/orcl/bdump/orcl_lgwr_53149820.trc
  34. killing enqueue blocker (pid=36307002) on resource cf-00000000-00000000
  35.  by terminating the process
  36. lgwr: terminating instance due to error 2103
  37. instance terminated by lgwr, pid = 53149820
看到读写38号文件时 提示error=27063 txt: 'ibm aix risc system/6000 error: 16: device busy

查看os日志

  1. [ oracle ]host1:/home/oracle/admin/orcl/bdump:errpt|head
  2. identifier timestamp t c resource_name description
  3. dcb47997 0412142821 t h hdisk112 disk operation error
  4. dcb47997 0412142821 t h hdisk119 disk operation error
  5. b6267342 0412142821 p h hdisk119 disk operation error
  6. b6267342 0412142821 p h hdisk140 disk operation error
  7. b6267342 0412142821 p h hdisk119 disk operation error
  8. b6267342 0412142821 p h hdisk112 disk operation error
  9. dcb47997 0412142721 t h hdisk112 disk operation error
  10. dcb47997 0412142721 t h hdisk112 disk operation error
  11. b6267342 0412142721 p h hdisk119 disk operation error

[ oracle ]host1:/home/oracle/admin/orcl/bdump:errpt -aj dcb47997|more
---------------------------------------------------------------------------
label:          sc_disk_err4
identifier:     dcb47997


date/time:       mon apr 12 14:28:34 gmt 08:00 2021
sequence number: 847721
machine id:      00f710984c00
node id:         host1
class:           h
type:            temp
wpar:            global
resource name:   hdisk112        
resource class:  disk
resource type:   clar_fc_vraid
location:        u5802.001.9k8n405-p1-c2-t2-w500601690960398d-l3000000000000


vpd:             
        manufacturer................dgc     
        machine type and model......vraid           
        ros level and id............0533
        serial number...............cetv2173400018
        subsystem vendor/device id..vnx5600        
        device specific.(pq)........00
        device specific.(vs)........255f081ceccl
        device specific.(ui)........600601600a804500571d3d8381c2ea11
        fru label...................0025
        device specific.(z0)........10
        device specific.(z1)........10


description
disk operation error


probable causes
media
dasd device


user causes
media defective


        recommended actions
        for removable media, change media and retry
        perform problem determination procedures


failure causes
media
disk drive


        recommended actions
        for removable media, change media and retry
        perform problem determination procedures


detail data
path id
           0
sense data
0a00 2800 2117 0920 0004 0004 0000 0000 0000 0000 0000 0000 0118 0000 0000 0000 
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 
0000 0000 0000 034a 045c 0007 8000 0000 0000 0000 0000 0000 0000 0000 0083 0000 
0000 003d 001d 
---------------------------------------------------------------------------


据说是磁盘坏道或者链路闪断导致。

先处理故障,直接启动实例
startup 耗时20分钟终于起来了
实例启动后,38号文件一直报错

  1. mon apr 12 14:22:33 2021
  2. errors in file /home/oracle/admin/orcl/bdump/orcl_smon_34537570.trc:
  3. ora-00376: file 38 cannot be read at this time
  4. ora-01110: data file 38: '/oradata/orcl/tsdat02_08.dbf'
  5. oracle instance orcl (pid = 9) - error 376 encountered while recovering transaction (30, 43) on object 1192947.
  6. mon apr 12 14:22:34 2021
  7. errors in file /home/oracle/admin/orcl/bdump/orcl_smon_34537570.trc:
  8. ora-00376: file 38 cannot be read at this time
  9. ora-01110: data file 38: '/oradata/orcl/tsdat02_08.dbf'
  10. oracle instance orcl (pid = 9) - error 376 encountered while recovering transaction (30, 43) on object 1192947.
  11. mon apr 12 14:22:35 2021
  12. errors in file /home/oracle/admin/orcl/bdump/orcl_smon_34537570.trc:
  13. ora-00376: file 38 cannot be read at this time
  14. ora-01110: data file 38: '/oradata/orcl/tsdat02_08.dbf'
检查38号数据文件
 select file#,status,bytes/1024/1024,name from v$datafile;

  1. ...
  2. 37 online 30720 /oradata/orcl/tsdat03_12.dbf
  3. 38 recover 30720 /oradata/orcl/tsdat02_08.dbf
  4. 39 online 30720/oradata/orcl/tsdat03_13.dbf
  5. ...

归档模式,问题发现的比较及时,赶紧修复
recover datafile 38;
alter database datafile 38 online;
很快顺利修复,又躲过一劫。

参考:
how to recover offline dropped datafile in archivelog mode (doc id 286355.1)
阅读(1143) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~
")); function link(t){ var href= $(t).attr('href'); href ="?url=" encodeuricomponent(location.href); $(t).attr('href',href); //setcookie("returnouturl", location.href, 60, "/"); }
网站地图