ORA-00742 ora-00600 [4193] [4194] [kdsgrp1] [13011]

于 2021-01-25 19:45:20 发布
阅读量691 收藏
点赞数
分类专栏： oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/jycjyc/article/details/113135019
版权

存储故障导致问题：

Additional information: 3
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_q001_122961.trc  (incident=19370):
ORA-00600: internal error code, arguments: [4193], [pp/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbff
Incident details in: /oracle/app/oracle/diag/rdbms/dbtest/dbtest/incident/incdir_19370/dbtest_q001_122961_i19370.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Dumping diagnostic data in directory=[cdmp_20210125192405], requested by (instance=1, osid=122961 (Q001)), summary=[incident=19369].
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_mmon_111831.trc:
ORA-00308: cannot open archived log '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_mmon_111831.trc:
ORA-00308: cannot open archived log '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_ora_111939.trc  (incident=19345):
ORA-00600: internal error code, arguments: [4194], [ody "SYS.DBMS_STANDARD"
Incident details in: /oracle/app/oracle/diag/rdbms/dbtest/dbtest/incident/incdir_19345/dbtest_ora_111939_i19345.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 1, block 60 to scn 15898926594263
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
  Mem# 0: /oradata/dbtest/redo01_01.log
Block recovery completed at rba 1.64.16, scn 3701.3252631768
Block recovery from logseq 1, block 60 to scn 15898926594257
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
  Mem# 0: /oradata/dbtest/redo01_01.log
Block recovery completed at rba 1.62.16, scn 3701.3252631765
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_mmon_111831.trc  (incident=19330):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/dbtest/dbtest/incident/incdir_19330/dbtest_mmon_111831_i19330.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/incident/incdir_19370/dbtest_q001_122961_i19370.trc:
ORA-00308: cannot open archived log '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
ORA-00600: internal error code, arguments: [4193], [pp/oracle/proE
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_q001_122961.trc:
ORA-00308: cannot open archived log '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00600: internal error code, arguments: [4193], [pp/oracle/proE
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_q001_122961.trc  (incident=19371):
ORA-25319: Queue table repartitioning aborted
Incident details in: /oracle/app/oracle/diag/rdbms/dbtest/dbtest/incident/incdir_19371/dbtest_q001_122961_i19371.trc
Dumping diagnostic data in directory=[cdmp_20210125192406], requested by (instance=1, osid=122961 (Q001)), summary=[incident=19370].
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_mmon_111831.trc:
ORA-00308: cannot open archived log '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
error 25319 happened during Queue table repartitioning
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_ora_111939.trc:
ORA-00308: cannot open archived log '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00600: internal error code, arguments: [4194], [ody "SYS.DBMSE
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_mmon_111831.trc:
ORA-00308: cannot open archived log '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Block recovery from logseq 1, block 64 to scn 15898926594270
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
  Mem# 0: /oradata/dbtest/redo01_01.log
Block recovery stopped at EOT rba 1.66.16
Block recovery completed at rba 1.66.16, scn 3701.3252631771
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_ora_111939.trc:
ORA-00308: cannot open archived log '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00600: internal error code, arguments: [4194], [ody "SYS.DBMSE
Block recovery from logseq 1, block 63 to scn 15898926594271
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
  Mem# 0: /oradata/dbtest/redo01_01.log
Block recovery stopped at EOT rba 1.66.16
Block recovery completed at rba 1.66.16, scn 3701.3252631771
Block recovery from logseq 1, block 64 to scn 15898926594266
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
  Mem# 0: /oradata/dbtest/redo01_01.log
Block recovery completed at rba 1.66.16, scn 3701.3252631771
Block recovery from logseq 1, block 63 to scn 15898926594263
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
  Mem# 0: /oradata/dbtest/redo01_01.log
Block recovery completed at rba 1.64.16, scn 3701.3252631770
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xD591F70] [PC:0x9833C72, kgegpa()+40] [flags: 0x0, count: 1]
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xD591F70] [PC:0x98326E6, kgebse()+776] [flags: 0x2, count: 2]
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xD591F70] [PC:0x98326E6, kgebse()+776] [flags: 0x2, count: 2]
Dumping diagnostic data in directory=[cdmp_20210125192407], requested by (instance=1, osid=111831 (MMON)), summary=[incident=19330].
Mon Jan 25 19:24:09 2021
Block recovery from logseq 1, block 59 to scn 15898926594255
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
  Mem# 0: /oradata/dbtest/redo01_01.log
Block recovery completed at rba 1.60.16, scn 3701.3252631761
Block recovery from logseq 1, block 59 to scn 15898926594272
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
  Mem# 0: /oradata/dbtest/redo01_01.log
Block recovery completed at rba 1.67.16, scn 3701.3252631777


------

