We're here to help!

Standby Archive apply reports error ORA-00354

Follow

Read our docs This article explains how to resolve archive apply error in standby when we get ORA-00354 error.

Problem Details

Problem Statement

Archive apply fails with error 

Applicable Error Code

Dbvisit Standby terminated...
Error Code: 2001
ORA-00354: corrupt redo log block header

Affected Versions

Noticed in DB version 11.2.0.4 , Noticed in standby version 8.0 (But independent of both)

Affected Platforms

Noticed in Windows.

 
Description

 Archive apply fails in the standby, Below is the full error.


C:\Program Files\Dbvisit\Standby>dbvctl -d TEST 
============================================================= 
Dbvisit Standby Database Technology (8.0.10.18545) (pid 5568) 
dbvctl started on dbvlab03: Fri May 5 16:11:42 2017 
=============================================================

>>> Applying Log file(s) from dbvlab01 to testdb on dbvlab03:

Dbvisit Standby terminated... 
Error Code: 2001 
ORA-00354: corrupt redo log block header

Tracefile from server: dbvlab03 (PID:5568) 
5568_dbvctl_TEST_201705051611.trc
Solution

#1. Try re-sending the archivelog from the primary using the below command

dbvctl -d <ddc> -r <corrupted archlog> -t 1 (Version 8.0)
dbvisit -r <SEQUENCE_NUMBER> <DDC> (Version 7.0)
dbvctl -d TEST -r 4567 -t 1 

#2. Try applying the archivelogs in the standby.

dbvctl -d TEST (Version 8.0)
dbvisit TEST (Version 7.0)

#3. If the above does not work, you can synchronize the standby to make the database in sync with the primary and continue with archive send and apply. Before running the synchronize make sure your schedules are disabled.

https://dbvisit.atlassian.net/wiki/display/DS8QSG/The+Synchronise+Standby+Database+Option (Version 8.0)

https://dbvisit.atlassian.net/wiki/display/UGDS7/Synchronize+a+Standby+Database  (Version 7.0)

Have more questions? Submit a request

Comments