好得很程序员自学网

<tfoot draggable='sEl'></tfoot>

ORA-16446: Target database was not a standby database ORACLE 报错

文档解释

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复制功能,确保目标数据库不是备份数据库的错误可以被解决。

查看更多关于ORA-16446: Target database was not a standby database ORACLE 报错的详细内容...

  阅读:15次