ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > ORA-03113 ORA-19504 ORA-17502 ORA-15041

ORA-03113 ORA-19504 ORA-17502 ORA-15041

原创 Oracle 作者：哎呀我的天呐 时间：2015-01-05 13:28:39 1 删除 编辑

数据库版本：11.2.0.1  rac

点击( 此处 )折叠或打开

  1. SQL > archive log list

  2. Database log mode            Archive Mode

  3. Automatic archival           Enabled

  4. Archive destination     + RECOVERY

  5. Oldest online log sequence 42

  6. Next log sequence to archive   43

  7. Current log sequence            43

  8. SQL > show parameter archive


  10. NAME                 TYPE      VALUE

  11. ------------------------------------ ----------- ------------------------------

  12. archive_lag_target         integer      0

  13. log_archive_config             string

  14. log_archive_dest             string

  15. log_archive_dest_1             string     location = + RECOVERY

开库过程中告警日志信息

点击( 此处 )折叠或打开

  1. Database mounted in Shared Mode ( CLUSTER_DATABASE = TRUE )

  2. Lost write protection disabled

  3. Completed : ALTER DATABASE   MOUNT

  4. Mon Jan 05 13 : 08 : 21 2015

  5. alter database open

  6. Picked broadcast on commit scheme to generate SCNs

  7. Mon Jan 05 13 : 08 : 21 2015

  8. LGWR : STARTING ARCH PROCESSES

  9. Mon Jan 05 13 : 08 : 21 2015

  10. ARC0 started with pid = 35 , OS id = 7140

  11. ARC0 : Archival started

  12. LGWR : STARTING ARCH PROCESSES COMPLETE

  13. ARC0 : STARTING ARCH PROCESSES

  14. Mon Jan 05 13 : 08 : 22 2015

  15. ARC2 started with pid = 37 , OS id = 7144

  16. Mon Jan 05 13 : 08 : 22 2015

  17. ARC1 started with pid = 36 , OS id = 7142

  18. ARC1 : Archival started

  19. ARC2 : Archival started

  20. ARC1 : Becoming the \ 'no FAL\' ARCH

  21. ARC1 : Becoming the \ 'no SRL\' ARCH

  22. ARC2 : Becoming the heartbeat ARCH

  23. Mon Jan 05 13 : 08 : 22 2015

  24. ARC3 started with pid = 38 , OS id = 7146

  25. Errors in file /u01/app/oracle/diag/rdbms/prod/prod1/trace/prod1_ora_7133 . trc :

  26. ORA - 19504 : failed to create file \ "+RECOVERY\"

  27. ORA - 17502 : ksfdcre : 4 Failed to create file + RECOVERY

  28. ORA - 15041 : diskgroup \ "RECOVERY\" space exhausted

  29. ARCH : Error 19504 Creating archive log file to \ '+RECOVERY\'

  30. Errors in file /u01/app/oracle/diag/rdbms/prod/prod1/trace/prod1_ora_7133 . trc :

  31. ORA - 16038 : log 2 sequence# 56 cannot be archived

  32. ORA - 19504 : failed to create file \ "\"

  33. ORA - 00312 : online log 2 thread 1 : \ '+DATA_GROUP/prod/onlinelog/group_2.262.861981267\'

  34. ORA - 00312 : online log 2 thread 1 : \ '+RECOVERY/prod/onlinelog/group_2.258.861981273\'

  35. USER ( ospid : 7133 ) : terminating the instance due to error 16038

  36. Mon Jan 05 13 : 08 : 23 2015

  37. System state dump is made for local instance

  38. System State dumped to trace file /u01/app/oracle/diag/rdbms/prod/prod1/trace/prod1_diag_7003 . trc

  39. Trace dumping is performing id = [ cdmp_20150105130823 ]

  40. Instance terminated by USER , pid = 7133


查看trace

