database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
PostgreSQL
Firebird
ㆍOracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
Oracle Q&A 21475 게시물 읽기
No. 21475
아카이브 로그 생성시 발생한 오류 해결방법 좀 알려주세요~
작성자
김태진(pinblue)
작성일
2005-01-19 10:52
조회수
2,538

오라클에서 아카이브로그 파일을 생성시 alert_PBWMS.log 파일에 아래와 같은

오류메세지를 남기고 있습니다.

어떻게 해결해야 하는지 궁금합니다. 조언 부탁드려요~

 

[wms1:/oracle/app/oracle/admin/PBWMS/bdump]tail -100 alert_PBWMS.log
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 1701 change 0 time 01/16/2005 05:36:57
ORA-00312: online log 3 thread 1: '/oradata/PBWMS/redo03.log'
ARC1: Archiving not possible: error count exceeded
ARC1: Failed to archive log 3 thread 1 sequence 57
Wed Jan 19 10:18:13 2005
Errors in file /oracle/app/oracle/admin/PBWMS/bdump/pbwms_arc1_835674.trc:
ORA-16038: log 3 sequence# 57 cannot be archived
ORA-00354: corrupt redo log block header
ORA-00312: online log 3 thread 1: '/oradata/PBWMS/redo03.log'
ARC1: Evaluating archive log 3 thread 1 sequence 57
ARC1: Beginning to archive log 3 thread 1 sequence 57
Creating archive destination LOG_ARCHIVE_DEST_1: '/oradata/ARCH/arch_57.arc'
ARC1: Log corruption near block 1701 change 0 time ?
ARC1: All Archive destinations made inactive due to error 354
Wed Jan 19 10:18:14 2005
Errors in file /oracle/app/oracle/admin/PBWMS/bdump/pbwms_arc1_835674.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 1701 change 0 time 01/16/2005 05:36:57
ORA-00312: online log 3 thread 1: '/oradata/PBWMS/redo03.log'
ARC1: Archiving not possible: error count exceeded
ARC1: Failed to archive log 3 thread 1 sequence 57
Wed Jan 19 10:18:14 2005
Errors in file /oracle/app/oracle/admin/PBWMS/bdump/pbwms_arc1_835674.trc:
ORA-16038: log 3 sequence# 57 cannot be archived
ORA-00354: corrupt redo log block header
ORA-00312: online log 3 thread 1: '/oradata/PBWMS/redo03.log'
Wed Jan 19 10:18:15 2005
ARC0: Completed archiving log 2 thread 1 sequence 195
Archiver process freed from errors. No longer stopped
ARC0: Evaluating archive log 3 thread 1 sequence 57
ARC0: Beginning to archive log 3 thread 1 sequence 57
Creating archive destination LOG_ARCHIVE_DEST_1: '/oradata/ARCH/arch_57.arc'
ARC0: Log corruption near block 1701 change 0 time ?
ARC0: All Archive destinations made inactive due to error 354
Wed Jan 19 10:18:15 2005
Errors in file /oracle/app/oracle/admin/PBWMS/bdump/pbwms_arc0_1073406.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 1701 change 0 time 01/16/2005 05:36:57
ORA-00312: online log 3 thread 1: '/oradata/PBWMS/redo03.log'
ARC0: Archiving not possible: error count exceeded
ARC0: Failed to archive log 3 thread 1 sequence 57
ARCH: Archival stopped, error occurred. Will continue retrying
Wed Jan 19 10:18:15 2005
ORACLE Instance PBWMS - Archival Error
ARCH: Connecting to console port...
Wed Jan 19 10:18:15 2005
ORA-16038: log 3 sequence# 57 cannot be archived
ORA-00354: corrupt redo log block header
ORA-00312: online log 3 thread 1: '/oradata/PBWMS/redo03.log'
ARCH: Connecting to console port...
ARCH:
Wed Jan 19 10:18:15 2005
ORA-16038: log 3 sequence# 57 cannot be archived
ORA-00354: corrupt redo log block header
ORA-00312: online log 3 thread 1: '/oradata/PBWMS/redo03.log'
Wed Jan 19 10:18:15 2005
Errors in file /oracle/app/oracle/admin/PBWMS/bdump/pbwms_arc0_1073406.trc:
ORA-16038: log 3 sequence# 57 cannot be archived
ORA-00354: corrupt redo log block header
ORA-00312: online log 3 thread 1: '/oradata/PBWMS/redo03.log'
Wed Jan 19 10:18:15 2005
Thread 1 advanced to log sequence 197
Current log# 2 seq# 197 mem# 0: /oradata/PBWMS/redo02.log
Wed Jan 19 10:18:15 2005
ARC1: Evaluating archive log 3 thread 1 sequence 57
ARC1: Beginning to archive log 3 thread 1 sequence 57
Creating archive destination LOG_ARCHIVE_DEST_1: '/oradata/ARCH/arch_57.arc'
ARC1: Log corruption near block 1701 change 0 time ?
ARC1: All Archive destinations made inactive due to error 354
Wed Jan 19 10:18:15 2005
Errors in file /oracle/app/oracle/admin/PBWMS/bdump/pbwms_arc1_835674.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 1701 change 0 time 01/16/2005 05:36:57
ORA-00312: online log 3 thread 1: '/oradata/PBWMS/redo03.log'
ARC1: Archiving not possible: error count exceeded
ARC1: Failed to archive log 3 thread 1 sequence 57
Wed Jan 19 10:18:15 2005
Errors in file /oracle/app/oracle/admin/PBWMS/bdump/pbwms_arc1_835674.trc:
ORA-16038: log 3 sequence# 57 cannot be archived
ORA-00354: corrupt redo log block header
ORA-00312: online log 3 thread 1: '/oradata/PBWMS/redo03.log'
Wed Jan 19 10:18:38 2005
ARC0: Evaluating archive log 3 thread 1 sequence 57
ARC0: Beginning to archive log 3 thread 1 sequence 57
Creating archive destination LOG_ARCHIVE_DEST_1: '/oradata/ARCH/arch_57.arc'
ARC0: Log corruption near block 1701 change 0 time ?
ARC0: All Archive destinations made inactive due to error 354
Wed Jan 19 10:18:39 2005
Errors in file /oracle/app/oracle/admin/PBWMS/bdump/pbwms_arc0_1073406.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 1701 change 0 time 01/16/2005 05:36:57
ORA-00312: online log 3 thread 1: '/oradata/PBWMS/redo03.log'
ARC0: Archiving not possible: error count exceeded
ARC0: Failed to archive log 3 thread 1 sequence 57
Wed Jan 19 10:18:39 2005
Errors in file /oracle/app/oracle/admin/PBWMS/bdump/pbwms_arc0_1073406.trc:
ORA-16038: log 3 sequence# 57 cannot be archived
ORA-00354: corrupt redo log block header
ORA-00312: online log 3 thread 1: '/oradata/PBWMS/redo03.log'

