从上面信息可以看到磁盘组3(也就是磁盘组+GJJ_DG)已经dismounted了并且ckpt进程终止了实例。如是查看跟踪文件/opt/app/oracle/diag/rdbms/jtpsoft/jtpsoft1/trace/jtpsoft1_arc1_10551306.trc,可以看到如下内容:
Trace file /opt/app/oracle/diag/rdbms/jtpsoft/jtpsoft1/trace/jtpsoft1_arc1_10551306.trc Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /opt/app/oracle/product/11.2.0/db_1 System name: AIX Node name: p720a Release: 1 Version: 6 Machine: 00C855104C00 Instance name: jtpsoft1 Redo thread mounted by this instance: 1 Oracle process number: 41 Unix process pid: 10551306, image: oracle@p720a (ARC1) *** 2016-03-31 14:29:21.527 *** SESSION ID:(641.1) 2016-03-31 14:29:21.527 *** CLIENT ID:() 2016-03-31 14:29:21.527 *** SERVICE NAME:(SYS$BACKGROUND) 2016-03-31 14:29:21.527 *** MODULE NAME:() 2016-03-31 14:29:21.527 *** ACTION NAME:() 2016-03-31 14:29:21.527 *** TRACE FILE RECREATED AFTER BEING REMOVED *** WARNING:failed xlate 2 WARNING: requested mirror side 1 of virtual extent 0 logical extent 0 offset 16384 is not allocated; I/O request failed WARNING:failed xlate 2 WARNING: requested mirror side 2 of virtual extent 0 logical extent 1 offset 16384 is not allocated; I/O request failed WARNING:failed xlate 2 WARNING: requested mirror side 3 of virtual extent 0 logical extent 2 offset 16384 is not allocated; I/O request failed DDE rules only execution for: ORA 202 ----- START Event Driven Actions Dump ---- ---- END Event Driven Actions Dump ---- ----- START DDE Actions Dump ----- Executing SYNC actions ----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) ----- Successfully dispatched ----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) ----- Executing ASYNC actions ----- END DDE Actions Dump (total 0 csec) ----- *** 2016-03-31 14:29:21.533 dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=1, mask=0x0) ----- Error Stack Dump ----- ORA-00202: control file: '+GJJ_DG/jtpsoft/controlfile/current.260.841581789' ORA-15079: ASM file is closed ORA-15079: ASM file is closed ORA-15079: ASM file is closed ----- SQL Statement (None) ----- Current SQL information unavailable - no cursor. ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- skdstdst()+40 bl 0000000109B3BDC0 FFFFFFFFFFF6D60 ? 000000001 ? 000000001 ? 000000000 ? 000000000 ? 000000001 ? 000000001 ? 000000000 ? ksedst1()+112 call skdstdst() FFFFFFFFFFF6E38 ? 000002004 ? 110720F48 ? 10A6D6A74 ? 10A6D5F50 ? FFFFFFFFFFF7190 ? FFFFFFFFFFF6F40 ? 2050033FFFF6E18 ? ksedst()+40 call ksedst1() 10A6D6A68 ? 7000000000291 ? 10A6D6A3C ? B000000000000 ? 10A6D5F50 ? 000000000 ? 400000000 ? 1D25C0C474A0C ? dbkedDefDump()+1516 call ksedst() 000000001 ? FFFFFFFFFFF72F0 ? 000000001 ? 000000000 ? 000000003 ? 00001ED50 ? 000000000 ? 000000000 ? ksedmp()+72 call dbkedDefDump() 1A006FE88 ? 9001000A0000E00 ? FFFFFFFFFFF7CD0 ? 004C3009B ? 000000000 ? 000000001 ? 000000001 ? 0000000CC ? kcccsi()+416 call ksedmp() CA000000CA ? 000000001 ? 000000031 ? 7000104BCDE1D56 ? 000000000 ? 7000104C8CC4478 ? 000000006 ? 000000030 ? kccrhd()+1488 call kcccsi() 000000020 ? 000000000 ? 110738B50 ? 10A344FE0 ? FFFFFFFFFFF7FA0 ? 004C3009B ? 102D0B800 ? 11298BF30 ? kccgft_refresh_hdr( call kccrhd() FFFFFFFFFFF8100 ? 004C3009B ? )+124 11297B0B0 ? FFFFFFFFFFFA5E0 ? 6B736C636D617266 ? 112939850 ? 10A38F248 ? 10A38F258 ? kcc_noenq_refresh() call kccgft_refresh_hdr( 110E9DA20 ? 000000004 ? +40 ) 000000018 ? 11012D7C8 ? 000000021 ? 00000374E ? 000000001 ? FFFFFFFFFFF81F0 ? kccocx_noenq()+292 call kcc_noenq_refresh() 20B6CECD0 ? 000000102 ? 000000000 ? 000000000 ? FFFFFFFFFFF8070 ? 44244288000537D0 ? 9000000000051AC ? FFFFFFFFFFF8030 ? ...省略...Oracle ASM异常dismount磁盘组(2)
内容版权声明:除非注明,否则皆为本站原创文章。
转载注明出处:https://www.heiqu.com/e886b03f22c1e7229db490acc978da31.html