点击( 此处 )折叠或打开

  1. [ oracle @ node1 trace ] $ cat / u01 / app / oracle / diag / rdbms / prod / prod1 / trace / prod1_ora_7133 . trc

  2. Trace file / u01 / app / oracle / diag / rdbms / prod / prod1 / trace / prod1_ora_7133 . trc

  3. Oracle Database 11g Enterprise Edition Release 11 . 2 . . 1 . 0 - Production

  4. With the Partitioning , Real Application Clusters , Automatic Storage Management , OLAP ,

  5. Data Mining and Real Application Testing options

  6. ORACLE_HOME = / u01 / app / oracle / product / 11 . 2 . / db_1

  7. System name :     Linux

  8. Node name :     node1

  9. Release :     2 . 6 . 18 - 194 . el5

  10. Version :     #1 SMP Tue Mar 16 21 : 52 : 43 EDT 2010

  11. Machine :     i686

  12. Instance name : prod1

  13. Redo thread mounted by this instance : 1

  14. Oracle process number : 31

  15. Unix process pid : 7133 , image : oracle @ node1 ( TNS V1 - V3 )



  18. * * * 2015 - 01 - 05 13 : 08 : 23 . 360

  19. * * * SESSION ID : ( 1 . 5 ) 2015 - 01 - 05 13 : 08 : 23 . 360

  20. * * * CLIENT ID : ( ) 2015 - 01 - 05 13 : 08 : 23 . 360

  21. * * * SERVICE NAME : ( ) 2015 - 01 - 05 13 : 08 : 23 . 360

  22. * * * MODULE NAME : ( sqlplus @ node1 ( TNS V1 - V3 ) ) 2015 - 01 - 05 13 : 08 : 23 . 360

  23. * * * ACTION NAME : ( ) 2015 - 01 - 05 13 : 08 : 23 . 360

  24.  

  25. DDE rules only execution for : ORA 15041

  26. ----- START Event Driven Actions Dump ----

  27. ---- END Event Driven Actions Dump ----

  28. ----- START DDE Actions Dump -----

  29. Executing SYNC actions

  30. Executing ASYNC actions

  31. ----- END DDE Actions Dump (total 0 csec) -----

  32. Failed to create file \ '+RECOVERY\' ( file not accessible ? )

  33. ORA - 19504 : failed to create file \ "+RECOVERY\"

  34. ORA - 17502 : ksfdcre : 4 Failed to create file + RECOVERY

  35. ORA - 15041 : diskgroup \ "RECOVERY\" space exhausted

  36. * * * 2015 - 01 - 05 13 : 08 : 23 . 362 4132 krsh . c

  37. ARCH : Error 19504 Creating archive log file to \ '+RECOVERY\'

  38. * * * 2015 - 01 - 05 13 : 08 : 23 . 362 2747 krsi . c

  39. krsi_dst_fail : dest : 1 err : 19504 force : 0 blast : 1

  40. DDE rules only execution for : ORA 312

  41. ----- START Event Driven Actions Dump ----

  42. ---- END Event Driven Actions Dump ----

  43. ----- START DDE Actions Dump -----

  44. Executing SYNC actions

  45. ----- START DDE Action: \'DB_STRUCTURE_INTEGRITY_CHECK\' (Async) -----

  46. Successfully dispatched

  47. ----- END DDE Action: \'DB_STRUCTURE_INTEGRITY_CHECK\' (SUCCESS, 0 csec) -----

  48. Executing ASYNC actions

  49. ----- END DDE Actions Dump (total 0 csec) -----

  50. DDE : Problem Key \ 'ORA 312\' was flood controlled ( 0x1 ) ( no incident )

  51. ORA - 00312 : online log 2 thread 1 : \ '+DATA_GROUP/prod/onlinelog/group_2.262.861981267\'

  52. ORA - 00312 : online log 2 thread 1 : \ '+RECOVERY/prod/onlinelog/group_2.258.861981273\'

  53. ORA - 16038 : log 2 sequence # 56 cannot be archived

  54. ORA - 19504 : failed to create file \ "\"

  55. ORA - 00312 : online log 2 thread 1 : \ '+DATA_GROUP/prod/onlinelog/group_2.262.861981267\'

  56. ORA - 00312 : online log 2 thread 1 : \ '+RECOVERY/prod/onlinelog/group_2.258.861981273\'


  58. * * * 2015 - 01 - 05 13 : 08 : 23 . 374

  59. USER ( ospid : 7133 ) : terminating the instance due to error 16038

  60. ksuitm : waiting up to [ 5 ] seconds before killing DIAG ( 7003 )

查看ASM磁盘组发现 归档满了

来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29990276/viewspace-1390577/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： RMAN-06059 ORA-19625 ORA-27037
下一篇： Oracle优化案例-systemstate dump介绍（三十五）
请登录后发表评论 登录
全部评论
哎呀我的天呐
专家姓名：姚崇
https://cloud.tencent.com/developer/inventory/14362

注册时间：2014-10-30

  • 博文量
    403
  • 访问量
    2528714

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593