Oracle 11g Data Guard Error 16143 Heartbeat failed to connect to standby 处理方法
第4页_数据库技术_Linux公社-Linux系统门户网站
你好，游客
Oracle 11g Data Guard Error 16143 Heartbeat failed to connect to standby 处理方法
来源：blog.csdn.net/tianlesoftware&
作者：Dave
2.9 查看主备库日志
主库日志：
Fri Mar 29 08:00:51 2013
PING[ARC1]: Heartbeat failed to connect tostandby 'dave_st'. Error is 16143.
Fri Mar 29 08:01:52 2013
Error 1034 received logging on to thestandby
PING[ARC1]: Heartbeat failed to connect tostandby 'dave_st'. Error is 1034.
Fri Mar 29 08:02:56 2013
Error 1034 received logging on to thestandby
PING[ARC1]: Heartbeat failed to connect tostandby 'dave_st'. Error is 1034.
Fri Mar 29 08:03:57 2013
Error 1034 received logging on to thestandby
PING[ARC1]: Heartbeat failed to connect tostandby 'dave_st'. Error is 1034.
Fri Mar 29 08:04:59 2013
Error 1034 received logging on to the standby
PING[ARC1]: Heartbeat failed to connect tostandby 'dave_st'. Error is 1034.
Fri Mar 29 08:06:02 2013
Error 1034 received logging on to thestandby
PING[ARC1]: Heartbeat failed to connect tostandby 'dave_st'. Error is 1034.
Fri Mar 29 08:07:05 2013
Error 1034 received logging on to thestandby
PING[ARC1]: Heartbeat failed to connect tostandby 'dave_st'. Error is 1034.
Fri Mar 29 08:08:08 2013
PING[ARC1]: Heartbeat failed to connect tostandby 'dave_st'. Error is 16058.
Fri Mar 29 08:08:34 2013
ALTER SYSTEM SETlog_archive_dest_state_2='ENABLE' SCOPE=MEMORY SID='*';
Fri Mar 29 08:08:35 2013
Thread 1 advanced to log sequence 18 (LGWRswitch)
Current log# 3 seq# 18 mem# 0: /u01/app//oradata/dave/redo03.log
Fri Mar 29 08:08:36 2013
******************************************************************
LGWR: Setting 'active'archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
Fri Mar 29 08:08:36 2013
Archived Log entry 23added for thread 1 sequence 17 ID 0x dest 1:
备库日志：
[oracle@dg2 trace]$ tail -20 alert_dave.log
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file ordirectory
Additional information: 3
Clearing online redo logfile 3 complete
Media Recovery Waiting for thread 1sequence 15
Fetching gap sequence in thread 1, gapsequence 15-16
Fri Mar 29 08:08:48 2013
RFS[3]: Assigned to RFS process 9707
RFS[3]: Opened log for thread 1 sequence 16dbid
Fri Mar 29 08:08:49 2013
RFS[4]: Assigned to RFS process 9705
RFS[4]: Opened log for thread 1 sequence 15dbid
Archived Log entry 2 added for thread 1sequence 16 rlc
ID 0x dest 2:
Archived Log entry 3 added for thread 1sequence 15 rlc
ID 0x dest 2:
Fri Mar 29 08:08:55 2013
Media Recovery Log/u01/archivelog/1_15_.dbf
Media Recovery Log/u01/archivelog/1_16_.dbf
Media Recovery Log/u01/archivelog/1_17_.dbf
Fri Mar 29 08:09:11 2013
Media Recovery Waitingfor thread 1 sequence 18 (in transit)
注意这里：
我们把备库拉起来之后，就自动开始同步了。4
相关资讯 & & &
& (08月24日)
& (08月12日)
& (09月14日)
& (08月19日)
& (08月06日)
图片资讯 & & &
　　　同意评论声明
　　　发表
尊重网上道德，遵守中华人民共和国的各项有关法律法规
承担一切因您的行为而直接或间接导致的民事或刑事法律责任
本站管理人员有权保留或删除其管辖留言中的任意内容
本站有权在网站内转载或引用您的评论
参与本评论即表明您已经阅读并接受上述条款1950人阅读
RAC (双节点） + 单实例 DATAGUARD 安装遇到的问题处理
PRIMARY:& RAC 双节点 ，存储：ASM
STANDBY: 单实例&&&&&&&&& 存储： ASM
单实例& 数据库如果要使用 ASM存储，也要安装一个GRID,选项为：
【】为独立服务器配置ORACLE GRID INFRASTRUCTURE
其它和安装GRID RAC一致。
安装时，也要选择一个VotingDISK。
完成后状态如下：
[grid@dg1 ~]$ crs_stat -t
Name&&&&&&&&&& Type&&&&&&&&&& Target&&& State&&&& Host&&&&&&&
------------------------------------------------------------
ora.CRS.dg&&&& ora....up.type ONLINE&&& ONLINE&&& dg1&&&&&&&&
ora.DATA.dg&&& ora....up.type ONLINE&&& ONLINE&&& dg1&&&&&&&&
ora....ER.lsnr ora....er.type ONLINE&&& ONLINE&&& dg1&&&&&&&&
ora....VERY.dg ora....up.type ONLINE&&& ONLINE&&& dg1&&&&&&&&
ora.asm&&&&&&& ora.asm.type&& ONLINE&&& ONLINE&&& dg1&&&&&&&&
ora.cssd&&&&&& ora.cssd.type& ONLINE&&& ONLINE&&& dg1&&&&&&&&
ora.diskmon&&& ora....on.type OFFLINE&& OFFLINE&&&&&&&&&&&&&&
ora.evmd&&&&&& ora.evm.type&& ONLINE&&& ONLINE&&& dg1&&&&&&&&
ora.ons&&&&&&& ora.ons.type&& OFFLINE&& OFFLINE&&&&&&&&&&&&&&
[grid@dg1 ~]$
以下是安装时遇到的问题及解决方法，这里写出与大家分享，如果有更好的思路及解决方法，也请回贴告之。
1.GRID 安装
【】为独立服务器配置ORACLE GRID INFRASTRUCTURE
[grid@dg1 admin]$ crs_stat -t
Name&&&&&&&&&& Type&&&&&&&&&& Target&&& State&&&& Host&&&&&&&
------------------------------------------------------------
ora.CRS.dg&&&& ora....up.type ONLINE&&& ONLINE&&& localhost&&
ora.DATA.dg&&& ora....up.type ONLINE&&& ONLINE&&& localhost&&
ora....ER.lsnr ora....er.type OFFLINE&& OFFLINE&&&&&&&&&&&&&&
ora....VERY.dg ora....up.type ONLINE&&& ONLINE&&& localhost&&
ora.asm&&&&&&& ora.asm.type&& ONLINE&&& ONLINE&&& localhost&&
ora.cssd&&&&&& ora.cssd.type& ONLINE&&& ONLINE&&& localhost&&
ora.diskmon&&& ora....on.type OFFLINE&& OFFLINE&&&&&&&&&&&&&&
ora.evmd&&&&&& ora.evm.type&& ONLINE&&& ONLINE&&& localhost&&
ora.ons&&&&&&& ora.ons.type&& OFFLINE&& OFFLINE&&&
看到HOST 为 localhost。可能是在安装GRID前，没有修改HOSTNAME而引起的。
后面在进行数据复制（duplicate）时，既然提示无法找到ASM ，数据复制不过去。
2.重装后， 少了ASM,如下：
[grid@dg1 ~]$ crs_stat -t
Name&&&&&&&&&& Type&&&&&&&&&& Target&&& State&&&& Host&&&&&&&
------------------------------------------------------------
ora....ER.lsnr ora....er.type ONLINE&&& ONLINE&&& dg1&&&&&&&&
ora.cssd&&&&&& ora.cssd.type& ONLINE&&& ONLINE&&& dg1&&&&&&&&
ora.diskmon&&& ora....on.type OFFLINE&& OFFLINE&&&&&&&&&&&&&&
ora.evmd&&&&&& ora.evm.type&& ONLINE&&& ONLINE&&& dg1&&&&&&&&
ora.ons&&&&&&& ora.ons.type&& OFFLINE&& OFFLINE&&&&&&
怀疑是删除重装引起的。后来使用GRID的deinstall 卸载后，再进行安装，问题解决。
3.RMAN 数据复制（duplicate）时出错，如下：
开始找不到是什么原因，使用dbca建立一个新库，没有问题。说明不是ASM的问题了。
alert_stbdb.log 还有无法打开+DATA 目录下的文件的错误提示。
后来想到可能是RMAN 是在STANDBY 服务器端执行的原因。到PRIMARY服务器端执行，问题没有了。
RMAN& duplicate target database for standby from active data
Starting Duplicate Db at
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=9031 device type=DISK
contents of Memory Script:
&& backup as copy reuse
&& targetfile& '/opt/app/oracle/product/11.2.0/dbs/orapwracdb1' auxiliary format
&'/opt/app/oracle/product/11.2.0/dbs/orapwstbdb'&& ;
executing Memory Script
Starting backup at
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=11533 instance=racdb1 device type=DISK
Finished backup at
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/21/:46
RMAN-05501: aborting duplication of target database
RMAN-06136: ORACLE error from auxiliary database: ORA-03113: end-of-file on communication channel
Process ID: 21550
Session ID: 8429 Serial number: 5
RMAN& exit
--------------alert_stbdb.log ------------------
Recovery Manager complete.
Mon Oct 21 16:25:48 2013
RFS connections have been disallowed
alter database mount standby database
NOTE: Loaded library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so
NOTE: Loaded library: System
SUCCESS: diskgroup DATA was mounted
SUCCESS: diskgroup RECOVERY was mounted
ERROR: failed to establish dependency between database stbdb and diskgroup resource ora.DATA.dg
ERROR: failed to establish dependency between database stbdb and diskgroup resource ora.RECOVERY.dg
Set as converted control file due to db_unique_name mismatch
4.PRIMARY 服务器端提示 密码文件错误。查看 log文件无法同步到standby 服务器。
想到RAC环境前几天修改过SYS的密码，后把RAC1，及RAC2节点，都执行一次修改密码。
SQL&alter user sys&
并且把rac1 重新生成密码文件：
orapwd file=/tmp/orapwracdb1.ora password=oracle force=y ignorecase=y
并把密码文件拷贝到standby 服务器端，及rac2.
问题解决。
ORACLE Instance racdb2 - Archival Error. Archiver continuing.
Tue Oct 22 10:41:10 2013
Error 1034 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'stbdb'. Error is 1034.
Tue Oct 22 10:42:10 2013
Error 1034 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'stbdb'. Error is 1034.
Tue Oct 22 10:43:10 2013
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
------------------------------------------------------------
PING[ARC2]: Heartbeat failed to connect to standby 'stbdb'. Error is 16191.
Tue Oct 22 10:44:10 2013
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.
--------------alert_stbdb.log ------------------
FAL[client, USER]: Error 12154 connecting to RACDB1,RACDB2 for fetching gap sequence
Mon Oct 21 22:14:58 2013
Error 12154 received logging on to the standby
FAL[client, USER]: Error 12154 connecting to RACDB1,RACDB2 for fetching gap sequence
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
* 以上用户言论只代表其个人观点，不代表CSDN网站的观点或立场
访问：407769次
积分：5691
积分：5691
排名：第2302名
原创：180篇
转载：77篇
评论：31条
(2)(3)(1)(2)(2)(4)(5)(3)(4)(6)(4)(2)(13)(4)(8)(5)(6)(12)(13)(5)(2)(5)(6)(6)(6)(1)(6)(4)(5)(20)(2)(4)(1)(1)(2)(1)(9)(1)(1)(3)(1)(1)(4)(1)(2)(4)(1)(1)(1)(1)(1)(1)(6)(1)(1)(6)(7)(6)(4)(3)(2)(5)(6)(7)(4)Oracle 11g Data Guard Error 16143 Heartbeat failed to connect to standby
&来源：读书人网&【读书人网()：综合教育门户网站】
Oracle 11g Data Guard Error 16143 Heartbeat failed to connect to standby处理方法一．背景说明 前段时
Oracle 11g Data Guard Error 16143 Heartbeat failed to connect to standby
处理方法&&一．背景说明&前段时间一朋友在生产库上误操作，本来他是打算重启一下DG环境，结果在备库命令执行错误。&本应该执行SQL&&ALTER&DATABASE&RECOVER&MANAGED&STANDBY&DATABASE&CANCEL;&&结果朋友执行成了如下命令：SQL&&ALTER&DATABASE&RECOVER&MANAGED&STANDBY&DATABASE&FINISH;&&中断了DG主备库的通信环境，这个finish是用来做Failover时用的。 当时让朋友在主库重新生成了一份standby controlfiles，然后copy到备库，在按正常模式启动就可以了。 &&& &&& 因为识别主备库就是通过控制文件来的，所以理论上，只需要重新生成一份standby 控制文件就可以了。& 后来朋友测试了一下，正常的拉起来了。&今天看到了当时的记录，就顺便模拟一下整个操作，顺便练练手。&&&二． 演示过程&2.1 DG 环境说明OS： Oracle Linux6.3DB： 11.2.0.3&SQL& select * from v$&BANNER--------------------------------------------Oracle Database 11g Enterprise EditionRelease 11.2.0.3.0 - 64bit ProductionPL/SQL Release 11.2.0.3.0 - ProductionCORE&&&11.2.0.3.0&&&&& ProductionTNS for Linux: Version 11.2.0.3.0 -ProductionNLSRTL Version 11.2.0.3.0 - Production&&主库：&SQL& select open_mode from v$&OPEN_MODE--------------------READ WRITE&SQL& SQL& set pagesize 200SQL& select sequence#,applied fromv$archived_log order by sequence#&&SEQUENCE# APPLIED---------- ---------&&&&&&&14 YES&&&&&&&14 NO&&&&&&&13 YES&&&&&&&13 NO&&&&&&&12 NO&&&&&&&12 YES&&&&&&&11 YES&&&&&&&11 NO&&&&&&&10 NO&&&&&&&10 YES&&&&&&&&9 YES&&&&&&&&9 NO&&&&&&&&8 NO&&&&&&&&8 YES&&&&&&&&7 YES&&&&&&&&7 NO&&&&&&&&6 YES&&&&&&&&6 NO&&&&&&&&5 NO&&&&&&&&4 NO&20 rows selected.&&备库：SQL& select open_mode from v$&OPEN_MODE--------------------MOUNTED&SQL&&&SQL& select sequence#,applied fromv$archived_log order by sequence#&&SEQUENCE# APPLIED---------- ---------&&&&&&&14 YES&&&&&&&13 YES&&&&&&&12 YES&&&&&&&11 YES&&&&&&&10 YES&&&&&&&&9 YES&& &&&&&&8 YES&&&&&&&&7 YES&&&&&&&&6 YES&9 rows selected.&&2.2 模拟故障&在备库执行如下命令：SQL& ALTER DATABASE RECOVER MANAGEDSTANDBY DATABASE FINISH; Database altered.&&2.3 查看主库 alert log&[oracle@dg1 trace]$ pwd/u01/app/oracle/diag/rdbms/dave_pd/dave/trace&[oracle@dg1 trace]$ tail -30 alert_dave.logThread 1 advanced to log sequence 14 (LGWRswitch)&Current log# 2 seq# 14 mem# 0: /u01/app/oracle/oradata/dave/redo02.logFri Mar 29 03:30:12 2013Archived Log entry 17 added for thread 1sequence 13 ID 0x dest 1:Fri Mar 29 03:30:13 2013LNS: Standby redo logfile selected forthread 1 sequence 14 for destination LOG_ARCHIVE_DEST_2Fri Mar 29 03:43:10 2013Time drift detected. Please check VKTMtrace file for more details.Fri Mar 29 04:45:31 2013Time drift detected. Please check VKTMtrace file for more details.Fri Mar 29 06:28:35 2013Time drift detected. Please check VKTMtrace file for more details.Fri Mar 29 07:08:14 2013Thread 1 advanced to log sequence 15 (LGWRswitch)&Current log# 3 seq# 15 mem# 0: /u01/app/oracle/oradata/dave/redo03.logFri Mar 29 07:08:16 2013Archived Log entry 20 added for thread 1sequence 14 ID 0x dest 1:Fri Mar 29 07:08:17 2013LNS: Standby redo logfile selected forthread 1 sequence 15 for destination LOG_ARCHIVE_DEST_2Fri Mar 29 07:34:48 2013Time drift detected. Please check VKTMtrace file for more details.Fri Mar 29 07:48:55 2013LNS: Attempting destinationLOG_ARCHIVE_DEST_2 network reconnect (3135)LNS: Destination LOG_ARCHIVE_DEST_2 networkreconnect abandonedError 3135 for archive log file 3 to'dave_st'Errors in file/u01/app/oracle/diag/rdbms/dave_pd/dave/trace/dave_nsa2_3181.trc:ORA-03135: connection lost contactLNS: Failed to archive log 3 thread 1sequence 15 (3135)Fri Mar 29 07:51:45 2013PING[ARC1]: Heartbeatfailed to connect to standby 'dave_st'. Error is 16143.&因为我们在备库执行的Finish命令，导致心跳中断了。&2.4 查看备库alert log&[oracle@dg2 trace]$ pwd/u01/app/oracle/diag/rdbms/dave_st/dave/trace&[oracle@dg2 trace]$& tail -20 alert_dave.logTerminal Recovery: thread 1 seq# 15 redorequiredTerminal Recovery: Recovery of Online Redo Log: Thread 1 Group5 Seq 15 Reading mem 0&Mem# 0: /u01/app/oracle/oradata/dave/stdbyredo02.logIdentified End-Of-Redo (failover) forthread 1 sequence 15 at SCN 0xffff.ffffffffIncomplete Recovery applied until change1082890 time 03/29/:53MRP0: Media Recovery Complete (dave)Terminal Recovery: successful completionFri Mar 29 07:48:49 2013ARCH: Archival stopped, error occurred.Will continue retryingORACLE Instance dave - Archival ErrorForcing ARSCN to IRSCN for TR 0:1082890Attempt to set limbo arscn 0:1082890 irscn0:1082890 Resetting standby activation ID x)ORA-16014: log 5 sequence# 15 not archived,no available destinationsORA-00312: online log 5 thread 1:'/u01/app/oracle/oradata/dave/stdbyredo02.log'MRP0: Background Media Recovery processshutdown (dave)Fri Mar 29 07:48:50 2013Terminal Recovery: completion detected(dave)Completed: ALTER DATABASE RECOVER MANAGEDSTANDBY DATABASE FINISH[oracle@dg2 trace]$&2.5 在主库切换归档&SQL& alter sSystem altered.&SQL& alter sSystem altered.&SQL& select sequence#,applied fromv$archived_log order by sequence#&&SEQUENCE# APPLIED---------- ---------&&&&&&&16 NO&&&&&&&15 NO&&&&&&&14 NO&&&&&&&14 YES&&&&&&&13 YES&&&&&&&13 NO&&&&&&&12 YES&&&&&&&12 NO&&&&&&&11 NO&&&&&&&11 YES&&&&&&&10 NO&&&&&&&10 YES&&&&&&&&9 YES&&&&&&&&9 NO&&&&&&&&8 YES&&&&&&&&8 NO&&& &&&&&7 YES&&&&&&&&7 NO&&&&&&&&6 NO&&&&&&&&6 YES&&&&&&&&5 NO&&&&&&&&4 NO&22 rows selected.&SQL&&2.6 再次查看主备库日志&主库日志：&Fri Mar 29 07:52:46 2013PING[ARC1]: Heartbeat failed to connect tostandby 'dave_st'. Error is 16143.Fri Mar 29 07:53:47 2013PING[ARC1]: Heartbeat failed to connect tostandby 'dave_st'. Error is 16143.Fri Mar 29 07:53:49 2013Thread 1 advanced to log sequence 16 (LGWRswitch)&Current log# 1 seq# 16 mem# 0: /u01/app/oracle/oradata/dave/redo01.logFri Mar 29 07:53:49 2013Archived Log entry 21 added for thread 1sequence 15 ID 0x dest 1:Fri Mar 29 07:53:50 2013FAL[server, ARC2]: Error 16143 creatingremote archivelog file 'dave_st'FAL[server, ARC2]: FAL archive failed, seetrace file.ARCH: FAL archive failed. ArchivercontinuingORACLE Instance dave - Archival Error.Archiver continuing.Thread 1 advanced to log sequence 17 (LGWRswitch)&Current log# 2 seq# 17 mem# 0: /u01/app/oracle/oradata/dave/redo02.logFri Mar 29 07:53:57 2013Archived Log entry 22 added for thread 1sequence 16 ID 0x dest 1:&&备库日志：&Fri Mar 29 07:48:50 2013Terminal Recovery: completion detected(dave)Completed: ALTER DATABASE RECOVER MANAGEDSTANDBY DATABASE FINISHFri Mar 29 07:51:34 2013RFS[5]: Assigned to RFS process 9336RFS[5]: No connections allowed during/afterterminal recovery.Fri Mar 29 07:52:35 2013RFS[6]: Assigned to RFS process 9340RFS[6]: No connections allowed during/afterterminal recovery.Fri Mar 29 07:53:36 2013RFS[7]: Assigned to RFS process 9343RFS[7]: No connections allowed during/afterterminal recovery.Fri Mar 29 07:53:39 2013RFS[8]: Assigned to RFS process 9345RFS[8]: No connectionsallowed during/after terminal recovery.&&2.7 在主库重建standby control file&先在备库查看一下控制文件名称，等会创建完后直接覆盖过去：SQL& show parameter control&NAME&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& TYPE&&&&&&& VALUE----------------------------------------------- ------------------------------control_file_record_keep_time&&&&&&& integer&&&& 7control_files&&&&&&&&&&&&&&&&&&&&&&& string&&&&& /u01/app/oracle/oradata/dave/c&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&ontrol01.ctl, /u01/app/oracle/&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&fast_recovery_area/dave/contro&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&&&&&&&&l02.ctlcontrol_management_pack_access&&&&&& string&&&&& DIAGNOSTIC+TUNING&&主库创建standby controlfile：SQL& alter database create standbycontrolfile as '/u01/control01.ctl';Database altered.&&copy到备库的目录，在覆盖原来的控制文件： &--先关闭备库：SQL& shutdown immediateORA-01109: database not open&Database dismounted.ORACLE instance shut down.SQL&&&--copy并覆盖：[oracle@dg2 trace]$ cd/u01/app/oracle/oradata/dave/[oracle@dg2 dave]$ lscontrol01.ctl&&& stdbyredo02.log& stdbyredo04.log& system01.dbf&undotbs01.dbfstdbyredo01.log& stdbyredo03.log& sysaux01.dbf&&&& temp01.dbf&&& users01.dbf[oracle@dg2 dave]$ mv control01.ctlcontrol01.ctl.bak[oracle@dg2 dave]$ lscontrol01.ctl.bak& stdbyredo02.log& stdbyredo04.log& system01.dbf&undotbs01.dbfstdbyredo01.log&&& stdbyredo03.log& sysaux01.dbf&&&& temp01.dbf&&& users01.dbf&[oracle@dg2 dave]$ scp192.168.1.20:/u01/control01.ctl 192.168.1.30:/u01/app/oracle/oradata/dave/The authenticity of host '192.168.1.20(192.168.1.20)' can't be established.RSA key fingerprint is0d:6a:5f:78:53:a0:bf:54:a8:e3:7e:67:81:06:8d:75.Are you sure you want to continueconnecting (yes/no)? yesWarning: Permanently added '192.168.1.20'(RSA) to the list of known hosts.oracle@192.168.1.20's password: oracle@192.168.1.30's password: control01.ctl&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&100% 9520KB 865.5KB/s&& 00:11&&& Connection to 192.168.1.20 closed.[oracle@dg2 dave]$ lscontrol01.ctl&&&&& stdbyredo01.log& stdbyredo03.log& sysaux01.dbf&temp01.dbf&&&& users01.dbfcontrol01.ctl.bak& stdbyredo02.log& stdbyredo04.log& system01.dbf&undotbs01.dbf[oracle@dg2 dave]$&&[oracle@dg2 archivelog]$ cd/u01/app/oracle/fast_recovery_area/dave/[oracle@dg2 dave]$ lscontrol02.ctl[oracle@dg2 dave]$ mv control02.ctlcontrol02.ctl.bak[oracle@dg2 dave]$ lscontrol02.ctl.bak[oracle@dg2 dave]$&[oracle@dg2 dave]$ cp control01.ctl/u01/app/oracle/fast_recovery_area/dave/control02.ctl&2.8 在正常拉起备库&SQL&ORACLE instance started.&Total System Global Area&
bytesFixed Size&&&&&&&&&&&&&&&&& 2232760 bytesVariable Size&&&&&&&&&&&&
bytesDatabase Buffers&&&&&&&&&
bytesRedo Buffers&&&&&&&&&&&&&&& 2490368 bytesSQL& alter database mo&Database altered.&SQL& alter database recover managedstandby database dis&Database altered.&SQL&&2.9 查看主备库日志&主库日志：&Fri Mar 29 08:00:51 2013PING[ARC1]: Heartbeat failed to connect tostandby 'dave_st'. Error is 16143.Fri Mar 29 08:01:52 2013Error 1034 received logging on to thestandbyPING[ARC1]: Heartbeat failed to connect tostandby 'dave_st'. Error is 1034.Fri Mar 29 08:02:56 2013Error 1034 received logging on to thestandbyPING[ARC1]: Heartbeat failed to connect tostandby 'dave_st'. Error is 1034.Fri Mar 29 08:03:57 2013Error 1034 received logging on to thestandbyPING[ARC1]: Heartbeat failed to connect tostandby 'dave_st'. Error is 1034.Fri Mar 29 08:04:59 2013Error 1034 received logging on to the standbyPING[ARC1]: Heartbeat failed to connect tostandby 'dave_st'. Error is 1034.Fri Mar 29 08:06:02 2013Error 1034 received logging on to thestandbyPING[ARC1]: Heartbeat failed to connect tostandby 'dave_st'. Error is 1034.Fri Mar 29 08:07:05 2013Error 1034 received logging on to thestandbyPING[ARC1]: Heartbeat failed to connect tostandby 'dave_st'. Error is 1034.Fri Mar 29 08:08:08 2013PING[ARC1]: Heartbeat failed to connect tostandby 'dave_st'. Error is 16058.Fri Mar 29 08:08:34 2013ALTER SYSTEM SETlog_archive_dest_state_2='ENABLE' SCOPE=MEMORY SID='*';Fri Mar 29 08:08:35 2013Thread 1 advanced to log sequence 18 (LGWRswitch)&Current log# 3 seq# 18 mem# 0: /u01/app/oracle/oradata/dave/redo03.logFri Mar 29 08:08:36 2013******************************************************************LGWR: Setting 'active'archival for destination LOG_ARCHIVE_DEST_2******************************************************************Fri Mar 29 08:08:36 2013Archived Log entry 23added for thread 1 sequence 17 ID 0x dest 1:&&备库日志：&[oracle@dg2 trace]$ tail -20 alert_dave.logORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file ordirectoryAdditional information: 3Clearing online redo logfile 3 completeMedia Recovery Waiting for thread 1sequence 15Fetching gap sequence in thread 1, gapsequence 15-16Fri Mar 29 08:08:48 2013RFS[3]: Assigned to RFS process 9707RFS[3]: Opened log for thread 1 sequence 16dbid
branch Fri Mar 29 08:08:49 2013RFS[4]: Assigned to RFS process 9705RFS[4]: Opened log for thread 1 sequence 15dbid
branch Archived Log entry 2 added for thread 1sequence 16 rlc
ID 0x dest 2:Archived Log entry 3 added for thread 1sequence 15 rlc
ID 0x dest 2:Fri Mar 29 08:08:55 2013Media Recovery Log/u01/archivelog/1_15_.dbfMedia Recovery Log/u01/archivelog/1_16_.dbfMedia Recovery Log/u01/archivelog/1_17_.dbfFri Mar 29 08:09:11 2013Media Recovery Waitingfor thread 1 sequence 18 (in transit)&注意这里：&&& 我们把备库拉起来之后，就自动开始同步了。&&2.10 切换归档测试&主库：SQL& alter s&System altered.&SQL&&select sequence#,applied from v$archived_log order by sequence#&&SEQUENCE# APPLIED---------- ---------&&&&&&&18 NO&&&&&&&18 NO&&&&&&&17 NO&&&&&&&17 YES&&&&&&&16 YES&&&&&&&16 NO&&&&&&&15 NO&&&&&&&15 YES&&&&&&&14 NO&&&&&&&14 YES&&&&&&&13 YES&&&&&&&13 NO&&&&&&&12 NO&&&&&&&12 YES&&&&&&&11 NO&&&&&&&11 YES&&&&&&&10 YES&&&&&&&10 NO&&&&&&&&9 NO&&&&&&&&9 YES&&&&&&&&8 NO&&&&&&&&8 YES&&&&&&&&7 NO&&&&&&&&7 YES&&&&&&&&6 NO&&&&&&&&6 YES&&&&&&&&5 NO&&&&&&&&4 NO&28 rows selected.&&备库：&SQL&&select sequence#,applied from v$archived_log order by sequence#&SEQUENCE# APPLIED---------- ---------&&&&&&&18 YES&&&&&&&17 YES&&&&&&&16 YES&&&&&&&15 YES&注意这里，备库已经完全同步了。 之前在我们主库看，18的日志还没有应用，因为我们刚启动备库，应用需要一定的时间。 并且在我们重新配置之后，这里的数字就从15开始了。 是我们中断DG后的数字。 但我们主库还是从4开始计算的。 &&& &小结：&&& 对于DG通信异常中断的处理，我们仅仅需要重新创建一份standby 的control file就可以了。&&&&&&---------------------------------------------------版权所有，文章允许转载，但必须以链接方式注明源地址，否则追究法律责任!Skype: &&&tianlesoftwareQQ:&&&& & Email: &&&Blog:&& & http://blog.csdn.net/tianlesoftwareWeibo: &&&/tianlesoftwareTwitter:& /tianlesoftwareFacebook: /tianlesoftwareLinkedin: /in/tianlesoftware