이 글에 대한 댓글이 총 3건 있습니다.

실례합니다. 저도 배우는 입장이라 적절한 답변을 해드리지 못해 죄송합니다만, 질문은 질문게시판에 해주시기 바랍니다.. :)

정호용(egnes)님이 2005-01-19 13:02에 작성한 댓글입니다.

위와 같은 문제는 로그만 보고 알 수가 없습니다.

 

기술지원업체 부르시기 바랍니다.

 

http://www.kova.co.kr

김주현님이 2005-01-19 14:42에 작성한 댓글입니다.
이 댓글은 2005-01-19 14:44에 마지막으로 수정되었습니다. Edit

 

needs cancel-based recovery
지나가다님이 2005-01-21 17:45에 작성한 댓글입니다. Edit
[Top]
No.
제목
작성자
작성일
조회
21478널과 ''의 구분?
dba
2005-01-19
1267
21477게시판 쿼리 속도가 너무 느린데요.. [2]
김태우
2005-01-19
1696
21476exp/imp 시 문제 발생 [1]
글쓴이
2005-01-19
1604
21475아카이브 로그 생성시 발생한 오류 해결방법 좀 알려주세요~ [3]
김태진
2005-01-19
2538
21474JDBC thin연결시 한글깨짐.. [3]
이동식
2005-01-19
6813
21473union all 과 나누어 쿼리 실행했을 경우의 속도 차이??
곰두리아빠
2005-01-19
1697
21472자원반환이 안되요. Oracle Server 오작동??? [1]
서지수
2005-01-19
997
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.023초, 이곳 서비스는
	PostgreSQL v16.2로 자료를 관리합니다