- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-14 15:08:08
|
查看: 1640 |
回复: 0
SQL> startup
ORACLE instance started.
Total System Global Area 2.0043E+10 bytes
Fixed Size 2230104 bytes
Variable Size 2550139048 bytes
Database Buffers 1.7448E+10 bytes
Redo Buffers 42098688 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 9240608
Session ID: 551 Serial number: 3
alter日志部分如下:
ALTER DATABASE OPEN
LGWR: STARTING ARCH PROCESSES
Fri Aug 08 10:42:57 2014
ARC0 started with pid=23, OS id=7798912
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Fri Aug 08 10:42:58 2014
ARC1 started with pid=24, OS id=8781866
Fri Aug 08 10:42:58 2014
ARC2 started with pid=25, OS id=9175076
Fri Aug 08 10:42:58 2014
ARC3 started with pid=26, OS id=8912926
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC1: Encountered disk I/O error 19502
ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: '/data/arch1_370_854274092.dbf' (error 19502) (csmasid)
ARCH: Encountered disk I/O error 19502
ARCH: Closing local archive destination LOG_ARCHIVE_DEST_1: '/data/arch1_369_854274092.dbf' (error 19502) (csmasid)
ARCH: I/O error 19502 archiving log 3 to '/data/arch1_369_854274092.dbf'
Errors in file /opt/oracle/diag/rdbms/csmadb/csmasid/trace/csmasid_ora_9240608.trc:
ORA-16038: log 3 sequence# 369 cannot be archived
ORA-19502: write error on file "", block number (block size=)
ORA-00312: online log 3 thread 1: '/opt/oradata/csmadb/redo03.log'
USER (ospid: 9240608): terminating the instance due to error 16038
Fri Aug 08 10:43:06 2014
System state dump requested by (instance=1, osid=9240608), summary=[abnormal instance termination].
System State dumped to trace file /opt/oracle/diag/rdbms/csmadb/csmasid/trace/csmasid_diag_7012446.trc
Dumping diagnostic data in directory=[cdmp_20140808104306], requested by (instance=1, osid=9240608), summary=[abnormal instance termination].
Instance terminated by USER, pid = 9240608
/opt/oracle/diag/rdbms/csmadb/csmasid/trace/csmasid_ora_9240608.trc 文件内容:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /opt/oracle/product/11.2.0/db_home_1
System name: AIX
Node name: OFSAAPRO
Release: 1
Version: 7
Machine: 00F933704C00
Instance name: csmasid
Redo thread mounted by this instance: 1
Oracle process number: 22
Unix process pid: 9240608, image: oracle@OFSAAPRO (TNS V1-V3)
*** 2014-08-08 10:42:58.231
*** SESSION ID:(551.3) 2014-08-08 10:42:58.231
*** CLIENT ID:() 2014-08-08 10:42:58.231
*** SERVICE NAME:() 2014-08-08 10:42:58.231
*** MODULE NAME:(sqlplus@OFSAAPRO (TNS V1-V3)) 2014-08-08 10:42:58.231
*** ACTION NAME:() 2014-08-08 10:42:58.231
Initial buffer sizes: read 1024K, overflow 832K, change 805K
*** 2014-08-08 10:43:04.776
*** 2014-08-08 10:43:04.776 4320 krsh.c
ARCH: Encountered disk I/O error 19502
Exception 19502 encountered when closing file
*** 2014-08-08 10:43:05.199
*** 2014-08-08 10:43:05.199 4320 krsh.c
ARCH: I/O error 19502 archiving log 3 to '/data/arch1_369_854274092.dbf'
*** 2014-08-08 10:43:05.199 2932 krsi.c
krsi_dst_fail: dest:1 err:19502 force:0 blast:1
DDE rules only execution for: ORA 312
----- 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) -----
ORA-16038: log 3 sequence# 369 cannot be archived
ORA-19502: write error on file "", block number (block size=)
ORA-00312: online log 3 thread 1: '/opt/oradata/csmadb/redo03.log'
kjzduptcctx: Notifying DIAG for crash event
----- Abridged Call Stack Trace -----
ksedsts()+360<-kjzdssdmp()+240<-kjzduptcctx()+228<-kjzdicrshnfy()+100<-ksuitm()+5124<-kcfopd()+5604<-adbdrv()+8104<-opiexe()+15864<-opiosq0()+3616<-kpooprx()+332<-kpoal8()+6872<-opiodr()+720<-ttcpip()+1028<-opitsk()+1508<-opiino()+940<-opiodr()+720<-opidrv()+1132
<-sou2o()+136<-opimai_real()+608<-ssthrdmain()+268
----- End of Abridged Call Stack Trace -----
*** 2014-08-08 10:43:05.296
USER (ospid: 9240608): terminating the instance due to error 16038
ksuitm: waiting up to [5] seconds before killing DIAG(7012446)
请问这个问题怎么解决!!! |
|