ORA-16446: Target database was not a standby database

文档解释

ORA-16446: Target database was not a standby database

Cause: ALTER SYSTEM FLUSH REDO TO STANDBY failed because the target database is not a standby database.

Action: Reissue the ALTER SYSTEM FLUSH REDO TO STANDBY statement and specify a standby database as the target database.

等

官方解释

常见案例

一般处理方法及步骤

1.首先检查原实例的FRA配置。

SQL> show parameter db_recovery_file_dest;

2.如果没有开启配置，应该先开启，指定好历史归档日志等设置：

SQL> ALTER SYSTEM SET db_recovery_file_dest=’/u01/oradata/fra’;

3.然后再设置原实例为备份数据库：

SQL> RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

4.再次运行RMAN复制功能，确保目标数据库不是备份数据库的错误可以被解决。