FAILED DESTINATION

65 阅读 0 评论 43 点赞

我是靠谱客的博主大意石头，最近开发中收集的这篇文章主要介绍FAILED DESTINATION，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

SQL> select * from v$version where rownum<2;

BANNER
--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

primary：
SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
--------------------
FAILED DESTINATION

standby：
SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
--------------------
NOT ALLOWED----这个状态没有问题，有问题是主库的状态！

此时查看主库上的alter日志：
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
Errors in file /home/oracle/app/diag/rdbms/oral1/oral1/trace/oral1_arc2_1977.trc:
ORA-16191: Primary log shipping client not logged on standby
PING[ARC2]: Heartbeat failed to connect to standby 'standby'. Error is 16191.
Fri May 11 18:46:12 2012
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
Errors in file /home/oracle/app/diag/rdbms/oral1/oral1/trace/oral1_arc2_1977.trc:
ORA-16191: Primary log shipping client not logged on standby
PING[ARC2]: Heartbeat failed to connect to standby 'standby'. Error is 16191.
Fri May 11 18:52:12 2012
Error 1017 received logging on to the standby

基本断定是密码文件的问题

将主库的密码文件scp到备库上，过一会发现
Fri May 11 19:04:16 2012
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
Fri May 11 19:04:16 2012
Thread 1 advanced to log sequence 103 (LGWR switch)
Current log# 1 seq# 103 mem# 0: /home/oracle/app/oradata/oral1/redo01.log
Fri May 11 19:04:17 2012
Archived Log entry 57 added for thread 1 sequence 102 ID 0x3322c01c dest 1:
日志正常，在此记录一下