Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00354: corrupt redo log block header

634663Apr 17 2008 — edited May 9 2008
Hi,

I have setup DR for Oracle 9.2.0.1.0 ,but frequently I am getting these error in standby alert log file .
Please help me out , Why I m getting these error.


Thu Apr 17 16:41:04 2008
ORA-16038: log 5 sequence# 12698 cannot be archived
ORA-00354: corrupt redo log block header
ORA-00312: online log 5 thread 1: 'H:\ORADATA\EXLWFMDR\REDO05.LOG'

Thu Apr 17 16:41:04 2008
Errors in file c:\oracle\admin\exlwfmdr\bdump\exlwfmdr_arc1_4480.trc:
ORA-16038: log 5 sequence# 12698 cannot be archived
ORA-00354: corrupt redo log block header
ORA-00312: online log 5 thread 1: 'H:\ORADATA\EXLWFMDR\REDO05.LOG'

Thu Apr 17 16:41:07 2008
RFS: Standby redo log 4 thread 1 sequence 12697 is being archived
RFS: Successfully opened standby logfile 5: 'H:\ORADATA\EXLWFMDR\REDO05.LOG'
Thu Apr 17 16:42:23 2008
Archiver process freed from errors. No longer stopped
Thu Apr 17 16:42:57 2008
ARC0: Evaluating archive log 5 thread 1 sequence 12699
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive log 5 thread 1 sequence 12699
ARCH: Archival stopped, error occurred. Will continue retrying
ARCH:
Thu Apr 17 16:42:57 2008
ORA-16014: log 5 sequence# 12699 not archived, no available destinations
ORA-00312: online log 5 thread 1: 'H:\ORADATA\EXLWFMDR\REDO05.LOG'

Thu Apr 17 16:42:57 2008
Errors in file c:\oracle\admin\exlwfmdr\bdump\exlwfmdr_arc0_5704.trc:
ORA-16014: log 5 sequence# 12699 not archived, no available destinations
ORA-00312: online log 5 thread 1: 'H:\ORADATA\EXLWFMDR\REDO05.LOG'

Thu Apr 17 16:43:01 2008
RFS: Standby redo log 4 thread 1 sequence 12697 is being archived
RFS: Clearing standby logfile 5 thread 1 sequence 12699 controlfile info
RFS: Successfully opened standby logfile 5: 'H:\ORADATA\EXLWFMDR\REDO05.LOG'
Thu Apr 17 16:47:30 2008
Archiver process freed from errors. No longer stopped
ARC1: Evaluating archive log 5 thread 1 sequence 12700
ARC1: Beginning to archive log 5 thread 1 sequence 12700
Creating archive destination LOG_ARCHIVE_DEST_1: 'H:\ECSDR_ARCHIVE\ARC12700.001'
ARC1: Log corruption near block 49261 change 0 time ?
ARC1: All Archive destinations made inactive due to error 354
Thu Apr 17 16:49:38 2008
Errors in file c:\oracle\admin\exlwfmdr\bdump\exlwfmdr_arc1_4480.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 49261 change 0 time 04/17/2008 16:43:08
ORA-00312: online log 5 thread 1: 'H:\ORADATA\EXLWFMDR\REDO05.LOG'

ARC1: Archiving not possible: error count exceeded
ARC1: Failed to archive log 5 thread 1 sequence 12700
Clearing standby logfile 5 thread 1 sequence 12700 due to error 354
ARCH: Archival stopped, error occurred. Will continue retrying
ARCH:
Thu Apr 17 16:49:38 2008
ORA-16038: log 5 sequence# 12700 cannot be archived
ORA-00354: corrupt redo log block header
ORA-00312: online log 5 thread 1: 'H:\ORADATA\EXLWFMDR\REDO05.LOG'

Thu Apr 17 16:49:38 2008
Errors in file c:\oracle\admin\exlwfmdr\bdump\exlwfmdr_arc1_4480.trc:
ORA-16038: log 5 sequence# 12700 cannot be archived
ORA-00354: corrupt redo log block header
ORA-00312: online log 5 thread 1: 'H:\ORADATA\EXLWFMDR\REDO05.LOG'

Thu Apr 17 16:49:41 2008
RFS: Standby redo log 4 thread 1 sequence 12697 is being archived
RFS: Successfully opened standby logfile 5: 'H:\ORADATA\EXLWFMDR\REDO05.LOG'
Thu Apr 17 16:52:34 2008
Archiver process freed from errors. No longer stopped
Thu Apr 17 18:17:50 2008
RFS: Possible network disconnect with primary database
Thu Apr 17 18:18:00 2008
Fetching gap sequence for thread 1, gap sequence 12697-12697
Trying FAL server: EXLWFM
Media Recovery Log H:\ECSDR_ARCHIVE\ARC12697.001
Media Recovery Log H:\ECSDR_ARCHIVE\ARC12698.001
Media Recovery Log H:\ECSDR_ARCHIVE\ARC12699.001
Media Recovery Log H:\ECSDR_ARCHIVE\ARC12700.001
Media Recovery Waiting for thread 1 seq# 12701 (in transit)
Thu Apr 17 18:56:05 2008
ARC0: Evaluating archive log 5 thread 1 sequence 12701
ARC0: Beginning to archive log 5 thread 1 sequence 12701
Thu Apr 17 18:56:05 2008
RFS: Successfully opened standby logfile 4: 'H:\ORADATA\EXLWFMDR\REDO04.LOG'
Thu Apr 17 18:56:05 2008
Creating archive destination LOG_ARCHIVE_DEST_1: 'H:\ECSDR_ARCHIVE\ARC12701.001'
ARC0: Completed archiving log 5 thread 1 sequence 12701
Thu Apr 17 18:56:17 2008
Media Recovery Log H:\ECSDR_ARCHIVE\ARC12701.001
Media Recovery Waiting for thread 1 seq# 12702 (in transit)

Thanks
ashu
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2008
Added on Apr 17 2008
2 comments
5,135 views