Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-14 15:08:08 | 查看: 1506| 回复: 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)

请问这个问题怎么解决!!!
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-6-18 20:21 , Processed in 0.052486 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569