Mon Jan 25 19:31:08 2021
PMON started with pid=2, OS id=2957 
Mon Jan 25 19:31:08 2021
PSP0 started with pid=3, OS id=2959 
Mon Jan 25 19:31:09 2021
VKTM started with pid=4, OS id=2977 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Mon Jan 25 19:31:09 2021
GEN0 started with pid=5, OS id=2981 
Mon Jan 25 19:31:09 2021
DIAG started with pid=6, OS id=2984 
Mon Jan 25 19:31:09 2021
DBRM started with pid=7, OS id=2989 
Mon Jan 25 19:31:09 2021
DIA0 started with pid=8, OS id=2991 
Mon Jan 25 19:31:09 2021
MMAN started with pid=9, OS id=2993 
Mon Jan 25 19:31:09 2021
DBW0 started with pid=10, OS id=2995 
Mon Jan 25 19:31:09 2021
DBW1 started with pid=11, OS id=2997 
Mon Jan 25 19:31:09 2021
LGWR started with pid=12, OS id=2999 
Mon Jan 25 19:31:09 2021
CKPT started with pid=13, OS id=3001 
Mon Jan 25 19:31:09 2021
SMON started with pid=14, OS id=3003 
Mon Jan 25 19:31:09 2021
RECO started with pid=15, OS id=3005 
Mon Jan 25 19:31:09 2021
MMON started with pid=16, OS id=3007 
Mon Jan 25 19:31:09 2021
MMNL started with pid=17, OS id=3009 
ORACLE_BASE from environment = /oracle/app/oracle
Mon Jan 25 19:31:09 2021
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 3007630333
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Jan 25 19:31:13 2021
ALTER DATABASE OPEN
Thread 1 opened at log sequence 2
  Current log# 2 seq# 2 mem# 0: /oradata/dbtest/redo01_02.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
