Apply Logical Standby Database failed with LOGMINER: Error 308 encountered, failed to read logfile
Last updated on APRIL 18, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
Primary and Logical Standby database are at 22.214.171.124
1) When started logical apply on standby side, it says in the alert.log file that it is waiting for a log :
On primary Db side :
*** 2011-10-09 07:51:17.760
Log read is SYNCHRONOUS though disk_asynch_io is enabled!
2) the archive logs from primary database are properly sent to standby location, but SQL APPLY doesn't apply anything and so it doesn't erase applied redo logs.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms