Redo log shipping getting Failed With Error ORA-16086
(Doc ID 2829253.1)
Last updated on FEBRUARY 02, 2022
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 21.4 [Release 10.2 to 21.0]
Information in this document applies to any platform.
Either of the below symptoms will apply
- The error column in v$archive_dest at Primary Database reports ORA-16086, for the destinations used by Standby Database.
- Standby redo logs not being used, even though they are created with same size as that of primary. You will see below errors in standby alert log.
RFS: No standby redo logfiles available for T-1
RFS: No standby redo logfiles selected (reason:7)
Errors in file <path of the rfs trace file>:
ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 10 thread 1: '< Path of the Standby Redo log file>'
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document