[3093] Successfully onlined Undo Tablespace 4.
Undo initialization finished serial:0 start:32696704 end:32696774 diff:70 (0 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Mon Jan 25 19:31:14 2021
QMNC started with pid=19, OS id=3113 
Completed: ALTER DATABASE OPEN
Starting background process CJQ0
Mon Jan 25 19:31:14 2021
CJQ0 started with pid=23, OS id=3133 
Mon Jan 25 19:31:17 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_3171.trc:
Mon Jan 25 19:31:18 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j005_3173.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j005_3173.trc  (incident=24230):
ORA-00600: 内部错误代码, 参数: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/dbtest/dbtest/incident/incdir_24230/dbtest_j005_3173_i24230.trc
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_3171.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Mon Jan 25 19:31:18 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j001_3165.trc:
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_3171.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_3171.trc:
ORA-12012: 自动执行作业 241 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Mon Jan 25 19:31:19 2021
Dumping diagnostic data in directory=[cdmp_20210125193119], requested by (instance=1, osid=3171 (J004)), summary=[abnormal process termination].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j005_3173.trc:
ORA-00600: 内部错误代码, 参数: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: 在 "testuser.CHANGE_TR_SDH_NE", line 51
ORA-04088: 触发器 'testuser.CHANGE_TR_SDH_NE' 执行过程中出错
ORA-06512: 在 "testuser.UPDATESDHNEROOMID", line 6
ORA-06512: 在 line 1
Mon Jan 25 19:31:19 2021
Sweep [inc][24230]: completed
Sweep [inc2][24230]: completed
Mon Jan 25 19:31:19 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j003_3169.trc:
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j001_3165.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j001_3165.trc:
ORA-12012: 自动执行作业 443069 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Dumping diagnostic data in directory=[cdmp_20210125193120], requested by (instance=1, osid=3173 (J005)), summary=[incident=24230].
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_3171.trc:
ORA-12012: 自动执行作业 241 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j003_3169.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j003_3169.trc:
ORA-12012: 自动执行作业 215979 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Dumping diagnostic data in directory=[cdmp_20210125193121], requested by (instance=1, osid=3169 (J003)), summary=[abnormal process termination].
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_3171.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-12012: 自动执行作业 241 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j003_3169.trc:
ORA-12012: 自动执行作业 215979 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_3171.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-12012: 自动执行作业 241 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_3171.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
ORA-12012: 自动执行作业 241 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Dumping diagnostic data in directory=[cdmp_20210125193122], requested by (instance=1, osid=3171 (J004)), summary=[abnormal process termination].
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j003_3169.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-12012: 自动执行作业 215979 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j001_3165.trc:
ORA-12012: 自动执行作业 443069 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j003_3169.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-12012: 自动执行作业 215979 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j003_3169.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
ORA-12012: 自动执行作业 215979 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j001_3165.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-12012: 自动执行作业 443069 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j001_3165.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-12012: 自动执行作业 443069 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j001_3165.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
ORA-12012: 自动执行作业 443069 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Dumping diagnostic data in directory=[cdmp_20210125193124], requested by (instance=1, osid=3165 (J001)), summary=[abnormal process termination].
Mon Jan 25 19:31:52 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j000_3163.trc:
ORA-12012: 自动执行作业 390351 出错
ORA-00001: 违反唯一约束条件 (testuser.IDX_JRAGE_ID)
ORA-06512: 在 "testuser.INSERT_VILLAGE_INFO", line 6
ORA-06512: 在 line 1
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j000_3163.trc:
ORA-12012: 自动执行作业 390351 出错
ORA-00001: 违反唯一约束条件 (testuser.IDX_JRAGE_ID)
ORA-06512: 在 "testuser.INSERT_VILLAGE_INFO", line 6
ORA-06512: 在 line 1
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j000_3163.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-12012: 自动执行作业 390351 出错
ORA-00001: 违反唯一约束条件 (testuser.IDX_JRAGE_ID)
ORA-06512: 在 "testuser.INSERT_VILLAGE_INFO", line 6
ORA-06512: 在 line 1
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j000_3163.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-12012: 自动执行作业 390351 出错
ORA-00001: 违反唯一约束条件 (testuser.IDX_JRAGE_ID)
ORA-06512: 在 "testuser.INSERT_VILLAGE_INFO", line 6
ORA-06512: 在 line 1
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j000_3163.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
ORA-12012: 自动执行作业 390351 出错
ORA-00001: 违反唯一约束条件 (testuser.IDX_JRAGE_ID)
ORA-06512: 在 "testuser.INSERT_VILLAGE_INFO", line 6
ORA-06512: 在 line 1
Mon Jan 25 19:31:59 2021
Starting background process SMCO
Mon Jan 25 19:31:59 2021
SMCO started with pid=31, OS id=4121 
Mon Jan 25 19:32:09 2021
Thread 1 cannot allocate new log, sequence 3
Private strand flush not complete
  Current log# 2 seq# 2 mem# 0: /oradata/dbtest/redo01_02.log
Thread 1 advanced to log sequence 3 (LGWR switch)
  Current log# 3 seq# 3 mem# 0: /oradata/dbtest/redo01_03.log
[oracle@gddbtest trace]$ tail -f alert_dbtest.log
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j002_3167.trc:
ORA-00600: 内部错误代码, 参数: [13011], [116253], [47737944], [0], [47737944], [17], [], [], [], [], [], []
ORA-06512: 在 "testuser.SZW_TJ_FTTHWEEK", line 383
ORA-06512: 在 line 1
Mon Jan 25 19:33:25 2021
Dumping diagnostic data in directory=[cdmp_20210125193325], requested by (instance=1, osid=3167 (J002)), summary=[incident=24206].
Mon Jan 25 19:34:12 2021
Sweep [inc][24206]: completed
Sweep [inc2][24206]: completed
Mon Jan 25 19:34:51 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j007_7793.trc:
Mon Jan 25 19:34:52 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_7789.trc:
Mon Jan 25 19:34:52 2021
Dumping diagnostic data in directory=[cdmp_20210125193452], requested by (instance=1, osid=7793 (J007)), summary=[abnormal process termination].
Mon Jan 25 19:34:53 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j005_7791.trc:
Dumping diagnostic data in directory=[cdmp_20210125193453], requested by (instance=1, osid=7789 (J004)), summary=[abnormal process termination].
Mon Jan 25 19:34:54 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j000_7783.trc:
ORA-12012: 自动执行作业 390351 出错
ORA-00001: 违反唯一约束条件 (testuser.IDX_JRAGE_ID)
ORA-06512: 在 "testuser.INSERT_VILLAGE_INFO", line 6
ORA-06512: 在 line 1
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j000_7783.trc:
ORA-12012: 自动执行作业 390351 出错
ORA-00001: 违反唯一约束条件 (testuser.IDX_JRAGE_ID)
ORA-06512: 在 "testuser.INSERT_VILLAGE_INFO", line 6
ORA-06512: 在 line 1
Mon Jan 25 19:34:54 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j002_7785.trc  (incident=24207):
ORA-00600: 内部错误代码, 参数: [13011], [116253], [47737944], [0], [47737944], [17], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/dbtest/dbtest/incident/incdir_24207/dbtest_j002_7785_i24207.trc
Dumping diagnostic data in directory=[cdmp_20210125193455], requested by (instance=1, osid=7791 (J005)), summary=[abnormal process termination].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j002_7785.trc:
ORA-00600: 内部错误代码, 参数: [13011], [116253], [47737944], [0], [47737944], [17], [], [], [], [], [], []
ORA-06512: 在 "testuser.SZW_TJ_FTTHWEEK", line 383
ORA-06512: 在 line 1
Dumping diagnostic data in directory=[cdmp_20210125193456], requested by (instance=1, osid=7785 (J002)), summary=[incident=24207].
Mon Jan 25 19:35:00 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j008_7795.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j008_7795.trc  (incident=24279):
ORA-00600: 内部错误代码, 参数: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/dbtest/dbtest/incident/incdir_24279/dbtest_j008_7795_i24279.trc
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j007_7793.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j007_7793.trc:
ORA-12012: 自动执行作业 241 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j007_7793.trc:
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j008_7795.trc:
ORA-00600: 内部错误代码, 参数: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: 在 "testuser.CHANGE_TR_SDH_NE", line 51
ORA-04088: 触发器 'testuser.CHANGE_TR_SDH_NE' 执行过程中出错
ORA-06512: 在 "testuser.UPDATESDHNEROOMID", line 6
ORA-06512: 在 line 1
Mon Jan 25 19:35:01 2021
Sweep [inc][24279]: completed
Sweep [inc][24207]: completed
Sweep [inc2][24279]: completed
Sweep [inc2][24207]: completed
Mon Jan 25 19:35:05 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_7789.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_7789.trc:
ORA-12012: 自动执行作业 443069 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_7789.trc:
ORA-12012: 自动执行作业 443069 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Mon Jan 25 19:35:07 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j005_7791.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j005_7791.trc:
ORA-12012: 自动执行作业 215979 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j005_7791.trc:
ORA-12012: 自动执行作业 215979 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Mon Jan 25 19:35:07 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j000_7783.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-12012: 自动执行作业 390351 出错
ORA-00001: 违反唯一约束条件 (testuser.IDX_JRAGE_ID)
ORA-06512: 在 "testuser.INSERT_VILLAGE_INFO", line 6
ORA-06512: 在 line 1
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j000_7783.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
ORA-12012: 自动执行作业 390351 出错
ORA-00001: 违反唯一约束条件 (testuser.IDX_JRAGE_ID)
ORA-06512: 在 "testuser.INSERT_VILLAGE_INFO", line 6
ORA-06512: 在 line 1
Mon Jan 25 19:35:10 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j007_7793.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j007_7793.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Mon Jan 25 19:35:15 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_7789.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-12012: 自动执行作业 443069 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_7789.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
ORA-12012: 自动执行作业 443069 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j005_7791.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-12012: 自动执行作业 215979 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j005_7791.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
ORA-12012: 自动执行作业 215979 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Mon Jan 25 19:36:57 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j007_10577.trc:
Mon Jan 25 19:36:58 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_10573.trc:
Mon Jan 25 19:36:58 2021
Dumping diagnostic data in directory=[cdmp_20210125193658], requested by (instance=1, osid=10577 (J007)), summary=[abnormal process termination].
Mon Jan 25 19:36:59 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j003_10571.trc:
Dumping diagnostic data in directory=[cdmp_20210125193659], requested by (instance=1, osid=10573 (J004)), summary=[abnormal process termination].
Mon Jan 25 19:36:59 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j002_10393.trc  (incident=24208):
ORA-00600: 内部错误代码, 参数: [13011], [116253], [47737944], [0], [47737944], [17], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/dbtest/dbtest/incident/incdir_24208/dbtest_j002_10393_i24208.trc
Dumping diagnostic data in directory=[cdmp_20210125193700], requested by (instance=1, osid=10571 (J003)), summary=[abnormal process termination].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j002_10393.trc:
ORA-00600: 内部错误代码, 参数: [13011], [116253], [47737944], [0], [47737944], [17], [], [], [], [], [], []
ORA-06512: 在 "testuser.SZW_TJ_FTTHWEEK", line 383
ORA-06512: 在 line 1
Mon Jan 25 19:37:03 2021
Sweep [inc][24208]: completed
Sweep [inc2][24208]: completed
Mon Jan 25 19:37:12 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j007_10577.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j007_10577.trc:
ORA-12012: 自动执行作业 241 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j007_10577.trc:
ORA-12012: 自动执行作业 241 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Mon Jan 25 19:37:12 2021
Thread 1 cannot allocate new log, sequence 4
Private strand flush not complete
  Current log# 3 seq# 3 mem# 0: /oradata/dbtest/redo01_03.log
Mon Jan 25 19:37:13 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j003_10571.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j003_10571.trc:
ORA-12012: 自动执行作业 215979 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j003_10571.trc:
ORA-12012: 自动执行作业 215979 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Mon Jan 25 19:37:13 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j005_10575.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j005_10575.trc  (incident=24246):
ORA-00600: 内部错误代码, 参数: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/dbtest/dbtest/incident/incdir_24246/dbtest_j005_10575_i24246.trc
Mon Jan 25 19:37:14 2021
Dumping diagnostic data in directory=[cdmp_20210125193714], requested by (instance=1, osid=10577 (J007)), summary=[abnormal process termination].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Mon Jan 25 19:37:14 2021
Sweep [inc][24246]: completed
Sweep [inc2][24246]: completed
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j005_10575.trc:
ORA-00600: 内部错误代码, 参数: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: 在 "testuser.CHANGE_TR_SDH_NE", line 51
ORA-04088: 触发器 'testuser.CHANGE_TR_SDH_NE' 执行过程中出错
ORA-06512: 在 "testuser.UPDATESDHNEROOMID", line 6
ORA-06512: 在 line 1
Mon Jan 25 19:37:14 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_10573.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_10573.trc:
ORA-12012: 自动执行作业 443069 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_10573.trc:
ORA-12012: 自动执行作业 443069 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Dumping diagnostic data in directory=[cdmp_20210125193715], requested by (instance=1, osid=10575 (J005)), summary=[incident=24246].
Thread 1 advanced to log sequence 4 (LGWR switch)
  Current log# 4 seq# 4 mem# 0: /oradata/dbtest/redo01_04.log
Mon Jan 25 19:37:19 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j000_10389.trc:
ORA-12012: 自动执行作业 390351 出错
ORA-00001: 违反唯一约束条件 (testuser.IDX_JRAGE_ID)
ORA-06512: 在 "testuser.INSERT_VILLAGE_INFO", line 6
ORA-06512: 在 line 1
Mon Jan 25 19:37:25 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j007_10577.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-12012: 自动执行作业 241 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j007_10577.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
ORA-12012: 自动执行作业 241 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Mon Jan 25 19:37:25 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j003_10571.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-12012: 自动执行作业 215979 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j003_10571.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
ORA-12012: 自动执行作业 215979 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Mon Jan 25 19:37:26 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_10573.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-12012: 自动执行作业 443069 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j004_10573.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
ORA-12012: 自动执行作业 443069 出错
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j000_10389.trc:
ORA-12012: 自动执行作业 390351 出错
ORA-00001: 违反唯一约束条件 (testuser.IDX_JRAGE_ID)
ORA-06512: 在 "testuser.INSERT_VILLAGE_INFO", line 6
ORA-06512: 在 line 1
Mon Jan 25 19:37:36 2021
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j000_10389.trc:
ORA-00308: 无法打开归档日志 '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_1001262830.dbf'
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-12012: 自动执行作业 390351 出错
ORA-00001: 违反唯一约束条件 (testuser.IDX_JRAGE_ID)
ORA-06512: 在 "testuser.INSERT_VILLAGE_INFO", line 6
ORA-06512: 在 line 1
Errors in file /oracle/app/oracle/diag/rdbms/dbtest/dbtest/trace/dbtest_j000_10389.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-08102: 未找到索引关键字, 对象号 290, 文件 1, 块 2033 (2)
ORA-12012: 自动执行作业 390351 出错
ORA-00001: 违反唯一约束条件 (testuser.IDX_JRAGE_ID)
ORA-06512: 在 "testuser.INSERT_VILLAGE_INFO", line 6
ORA-06512: 在 line 1
dateMon Jan 25 19:38:40 2021
drop tablespace undotbs1 including contents and datafiles
Deleted file /oradata/dbtest/undotbs1.265.946553091
Completed: drop tablespace undotbs1 including contents and datafiles

对于13013错误而言，随后的6个参数含义如下：

Arg [a] Passcount

Arg [b] Data Object number

Arg [c] Tablespace Relative DBA of block containing the row to be updated

Arg [d] Row Slot number

Arg [e] Relative DBA of block being updated (should be same as [c])

 

处理过程：

[oracle@dbtest ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 25 19:16:44 2021

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 6413680640 bytes
Fixed Size                  2265224 bytes
Variable Size            1157631864 bytes
Database Buffers         5234491392 bytes
Redo Buffers               19292160 bytes
Database mounted.
ORA-00742: Log read detects lost write in thread %d sequence %d block %d
ORA-00312: online log 4 thread 1: '/oradata/dbtest/redo01_04.log'


SQL> !oerr ora 742
00742, 00000, "Log read detects lost write in thread %d sequence %d block %d"
// *Cause:  Either a write issued by Oracle was lost by the underlying 
//          operating system or storage system or an Oracle internal error 
//          occurred.
// *Action: The trace file shows the lost write location. Dump the problematic
//          log file to see whether it is a real lost write. Contact Oracle
//          Support Services.

SQL> !ll /oradata/dbtest/redo0*
/bin/bash: ll: command not found

SQL> !ls -l /oradata/dbtest/redo0*
-rw-r----- 1 oracle oinstall 524288512 120 17:03 /oradata/dbtest/redo01_01.log
-rw-r----- 1 oracle oinstall 524288512 121 04:00 /oradata/dbtest/redo01_02.log
-rw-r----- 1 oracle oinstall 524288512 121 04:00 /oradata/dbtest/redo01_03.log
-rw-r----- 1 oracle oinstall 524288512 121 17:04 /oradata/dbtest/redo01_04.log
-rw-r----- 1 oracle oinstall 524288512 120 04:00 /oradata/dbtest/redo01_05.log
-rw-r----- 1 oracle oinstall 524288512 226 2019 /oradata/dbtest/redo02_01.log
-rw-r----- 1 oracle oinstall 524288512 226 2019 /oradata/dbtest/redo02_02.log
-rw-r----- 1 oracle oinstall 524288512 226 2019 /oradata/dbtest/redo02_03.log
-rw-r----- 1 oracle oinstall 524288512 226 2019 /oradata/dbtest/redo02_04.log
-rw-r----- 1 oracle oinstall 524288512 226 2019 /oradata/dbtest/redo02_05.log

SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00742: Log read detects lost write in thread %d sequence %d block %d
ORA-00312: online log 4 thread 1: '/oradata/dbtest/redo01_04.log'


SQL> select checkpoint_change# from v$database;   

CHECKPOINT_CHANGE#
------------------
        1.5899E+13

SQL> col checkpoint_change# for 9999999999999999999999999999
SQL> select checkpoint_change# from v$database;   

           CHECKPOINT_CHANGE#
-----------------------------
               15898926555157

SQL> select checkpoint_change# from v$datafile;     

           CHECKPOINT_CHANGE#
-----------------------------
               15898926555157
               15898926555157
               15898926555157
               15898926555157
               15898926555157
               15898926555157
               15898926555157
               15898926555157
               15898926555157
               15898926555157
               15898926555157

           CHECKPOINT_CHANGE#
-----------------------------
               15898926555157
               15898926555157
               15898926555157
               15898926555157
               15898926555157
               15898926555157
               15898926555157
               15898926555157
               15898926555157
               15898926555157
               15898926555157

           CHECKPOINT_CHANGE#
-----------------------------
               15898926555157
               15898926555157
               15898926555157
               15898926555157
               15898926555157
               15898926555157
               15898926555157
               15898926555157

30 rows selected.

SQL> select checkpoint_change# from v$datafile_header;  

           CHECKPOINT_CHANGE#
-----------------------------
               15898926565049
               15898926565049
               15898926565049
               15898926565049
               15898926565049
               15898926565049
               15898926565049
               15898926565049
               15898926565049
               15898926565049
               15898926565049

           CHECKPOINT_CHANGE#
-----------------------------
               15898926565049
               15898926565049
               15898926565049
               15898926565049
               15898926565049
               15898926565049
               15898926565049
               15898926565049
               15898926565049
               15898926565049
               15898926565049

           CHECKPOINT_CHANGE#
-----------------------------
               15898926565049
               15898926565049
               15898926565049
               15898926565049
               15898926565049
               15898926565049
               15898926565049
               15898926565049

30 rows selected.

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 15898926565049 generated at 01/21/2021 04:00:29 needed for
thread 1
ORA-00289: suggestion :
/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1704_1001262830.dbf
ORA-00280: change 15898926565049 for thread 1 is in sequence #1704


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oradata/dbtest/system.263.946553089'


ORA-01112: media recovery not started


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oradata/dbtest/system.263.946553089'


SQL> select * from v$Log;
SQL> set line 132
SQL> set wrap off      
SQL> r
  1* select * from v$Log
truncating (as requested) before column NEXT_CHANGE#


    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME      NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- -----------
         1          1       1701  524288000        512          1 NO  INACTIVE            1.5899E+13 2021-01-20 04:00:09 2021-01-20
         2          1       1702  524288000        512          1 NO  INACTIVE            1.5899E+13 2021-01-20 17:03:28 2021-01-21
         5          1       1700  524288000        512          1 NO  INACTIVE            1.5899E+13 2021-01-20 02:01:19 2021-01-20
         4          1       1704  524288000        512          1 NO  CURRENT             1.5899E+13 2021-01-21 04:00:29
         3          1       1703  524288000        512          1 NO  INACTIVE            1.5899E+13 2021-01-21 04:00:08 2021-01-21

SQL> select * from v$Logfile;
rows will be truncated


    GROUP# STATUS  TYPE    MEMBER
---------- ------- ------- ---------------------------------------------------------------------------------------------------------
         1         ONLINE  /oradata/dbtest/redo01_01.log
         2         ONLINE  /oradata/dbtest/redo01_02.log
         3         ONLINE  /oradata/dbtest/redo01_03.log
         4         ONLINE  /oradata/dbtest/redo01_04.log
         5         ONLINE  /oradata/dbtest/redo01_05.log

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 15898926565049 generated at 01/21/2021 04:00:29 needed for thread 1
ORA-00289: suggestion : /oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_1704_1001262830.dbf
ORA-00280: change 15898926565049 for thread 1 is in sequence #1704


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/oradata/dbtest/redo01_04.log
Log applied.
Media recovery complete.
SQL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 111939
Session ID: 62 Serial number: 3


SQL> startup nomount
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> conn /as sysdba
Connected.
SQL> startup nomount
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> show parameter name;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name               string
db_file_name_convert                 string
db_name                              string      dbtest
db_unique_name                       string      dbtest
global_names                         boolean     FALSE
instance_name                        string      dbtest
lock_name_space                      string
log_file_name_convert                string
processor_group_name                 string
service_names                        string      dbtest
SQL> show parameter undo;       

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
_gc_undo_affinity                    boolean     FALSE
_undo_autotune                       boolean     FALSE
undo_management                      string      AUTO
undo_retention                       integer     21600
undo_tablespace                      string      UNDOTBS1
SQL> create undo tablespace undotbs2 datafile '/oradata/dbtest/undo2_01.dbf' size 100M autoextend on;
create undo tablespace undotbs2 datafile '/oradata/dbtest/undo2_01.dbf' size 100M autoextend on
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [4193], [ody "SYS.DBMSE


SQL> alter system set undo_tablespace='SYSTEM';
alter system set undo_tablespace='SYSTEM'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-30012: undo tablespace 'SYSTEM' does not exist or of wrong type


SQL> alter system set undo_tablespace='SYSTEM' scope=spfile;

System altered.

SQL> alter system set undo_management='MANUAL' scope=spfile;

System altered.

SQL> shutdown immediate
ORA-03135: connection lost contact
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 6413680640 bytes
Fixed Size                  2265224 bytes
Variable Size            1157631864 bytes
Database Buffers         5234491392 bytes
Redo Buffers               19292160 bytes
Database mounted.
Database opened.
SQL> show parameter undo;     

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
_gc_undo_affinity                    boolean     FALSE
_undo_autotune                       boolean     FALSE
undo_management                      string      MANUAL
undo_retention                       integer     21600
undo_tablespace                      string      SYSTEM
SQL> create undo tablespace undotbs2 datafile '/oradata/dbtest/undo2_01.dbf' size 100M autoextend on;

Tablespace created.

SQL> alter system set undo_tablespace='UNDOTBS2' scope=spfile;

System altered.

SQL> alter system set undo_management='AUTO' scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 6413680640 bytes
Fixed Size                  2265224 bytes
Variable Size            1157631864 bytes
Database Buffers         5234491392 bytes
Redo Buffers               19292160 bytes
Database mounted.
Database opened.
SQL> !oerr ora  8102     
08102, 00000, "index key not found, obj# %s, file %s, block %s (%s)"
// *Cause:  Internal error: possible inconsistency in index
// *Action:  Send trace file to your customer support representative, along
//           with information on reproducing the error

SQL> Select owner, segment_name, segment_type, partition_name,tablespace_name
  2  From dba_extents
  3  Where relative_fno = 1
  4  And 2033 between block_id and (block_id+blocks-1);


OWNER                          SEGMENT_NAME                                                                      SEGMENT_TYPE
------------------------------ --------------------------------------------------------------------------------- ------------------
SYS                            I_JOB_NEXT                                                                        INDEX

SQL> select object_name,object_type from dba_objects where object_id=290;

OBJECT_NAME                                                                                                                      OBJ
-------------------------------------------------------------------------------------------------------------------------------- ---
I_JOB_NEXT                                                                                                                       IND

SQL> col OBJECT_NAME for a20
SQL> r
  1* select object_name,object_type from dba_objects where object_id=290

OBJECT_NAME          OBJECT_TYPE
-------------------- -------------------
I_JOB_NEXT           INDEX

SQL> drop index i_job_next;
drop index i_job_next
           *
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired


SQL> /
drop index i_job_next
           *
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired


SQL> /
drop index i_job_next
           *
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired


SQL> /
drop index i_job_next
           *
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired


SQL> set time on
19:37:38 SQL> /

Index dropped.

19:37:40 SQL> create index i_job_next on job$ (next_date);

Index created.

19:37:49 SQL> select object_name,object_type from dba_objects where object_id=290;

no rows selected

19:37:54 SQL> drop tablespace undotbs1 including contents and datafiles;

Tablespace dropped.

19:38:41 SQL> 

 

Mon Jan 25 19:59:00 2021
Errors in file /oracle/app/oracle/diag/rdbms/zydbtest/zydbtest/trace/zydbtest_j000_39154.trc  (incident=26606):
ORA-00600: 内部错误代码, 参数: [13011], [116253], [47737944], [0], [47737944], [17], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/zydbtest/zydbtest/incident/incdir_26606/zydbtest_j000_39154_i26606.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracle/app/oracle/diag/rdbms/zydbtest/zydbtest/trace/zydbtest_j000_39154.trc:
ORA-00600: 内部错误代码, 参数: [13011], [116253], [47737944], [0], [47737944], [17], [], [], [], [], [], []
ORA-06512: 在 "GISTAR.SZW_TJ_FTTHWEEK", line 383
ORA-06512: 在 line 1
Mon Jan 25 19:59:02 2021
Dumping diagnostic data in directory=[cdmp_20210125195902], requested by (instance=1, osid=39154 (J000)), summary=[incident=26606].
Mon Jan 25 19:59:03 2021
Sweep [inc][26606]: completed
Sweep [inc2][26606]: completed
Mon Jan 25 20:00:50 2021
Errors in file /oracle/app/oracle/diag/rdbms/zydbtest/zydbtest/trace/zydbtest_j000_41788.trc  (incident=26607):
ORA-00600: 内部错误代码, 参数: [13011], [116253], [47737944], [0], [47737944], [17], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/zydbtest/zydbtest/incident/incdir_26607/zydbtest_j000_41788_i26607.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracle/app/oracle/diag/rdbms/zydbtest/zydbtest/trace/zydbtest_j000_41788.trc:
ORA-00600: 内部错误代码, 参数: [13011], [116253], [47737944], [0], [47737944], [17], [], [], [], [], [], []
ORA-06512: 在 "GISTAR.SZW_TJ_FTTHWEEK", line 383
ORA-06512: 在 line 1
Mon Jan 25 20:00:52 2021
Dumping diagnostic data in directory=[cdmp_20210125200052], requested by (instance=1, osid=41788 (J000)), summary=[incident=26607].
Mon Jan 25 20:00:54 2021
Sweep [inc][26607]: completed
Sweep [inc2][26607]: completed
dateMon Jan 25 20:02:36 2021
Errors in file /oracle/app/oracle/diag/rdbms/zydbtest/zydbtest/trace/zydbtest_j000_44250.trc  (incident=26608):
ORA-00600: 内部错误代码, 参数: [13011], [116253], [47737944], [0], [47737944], [17], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/zydbtest/zydbtest/incident/incdir_26608/zydbtest_j000_44250_i26608.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracle/app/oracle/diag/rdbms/zydbtest/zydbtest/trace/zydbtest_j000_44250.trc:
ORA-00600: 内部错误代码, 参数: [13011], [116253], [47737944], [0], [47737944], [17], [], [], [], [], [], []
ORA-06512: 在 "GISTAR.SZW_TJ_FTTHWEEK", line 383
ORA-06512: 在 line 1
Mon Jan 25 20:02:38 2021
Dumping diagnostic data in directory=[cdmp_20210125200238], requested by (instance=1, osid=44250 (J000)), summary=[incident=26608].
Mon Jan 25 20:02:39 2021
Sweep [inc][26608]: completed
Sweep [inc2][26608]: completed
Mon Jan 25 20:03:59 2021
The value (167) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.

处理做法：https://blog.csdn.net/weixin_34324081/article/details/86001693

19:58:59 SQL> select object_name,object_type,owner from dba_objects where object_id=116253;

OBJECT_NAME          OBJECT_TYPE         OWNER
-------------------- ------------------- ------------------------------
JR_FTTH_JOIN_WEEK    TABLE               TESTUSER

19:59:35 SQL> select index_name from dba_indexes where owner='TESTUSER' and table_name='JR_FTTH_JOIN_WEEK';

INDEX_NAME
------------------------------
PKIY_WHER_1
IDX_MAINFG_PI

20:00:20 SQL> set wrap on
20:02:47 SQL> set serveroutput on
20:02:54 SQL> set long 999999
20:02:57 SQL> select dbms_metadata.get_ddl('INDEX', 'PKIY_WHER_1', 'TESTUSER') from dual;

DBMS_METADATA.GET_DDL('INDEX','PKIY_WHER_1','TESTUSER')
--------------------------------------------------------------------------------

  CREATE UNIQUE INDEX "TESTUSER"."PKIY_WHER_1" ON "TESTUSER"."JR_FTTH_JOIN_WEEK" ("ID")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"


20:03:04 SQL> select dbms_metadata.get_ddl('INDEX', 'IDX_MAINFG_PI', 'TESTUSER') from dual;

DBMS_METADATA.GET_DDL('INDEX','IDX_MAINFG_PI','TESTUSER')
--------------------------------------------------------------------------------

  CREATE INDEX "TESTUSER"."IDX_MAINFG_PI" ON "TESTUSER"."JR_FTTH_JOIN_WEEK" ("MAINTENACE_CODE")
  PCTFREE 10 INITRANS 2 MAXTRANS 167 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"


20:03:10 SQL> drop index "TESTUSER"."PKIY_WHER_1";
drop index "TESTUSER"."PKIY_WHER_1"
                    *
ERROR at line 1:
ORA-02429: cannot drop index used for enforcement of unique/primary key


20:03:21 SQL> !oerr ora 02429
02429, 00000, "cannot drop index used for enforcement of unique/primary key"
// *Cause: user attempted to drop an index that is being used as the 
//         enforcement mechanism for unique or primary key.
// *Action: drop the constraint instead of the index.

20:03:32 SQL> drop index "TESTUSER"."IDX_MAINFG_PI";

Index dropped.

20:03:48 SQL>   CREATE INDEX "TESTUSER"."IDX_MAINFG_PI" ON "TESTUSER"."JR_FTTH_JOIN_WEEK" ("MAINTENACE_CODE")
20:03:57   2    PCTFREE 10 INITRANS 2 MAXTRANS 167 COMPUTE STATISTICS
20:03:57   3    STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
20:03:57   4    PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
20:03:57   5    BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
20:03:57   6    TABLESPACE "USERS";

Index created.

20:03:59 SQL>                                                                      
20:06:27 SQL> 
20:06:27 SQL> alter table TESTUSER.JR_FTTH_JOIN_WEEK drop constraint TESTUSER.PKIY_WHER_1;
alter table TESTUSER.JR_FTTH_JOIN_WEEK drop constraint TESTUSER.PKIY_WHER_1
                                                           *
ERROR at line 1:
ORA-01735: invalid ALTER TABLE option


20:06:29 SQL> alter table TESTUSER.JR_FTTH_JOIN_WEEK drop constraint PKIY_WHER_1;

Table altered.

20:06:38 SQL> drop index "TESTUSER"."PKIY_WHER_1";

Index dropped.

用到的脚本参考：删除重复记录
Select ID from TESTUSER.JR_FTTH_JOIN_WEEK 
Group by ID
Having count(ID)>1;


DELETE FROM TESTUSER.JR_FTTH_JOIN_WEEK A WHERE (A.ID) IN (SELECT ID FROM TESTUSER.JR_FTTH_JOIN_WEEK GROUP BY ID HAVING COUNT(*) > 1) AND ROWID NOT IN (SELECT MIN(ROWID) FROM TESTUSER.JR_FTTH_JOIN_WEEK GROUP BY ID HAVING COUNT(*)>1);
commit;

评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值