Chinaunix首页 | 论坛 | 博客
  • 博客访问: 3693329
  • 博文数量: 715
  • 博客积分: 1860
  • 博客等级: 上尉
  • 技术积分: 7745
  • 用 户 组: 普通用户
  • 注册时间: 2008-04-07 08:51
个人简介

偶尔有空上来看看

文章分类

全部博文(715)

文章存档

2023年(75)

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-11-13 08:43:26

19c数据库正在运行中,如果从操作系统层面rm掉一个数据文件,则实例宕机

  1. ARC2 (PID:2324): Archived Log entry 5 added for T-1.S-18 ID 0x605479f8 LAD:1
  2. 2021-11-12 12:20:39.524000 -08:00
  3. Thread 1 cannot allocate new log, sequence 20
  4. Checkpoint not complete
  5.   Current log# 1 seq# 19 mem# 0: /u01/app/oracle/oradata/ORCL/redo01.log
  6. 2021-11-12 12:20:41.988000 -08:00
  7. Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ckpt_2266.trc:
  8. ORA-63999: data file suffered media failure
  9. ORA-01116: error in opening database file 7
  10. ORA-01110: data file 7: '/u01/app/oracle/oradata/ORCL/users01.dbf'
  11. ORA-27041: unable to open file
  12. Linux-x86_64 Error: 2: No such file or directory
  13. Additional information: 3
  14. Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ckpt_2266.trc:
  15. ORA-63999: data file suffered media failure
  16. ORA-01116: error in opening database file 7
  17. ORA-01110: data file 7: '/u01/app/oracle/oradata/ORCL/users01.dbf'
  18. ORA-27041: unable to open file
  19. Linux-x86_64 Error: 2: No such file or directory
  20. Additional information: 3
  21. Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ckpt_2266.trc (incident=16961):
  22. ORA-63999 [] [] [] [] [] [] [] [] [] [] [] []
  23. Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_16961/orcl_ckpt_2266_i16961.trc
  24. Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_mz00_2781.trc:
  25. ORA-01110: data file 7: '/u01/app/oracle/oradata/ORCL/users01.dbf'
  26. ORA-01565: error in identifying file '/u01/app/oracle/oradata/ORCL/users01.dbf'
  27. ORA-27037: unable to obtain file status
  28. Linux-x86_64 Error: 2: No such file or directory
  29. Additional information: 7
  30. 2021-11-12 12:20:43.451000 -08:00
  31. USER (ospid: 2266): terminating the instance due to ORA error 63999
  32. System state dump requested by (instance=1, osid=2266 (CKPT)), summary=[abnormal instance termination].
  33. System State dumped to trace file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_diag_2239.trc
  34. Dumping diagnostic data in directory=[cdmp_20211112122043], requested by (instance=1, osid=2266 (CKPT)), summary=[abnormal instance termination].
  35. 2021-11-12 12:20:45.541000 -08:00
  36. Instance terminated by USER, pid = 2266

这太不健壮了,所以还是让数据库容错能力恢复到原先吧

  1. alter system set "_datafile_write_errors_crash_instance"=false;
这样的话,如果有个别文件出现问题,只在告警日志中报错,不至于整个数据库无法访问。
所有生产库都应该这样设置。
阅读(920) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~