Physical Standby Database Failover(三)
查看最初的是NOT ALLOWED，切换后变成了FAILED DESTINATION，但数据库可以write并且是primary的了。
重启数据库：
SQL> startup force
ORACLE instance started.
Total System Global Area 943669248 bytes
Fixed Size 2234000 bytes
Variable Size 264243568 bytes
Database Buffers 671088640 bytes
Redo Buffers 6103040 bytes
Database mounted.
Database opened.
SQL> select status from v$instance;
STATUS
------------
OPEN
查看alert日志：
Fri Jul 12 14:05:14 2013
PING[ARC5]: Heartbeat failed to connect to standby 'beijing'. Error is 16009.
PING[ARC5]: Heartbeat failed to connect to standby 'beijing'. Error is 16009.
PING[ARC5]: Heartbeat failed to connect to standby 'beijing'. Error is 16009.
Fri Jul 12 14:06:14 2013
PING[ARC5]: Heartbeat failed to connect to standby 'beijing'. Error is 16009.
PING[ARC5]: Heartbeat failed to connect to standby 'beijing'. Error is 16009.
出现大量的ORA-16009错误，它不断的去尝试连接beijing这个standby database，由于我做的是failover，此时standby是关闭的。
SQL> show parameter log_archive_dest_2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string SERVICE=beijing ASYNC VALID_FO
R=(ONLINE_LOGFILES,PRIMARY_ROL
E) DB_UNIQUE_NAME=beijing
SQL> alter system set log_archive_dest_2='' scope=spfile;
System altered.
SQL> startup force
SQL> show parameter log_archive_dest_2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string
取消远程归档路径，错误消除。