Database Administration (MOSC)

MOSC Banner

How a archive log file show corrupted in standby database but good in primary DB?

edited Sep 19, 2017 5:05AM in Database Administration (MOSC) 3 commentsAnswered

Hi every one,

I got two physical standby database , this morning both SBY DB report corrupted archive log and not to apply it,

I ran "Alter system dump logfile 'archivelog/1_45090_917855049.arc'; in all three DB, the primary return no error but both SBY return

--------------------

ORA-00354: corrupt redo log block header

ORA-00353: log corruption near block 5640 change 1218586842 time 08/31/2017

20:39:45

ORA-00334: archived log:

-------------------

Then I ran md5sum on all three log file in corresponding system all return same value, so I assume these 3 files are identical.

Any possible reason both SBY are check as error?

Any help is much appreciated.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center