Running "alter System Flush Redo To Standby_db" Failed With ORA-16474
(Doc ID 2842457.1)
Last updated on APRIL 29, 2022
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
SQL> ALTER SYSTEM FLUSH REDO TO <STANDBY>;
ALTER SYSTEM FLUSH REDO TO <STANDBY>
ERROR at line 1:
ORA-16474: target_db_name not found in the LOG_ARCHIVE_DEST_n parameter
While trying to perform failover to standby if primary database can be mounted, it may be possible to flush any unsent archived and current redo from the primary database to the standby database. The error is triggered while trying to perform flush redo to target standby.
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