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 21468 게시물 읽기
No. 21468
아카이브로그 생성시 발생하는 오류 해결 방법 좀 알려주세요~
작성자
김태진(pinblue)
작성일
2005-01-19 11:22
조회수
3,823

오라클에서 아카이브로그 파일을 생성시 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'

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

redo log file 에 corruption 이 발생한거 같네요...

 

current redo logfile 인 경우 아주 심각한 상태입니다.

 

 불완전 복원을 해야 하는 경우가 발생되므로, 리두 로그화일의

 상태 및 current 나 active 한 redo log 화일인지 아니면

 inactive 상태의 이미 archiving 된 상태인지를 확인하시고

 

 복원및 재 생성등에 대한 결정을 내리셔야 할거 같습니다.

 

 수고하세요...

나그네님이 2005-01-19 11:51에 작성한 댓글입니다. Edit

아래와 같이 조회해 보면 current log file은 아닌데요

그렇다면 어떻게 복구해야 하나요?

 

SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
         1          1        212  104857600          1 NO  INACTIVE
   1391930492 19-JAN-05

         2          1        213  104857600          1 NO  CURRENT
   1392027119 19-JAN-05

         3          1         57  104857600          1 NO  INACTIVE
   1385890291 16-JAN-05

김태진(pinblue)님이 2005-01-19 14:11에 작성한 댓글입니다.

다행이군요... 그렇다면 간단합니다.

 

 먼저

 

 select * from v$recover_file 로 조회 해 본후

 화일이 나타 날겁니다.

 

 그럼 해당 redo log file 이 current 가 아니기 때문에

 drop 하시고 다시 recreate 하시면 됩니다.

 

 수고하세요..

나그네님이 2005-01-19 14:44에 작성한 댓글입니다. Edit

답변 감사드립니다. 그런데,

select * from v$recover_file 해보니 쿼리 결과가 없습니다.

허면 어떡하죠?

김태진(pinblue)님이 2005-01-19 17:18에 작성한 댓글입니다.
이 댓글은 2005-01-19 17:19에 마지막으로 수정되었습니다.
[Top]
No.
제목
작성자
작성일
조회
21471이런것도 쿼리문이 가능할까요? [1]
궁금이
2005-01-19
1121
21470tns가 작동중단중입니다....에러입니다... [1]
김영
2005-01-19
1778
214692가지의 쿼리중 어떤 쿼리가[고수님들 답변부탁..]
김경한
2005-01-19
1138
21468아카이브로그 생성시 발생하는 오류 해결 방법 좀 알려주세요~ [4]
김태진
2005-01-19
3823
21467클라이언트 배포 시 레지스트리 설정....아 미치겠슴다... [1]
시인
2005-01-19
3188
21466OCI-22060 오류에 대해서 [1]
정덕진
2005-01-19
2766
214658.1.6에서 오라클 서비스가 "시작하는중"으로 나옵니다. 패치는 어떻게? [4]
정말급한이
2005-01-18
2684
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.021초, 이곳 서비스는
	PostgreSQL v16.2로 자료를 관리합니다