How to fix the Oracle error ORA-16447: Redo apply was not active at the target standby database?

In this post, you’ll learn more about the Oracle ErrorORA-16447: Redo apply was not active at the target standby database with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-16447: Redo apply was not active at the target standby database

Reason for the Error ORA-16447: Redo apply was not active at the target standby database

ALTER SYSTEM FLUSH REDO TO STANDBY failed because redo apply is not active at the target database.

How to fix the Error ORA-16447: Redo apply was not active at the target standby database ?

You can fix this error in Oracle by following the below steps

Start redo apply at the standby database and reissue the ALTER SYSTEM FLUSH REDO TO STANDBY statement, or reissue the ALTER SYSTEM FLUSH REDO TO STANDBY statement with the NO CONFIRM APPLY clause.