Running "alter System Flush Redo To Standby_db" Failed With ORA-16474 (Doc ID 2842457.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

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

Changes

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.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.