데이터베이스 질문과 답변
오늘 회사에서 장애가 발생했네요 ^^...
0
5
5,177
by 정순표 [2007.04.11 17:31:25]
ORA-01115: IO error reading block from file 744 (block # 218858)
ORA-01110: data file 744: '/dev/rvol/DSK119/v_dsk119_6'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
Compaq Tru64 UNIX Error: 22: Invalid argument
Additional information: 218849
Additional information: 8
무슨 오류인지 대충 알겠는데 자세한 설명해주실수 있는 분 있나요 ^^..
by 김법용
[2007.04.11 00:00:00]
뭐야 순표형 장애나 일으키고.
by 장태길
[2007.04.11 00:00:00]
data file 에 대한 I/O error 네요.. ㅡ_ㅡ;
system admin 에게 문의 하셔야 할듯..
혹시 해당 해당 파일의 ownership 을 체크해보세요
true64 에서 os rebooting 후에 ownership 이
root 로 넘어가서 db start 시 오류가 발생하는 것을 자주 보왔습니다...
system admin 에게 문의 하셔야 할듯..
혹시 해당 해당 파일의 ownership 을 체크해보세요
true64 에서 os rebooting 후에 ownership 이
root 로 넘어가서 db start 시 오류가 발생하는 것을 자주 보왔습니다...
by 정순표
[2007.04.12 00:00:00]
online상태에서 발생한 i/o에러였습니다.^^
법용아 내가 낸게 아니고 -_-;;
내가 쿼리 날리는데 나오더라 ㅎㅎㅎ
법용아 내가 낸게 아니고 -_-;;
내가 쿼리 날리는데 나오더라 ㅎㅎㅎ
by darkturt
[2007.04.12 00:00:00]
corrupt 도 아니네요..
---------------------------------------------
메타링크 검색 해보면..
아래와 같이 파라미터를 변경 하라고..있네요..
제목: OERR: ORA-27091 { Message text depends on version }
문서 ID: 공지:71375.1 유형: REFERENCE
마지막 갱신 날짜: 08-NOV-2004 상태: PUBLISHED
{ This note contains error information about an "Oracle Server"
error number. It may contain additional support notes as
described in Note 22080.1 }
Oracle10g Release 1 Message
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Error: ORA-27091 (ORA-27091)
Text: unable to queue I/O
---------------------------------------------------------------------------
Cause: read/write/readv/writev system call returned error, additional
information indicates starting block number of I/O
Action: check errno
Oracle 9.2 or Earlier Error Message
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Error: ORA-27091
Text: skgfqio: unable to queue I/O
---------------------------------------------------------------------------
Cause: read/write/readv/writev system call returned error, additional
information indicates starting block number of I/O
Action: check errno
Problem Description:
====================
You are receiving some I/O errors during startup of an instance on a parallel
server. When you bring the DB back up it is giving the following errors:
ORA-19502: "write error on file \"%s\", blockno %s (blocksize=%s)"
Cause: write error on output file
Action: check the file
ORA-27072: "skgfdisp: I/O error"
Cause: read/write/readv/writev system call returned error, additional
information indicates starting block number of I/O
Action: check errno
Solution Description:
=====================
The problem can be resolved by setting the "init.ora" parameter
"control_file_record_keep_time=0" as the size of the control file.
Solution Explanation:
=====================
If "CONTROL_FILE_RECORD_KEEP_TIME" is set to 0, then reusable sections never
expand and records are reused as needed.
---------------------------------------------
메타링크 검색 해보면..
아래와 같이 파라미터를 변경 하라고..있네요..
제목: OERR: ORA-27091 { Message text depends on version }
문서 ID: 공지:71375.1 유형: REFERENCE
마지막 갱신 날짜: 08-NOV-2004 상태: PUBLISHED
{ This note contains error information about an "Oracle Server"
error number. It may contain additional support notes as
described in Note 22080.1 }
Oracle10g Release 1 Message
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Error: ORA-27091 (ORA-27091)
Text: unable to queue I/O
---------------------------------------------------------------------------
Cause: read/write/readv/writev system call returned error, additional
information indicates starting block number of I/O
Action: check errno
Oracle 9.2 or Earlier Error Message
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Error: ORA-27091
Text: skgfqio: unable to queue I/O
---------------------------------------------------------------------------
Cause: read/write/readv/writev system call returned error, additional
information indicates starting block number of I/O
Action: check errno
Problem Description:
====================
You are receiving some I/O errors during startup of an instance on a parallel
server. When you bring the DB back up it is giving the following errors:
ORA-19502: "write error on file \"%s\", blockno %s (blocksize=%s)"
Cause: write error on output file
Action: check the file
ORA-27072: "skgfdisp: I/O error"
Cause: read/write/readv/writev system call returned error, additional
information indicates starting block number of I/O
Action: check errno
Solution Description:
=====================
The problem can be resolved by setting the "init.ora" parameter
"control_file_record_keep_time=0" as the size of the control file.
Solution Explanation:
=====================
If "CONTROL_FILE_RECORD_KEEP_TIME" is set to 0, then reusable sections never
expand and records are reused as needed.
by darkturt
[2007.04.12 00:00:00]
음.. 아까 올리고 지금 다시 확인 해보니..
이것도 엄한 거네요 ㅡ_ㅡ;
역시 멀티플은 아직 적응이 안된다는..
메타링크 검색 결과로 올려드린건
제목: ORA-19502, ORA-27072: I/O ERROR ON STARTUP
이거라 운영중하고는 무관하네요..
ㅠ_ㅠ
이것도 엄한 거네요 ㅡ_ㅡ;
역시 멀티플은 아직 적응이 안된다는..
메타링크 검색 결과로 올려드린건
제목: ORA-19502, ORA-27072: I/O ERROR ON STARTUP
이거라 운영중하고는 무관하네요..
ㅠ_ㅠ
) 버튼을 클릭하여 작성 하시면 됩니다.