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#
---------- -------------------------------------------------------------------------------- ----------
108 vlifesb 83
109 /u01/app/oracle/fast_recovery_area/VLIFE/archivelog/2015_10_21/o1_mf_1_83_c2ghkz 83
110 /u01/app/oracle/fast_recovery_area/VLIFE/archivelog/2015_10_21/o1_mf_1_84_c2ghl0 84
111 /u01/app/oracle/fast_recovery_area/VLIFE/archivelog/2015_10_21/o1_mf_1_85_c2ghl4 85
而standby端,归档日志就没有传输到。
SQL> select recid, name, sequence# from v$archived_log where sequence#>82;
RECID NAME SEQUENCE#
---------- -------------------------------------------------------------------------------- ----------
79 /u01/app/oracle/fast_recovery_area/VLIFESB/archivelog/2015_10_21/o1_mf_1_83_c2gh 83
SQL> select group#, dbid, archived from v$standby_log;
GROUP# DBID ARCHIVED
---------- ---------------------------------------- --------
4 UNASSIGNED NO
5 UNASSIGNED NO
6 UNASSIGNED YES
此时,Primary和Standby的连接明显被中断,日志不能传送,也就达不到同步确认的设置要求。但是此时,Primary还是可以进行事务操作。
(事务可以进行)
SQL> insert into t_m select * from dba_objects where rownum<10;
9 rows inserted
SQL> commit;
Commit complete
此时,如果恢复两者连接,启动监听器和日志应用。
[oracle@vLIFE-URE-OT-DB-STANDBY ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 21-OCT-2015 15:51:46
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to
(篇幅原因,有省略…….)
SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered
之后主库和从库日志上进行归档日志传输和后续同步动作,篇幅原因,日志信息省略。