How to resolve ORA:00328 in a standby database (Doc ID 864364.1)

Last updated on APRIL 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 to 12.1.0.2 [Release 9.0.1 to 12.1]
Information in this document applies to any platform.
*** Reviewed the relevance on Mar. 05, 2013 ***
***Reviewed for relevance on 13-Jul-2015***

Goal

This document resolves the GAP detected with ORA:00328


-In standby alert log file the error appears like following Example:

Media Recovery Log /orad/06/oraarch/gfprod/gfprod_599598174123059.log
Errors with log /orad/06/oraarch/gfprod/gfprod_599598174123059.log
MRP0: Background Media Recovery terminated with error 328
Sun Jul 12 14:41:51 2009
Errors in file /orad/01/app/oracle/admin/gfprod/bdump/gfprod_mrp0_1766.trc:
ORA-00328: archived log ends at change 3638015488, need later change 3638015490
ORA-00334: archived log: '/orad/06/oraarch/gfprod/gfprod_599598174123059.log'
Recovery interrupted!




Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms