My Oracle Support Banner

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 19.10.0.0.0 and later
Information in this document applies to any platform.

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

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
Symptoms
Changes
Cause
Solution
References


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