dg的alert日志出现Heartbeat failed to connect to standby 'primaryorcl'. Error is 16009

dg的alert日志出现Heartbeat failed to connect to standby 'primaryorcl'. Error is 16009
主库:
RFS[80]: Assigned to RFS process 25039
RFS[80]: Database mount ID mismatch [0x5261c3dd:0x52614808] (1382138845:1382107144)
RFS[80]: Client instance is standby database instead of primary
Thu Jul 31 16:14:02 2014
备库:
RFS connections are allowed
Thu Jul 31 17:15:56 2014
alter database open
AUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-only access
Thu Jul 31 17:19:39 2014
krsu_upi_rfs: kspgsp returned null string for db unique name
PING[ARC2]: Heartbeat failed to connect to standby 'primaryorcl'. Error is 16009.
Thu Jul 31 17:20:39 2014
krsu_upi_rfs: kspgsp returned null string for db unique name
PING[ARC2]: Heartbeat failed to connect to standby 'primaryorcl'. Error is 16009.
krsu_upi_rfs: kspgsp returned null string for db unique name
PING[ARC2]: Heartbeat failed to connect to standby 'primaryorcl'. Error is 16009.
Thu Jul 31 17:21:33 2014
Abort recovery for domain 0
Errors in file /oracle/oracle/diag/rdbms/orcldg/orcl1/trace/orcl1_ora_4267.trc:
主库
SQL> show parameter log_archive_dest_2

NAME                                 TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
log_archive_dest_2                   string
service=STANDBYORCL valid_for=
(ALL_LOGFILES,ALL_ROLES) db_un
ique_name=orcldg

备库:
SQL> show parameter log_archive_dest_2

NAME                                 TYPE       VALUE
------------------------------------ ---------- ------------------------------
log_archive_dest_2                   string     service=primaryorcl valid_for=
                                                (ALL_LOGFILES,ALL_ROLES) db_un
                                                ique_name=orcl
修改standby端:
SQL> alter system set log_archive_dest_state_2=defer scope=both sid='*'
报错解决
可以修改valid_for来解决这个报错
SQL> alter system set log_archive_dest_2='service=standbydg arch sync valid_for=(online_logfiles,primary_role) db_unique_name=orcldg' scope=both sid='*'

System altered.

注:


In this Document

 Symptoms
 Cause
 Solution


APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 20-SEPT-2013***

SYMPTOMS

Primary with one or more physical or logical standby databases
All the databases involved in data guard configuration are correctly configured 
with log_archive_dest_n and log_archive_config parameters
There are no errors in the available standby database alertlogs when the below messages pop up in Primary alertlog

---- Primary alertlog ---- 

Thu Apr 12 10:27:47 2012
RFS[1]: Assigned to RFS process 23666
RFS[1]: Database mount ID mismatch [0x5d0945b9:0x5ce6c765] (1560888761:1558628197)
RFS[1]: Not using real application clusters
Thu Apr 12 10:27:48 2012
RFS[2]: Assigned to RFS process 23668
RFS[2]: Database mount ID mismatch [0x5d0945b9:0x5ce6c765] (1560888761:1558628197)
RFS[2]: Not using real application clusters
Thu Apr 12 10:27:49 2012

Thu Apr 12 18:54:39 2012
ALTER SYSTEM SET log_archive_trace=8191 SCOPE=BOTH; <<<<-------- Enabling trace leaves ORA-16009
Thu Apr 12 18:54:46 2012

Thu Apr 12 19:14:26 2012
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[555]: Assigned to RFS process 17392
RFS[555]: Database mount ID mismatch [0x5d0945b9:0x5ce6c765] (1560888761:1558628197)
RFS[555]: Not using real application clusters
Errors in file /orahome/app/oracle/diag/rdbms/qd_f4wp1/f4wp1/trace/f4wp1_rfs_17392.trc:
ORA-16009: invalid redo transport destination
Thu Apr 12 19:15:27 2012
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid




-------- f4wp1_rfs_17392.trc ----------

krsr_rfs_nfy: Startup received from ARCH pid 6366 <<< --------------------- This is the process of some read/write open database connected to this primary
krsd_init_sdips: called from [krsr.c:3189] with function 2
krso_proc_add: Detected dead process 16969; subsuming V$MANAGED_STANDBY slot
krso_proc_add: Using V$MANAGED_STANDBY slot 0xca8a68420
krsr_rfs_nfy: Identified 3 RFS client(s)
*** 2012-04-12 19:14:26.262 879 krsr.c
RFS message number 427 (RFSATTCH state:1 mode:1 flag:0x800002) start


*** 2012-04-12 19:14:26.269 1799 krsa.c
Completed  CFTXN 0x7fff2299ae50 (last PID:17392) [krsr.c:4466] IX-
Resignalling exception 16009 [krsr.c:4469]
ORA-16009: invalid redo transport destination
*** 2012-04-12 19:14:26.370 883 krsv.c
krsv_dpga: Freeing krsrrx

CAUSE

One of the existing standby databases was cloned without removing Data Guard Related Parameters
that enables it to connect to original Primary when this standby takes Primary database role - Cloning open the database in read / write Mode

SOLUTION

Ensure that there is no log_archive_dest_n parameter that connects to original Primary and 
also remove any Data guard Related parameters from cloned database

Example Parameters

alter system set log_archive_dest_n='' scope=both sid='*';- one that points to original Primary
alter system set fal_server='' scope=both sid='*';
alter system set fal_client='' scope=both sid='*';




  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值