Wed Oct 21 15:20:49 2015

MRP0: Background Media Recovery process shutdown (vlifesb)

Managed Standby Recovery Canceled (vlifesb)

Completed: alter database recover managed standby database cancel

如果此时再中断监听器，中断连接。此时数据库不能做到实时同步。

[oracle@vLIFE-URE-OT-DB-STANDBY ~]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 21-OCT-2015 15:24:17

Copyright (c) 1991, 2013, Oracle.? All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))

The command completed successfully

--主库

***********************************************************************

Fatal NI connect error 12541, connecting to:

?(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.19.90)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=vlifesb)(CID=(PROGRAM=oracle)(HOST=vLIFE-URE-OT-DB-PRIMARY)(USER=oracle))))

? VERSION INFORMATION:

? ? ? ? TNS for Linux: Version 11.2.0.4.0 - Production

? ? ? ? TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production

? Time: 21-OCT-2015 15:24:38

? Tracing not turned on.

? Tns error struct:

? ? ns main err code: 12541

? ?

TNS-12541: TNS:no listener

? ? ns secondary err code: 12560

? ? nt main err code: 511

? ?

TNS-00511: No listener

? ? nt secondary err code: 111

? ? nt OS err code: 0

Error 12541 received logging on to the standby

Check whether the listener is up and running.

PING[ARC2]: Heartbeat failed to connect to standby 'vlifesb'. Error is 12541.

强制日志切换。

SQL> alter system switch logfile;

System altered

SQL> alter system switch logfile;

System altered

SQL> alter system switch logfile;

System altered

SQL> select * from v$archive_dest_status;

? DEST_ID DEST_NAME? ? ? ? ? ? STATUS? ? TYPE? ? ? ? ? DATABASE_MODE? RECOVERY_MODE? ? ? ? ? PROTECTION_MODE? ? ? DESTINATION? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? STANDBY_LOGFILE_COUNT STANDBY_LOGFILE_ACTIVE ARCHIVED_THREAD# ARCHIVED_SEQ# APPLIED_THREAD# APPLIED_SEQ# ERROR? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? SRL DB_UNIQUE_NAME? ? ? ? ? ? ? ? SYNCHRONIZATION_STATUS SYNCHRONIZED GAP_STATUS

---------- -------------------- --------- -------------- --------------- ----------------------- -------------------- -------------------------------------------------------------------------------- --------------------- ---------------------- ---------------- ------------- --------------- ------------ -------------------------------------------------------------------------------- --- ------------------------------ ---------------------- ------------ ------------------------

? ? ? ? 1 LOG_ARCHIVE_DEST_1? VALID? ? LOCAL? ? ? ? ? OPEN? ? ? ? ? ? IDLE? ? ? ? ? ? ? ? ? ? MAXIMUM PERFORMANCE? /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 0? ? ? ? ? ? ? ? ? ? ? 0? ? ? ? ? ? ? ? 1? ? ? ? ? ? 85? ? ? ? ? ? ? 0? ? ? ? ? ? 0? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? NO? NONE? ? ? ? ? ? ? ? ? ? ? ? ? CHECK CONFIGURATION? ? NO? ? ? ? ? ?

? ? ? ? 2 LOG_ARCHIVE_DEST_2? ERROR? ? PHYSICAL? ? ? OPEN_READ-ONLY? IDLE? ? ? ? ? ? ? ? ? ? RESYNCHRONIZATION? ? vlifesb? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 3? ? ? ? ? ? ? ? ? ? ? 0? ? ? ? ? ? ? ? 1? ? ? ? ? ? 82? ? ? ? ? ? ? 1? ? ? ? ? 82 ORA-12541: TNS: ???à?????ò? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? YES vlifesb? ? ? ? ? ? ? ? ? ? ? ? CHECK CONNECTIVITY? ? NO? ? ? ? ? RESOLVABLE GAP

SQL> select recid, name, sequence# from v$archived_log where sequence#>82;

? ? RECID NAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? SEQUENCE#