ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-16143 While Redo Transport to Standby [ID 834817.1]

ORA-16143 While Redo Transport to Standby [ID 834817.1]

原创 Linux操作系统 作者:rongshiyuan 时间:2013-06-28 00:17:53 0 删除 编辑
ORA-16143 While Redo Transport to Standby [ID 834817.1]
 

In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.1.0.7
This problem can occur on any platform.

Symptoms

ORA-16143 while redo transport to standby database.

alert.log of primary shows:
=========================
Errors in file /opt/oracle/admin/UPDATE/bdump/update1_arc1_419.trc:
ORA-16143: RFS connections not allowed during or after terminal recovery
Sun Apr 19 12:08:01 2009
PING[ARC1]: Heartbeat failed to connect to standby 'update_stdby'. Error is 16143.

Cause

Managed standby database finish was executed in standby.

alert.log of standby shows:
=========================
Thu Apr 16 17:35:17 2009
Completed: ALTER DATABASE RECOVER managed standby database finish

Solution

Recreate the standby database.

Redo cannot be transported to standby where managed standby database finish has been executed

Standby database can only be activated after performing managed standby database finish using:

SQL>ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17252115/viewspace-764979/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-11-24

  • 博文量
    798
  • 访问量
    3240790