본문 바로가기

Oracle/Oracle testing

10g기본설치후 아카이브모드에서 떴다가 죽는 아카이버


10g 오라클을 설치해보고 나서 아카이브모드를 활성화 하고나서

오라클 instance 를 띄우면

 

Arc0 , 1 , 2 가 뜬다.

 

총 3개의 프로세스가 뜨는데

대략 10분정도있다가 2번이 죽는다.

 

왜그럴까????? 초보자라 그런가.. 난 여기저기 물어봐도 답은 못찾았다.

현업DBA도 그렇고 강사분도 그렇고.....

 

우선 vmware로 single instance 로 해서

ASM을 사용하여 ( 물론 파일시스템에서도 마찬가지 상황이 발생 )

 

오라클( 10g R2) 을 설치후 .

 

해당 arc2 의 프로세스를 dump를 떠보기로 했다. 뭐 답은 정확하게 안나오겠으나 뭐하고 있는지는 볼수있을테니 말이다.

 

아래는 덤프뜬화면

 

/u01/app/oracle/admin/ORCL/bdump/orcl_arc2_6940.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0
System name:    Linux
Node name:      ora1.oracle.com
Release:        2.6.18-194.11.1.el5
Version:        #1 SMP Tue Aug 10 19:05:06 EDT 2010
Machine:        x86_64
Instance name: ORCL
Redo thread mounted by this instance: 1
Oracle process number: 21
Unix process pid: 6940, image: oracle@ora1.oracle.com (ARC2)

*** 2010-08-22 20:11:16.882
*** SERVICE NAME:(SYS$BACKGROUND) 2010-08-22 20:11:16.882
*** SESSION ID:(151.1) 2010-08-22 20:11:16.882
Received ORADEBUG command 'event 10046 trace name context forever , level 8' from process Unix process pid: 6934, image:
WAIT #0: nam='rdbms ipc message' ela= 16905133 timeout=29928 p2=0 p3=0 obj#=-1 tim=1252417457893546
Received ORADEBUG command 'tracefile_name' from process Unix process pid: 6934, image:
WAIT #0: nam='rdbms ipc message' ela= 7194698 timeout=28197 p2=0 p3=0 obj#=-1 tim=1252417465088309
*** 2010-08-22 20:15:17.509
WAIT #0: nam='rdbms ipc message' ela= 29273322 timeout=2997 p2=0 p3=0 obj#=-1 tim=1252417733301500
WAIT #0: nam='control file sequential read' ela= 9501 file#=0 block#=1 blocks=1 obj#=-1 tim=1252417733311350
WAIT #0: nam='control file sequential read' ela= 83 file#=1 block#=1 blocks=1 obj#=-1 tim=1252417733311450
WAIT #0: nam='control file sequential read' ela= 60 file#=0 block#=16 blocks=1 obj#=-1 tim=1252417733311527
WAIT #0: nam='control file sequential read' ela= 278 file#=0 block#=18 blocks=1 obj#=-1 tim=1252417733311819
WAIT #0: nam='control file sequential read' ela= 78 file#=0 block#=1 blocks=1 obj#=-1 tim=1252417733311999
WAIT #0: nam='control file sequential read' ela= 57 file#=1 block#=1 blocks=1 obj#=-1 tim=1252417733312075
WAIT #0: nam='control file sequential read' ela= 57 file#=0 block#=16 blocks=1 obj#=-1 tim=1252417733312143
WAIT #0: nam='control file sequential read' ela= 233 file#=0 block#=18 blocks=1 obj#=-1 tim=1252417733312390
*** 2010-08-22 20:15:58.911 2520 kcrf.c
tkcrf_clear_srl: Started clearing Standby Redo Logs
WAIT #0: nam='control file sequential read' ela= 81 file#=0 block#=1 blocks=1 obj#=-1 tim=1252417733312586
WAIT #0: nam='control file sequential read' ela= 50 file#=1 block#=1 blocks=1 obj#=-1 tim=1252417733312651
WAIT #0: nam='control file sequential read' ela= 56 file#=0 block#=16 blocks=1 obj#=-1 tim=1252417733312720
WAIT #0: nam='control file sequential read' ela= 201 file#=0 block#=18 blocks=1 obj#=-1 tim=1252417733312934
WAIT #0: nam='control file sequential read' ela= 74 file#=0 block#=21 blocks=1 obj#=-1 tim=1252417733313056
WAIT #0: nam='control file sequential read' ela= 91 file#=0 block#=1 blocks=1 obj#=-1 tim=1252417733313189
WAIT #0: nam='control file sequential read' ela= 49 file#=1 block#=1 blocks=1 obj#=-1 tim=1252417733313251
WAIT #0: nam='control file sequential read' ela= 70 file#=0 block#=16 blocks=1 obj#=-1 tim=1252417733313334
WAIT #0: nam='control file sequential read' ela= 196 file#=0 block#=18 blocks=1 obj#=-1 tim=1252417733313544
WAIT #0: nam='control file sequential read' ela= 4963 file#=0 block#=304 blocks=1 obj#=-1 tim=1252417733318528
WAIT #0: nam='control file parallel write' ela= 1117 files=2 block#=303 requests=2 obj#=-1 tim=1252417733319707
WAIT #0: nam='control file parallel write' ela= 1310 files=2 block#=17 requests=2 obj#=-1 tim=1252417733321040
WAIT #0: nam='control file parallel write' ela= 1687 files=2 block#=15 requests=2 obj#=-1 tim=1252417733322747
WAIT #0: nam='control file parallel write' ela= 1034 files=2 block#=1 requests=2 obj#=-1 tim=1252417733323813
*** 2010-08-22 20:15:58.923 2828 kcrf.c
tkcrf_clear_srl: Completed clearing Standby Redo Logs
*** 2010-08-22 20:17:03.742
WAIT #0: nam='rdbms ipc message' ela= 63299452 timeout=30000 p2=0 p3=0 obj#=-1 tim=1252417796623412
WAIT #0: nam='Log archive I/O' ela= 23 count=4294967295 intr=0 timeout=2147483647 obj#=-1 tim=1252417796623759

주로 발생하는 event 는 뭐 뻔하다.

일반 로그파일이 하는 일만곤 별로 없는듯하다.

 

저 맨마지막에 Log archive I/O가 발생하고나서 해당 프로세스는 대기상태로 돌아가는게 아니라

그냥 그상태로 죽는다. 프로세스상에서 확인해보면 완전죽어있다.

 

딱 기본 컨트롤파일관련 내용만 쓰고 죽는 것 같은데 도대체 왜~~~~~

어째서~~~ 그럴까.