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:

日志正常，在此记录一下