My Oracle Support Banner

ORA-16086:Redo无法写入standby redo log 报有 RFS[368]: No standby redo logfiles selected (reason:7) (Doc ID 2469675.1)

Last updated on DECEMBER 01, 2019

适用于:

Oracle Database Cloud Exadata Service - 版本 N/A 和更高版本
Oracle Database Cloud Service - 版本 N/A 和更高版本
Oracle Database - Enterprise Edition - 版本 12.1.0.2 和更高版本
Oracle Database Cloud Schema Service - 版本 N/A 和更高版本
Oracle Database Exadata Cloud Machine - 版本 N/A 和更高版本
本文档所含信息适用于所有平台

症状

注意:在下面的图片/文档内容中,使用的用户信息和环境数据表示来自Oracle示例模式、随Oracle数据库产品交付的公共文档或其他培训材料的虚构数据。任何与真实环境、真实的人相似之处纯粹是巧合,而不是以任何方式有意为之。

在本文档中,用以下虚构的环境作为例子来描述这个过程

Database Unique Name: rmsdb_prd
Primary database: tccracdb
Standby database: racprdro
Configuration: dgconf1

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

错误:ORA-16810:检测到数据库的多个错误或警告

Warning: ORA-16857: standby disconnected from redo source for longer than specified threshold


ERROR ORA-16086: Redo data cannot be written to the standby redo log
RFS[368]: No standby redo logfiles selected (reason:7)

 

 

 Standby Database Alertlog

Archived Log entry 56 added for thread 1 sequence 3810 rlc 907769776 ID 0x7a27572d dest 2:

RFS[1]: No standby redo logfiles available for T-1 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
RFS[1]: Opened log for thread 1 sequence 3811 dbid 2049385006 branch 907769776
Wed Jan 03 16:43:37 2018
Archived Log entry 57 added for thread 2 sequence 4381 rlc 907769776 ID 0x7a27572d dest 2:
RFS[2]: No standby redo logfiles available for T-2 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
RFS[2]: Opened log for thread 2 sequence 4382 dbid 2049385006 branch 907769776
Wed Jan 03 16:49:54 2018

 

Primary Database Alert log

Wed Jan 24 08:55:58 2018
Errors in file /dbhome/oracle/diag/rdbms/tccracdb/tccracdb1/trace/tccracdb1_lgwr_25601.trc:
ORA-16086: Redo data cannot be written to the standby redo log

DataGuardBroker log

Error: The actual protection level 'Resynchronization' is different from the configured protection mode 'MaxAvailability'.
Redo transport problem detected: redo transport to database racprdro has the following error:
ORA-16086: Redo data cannot be written to the standby redo log
Data Guard Broker Status Summary:
Type Name Severity Status
Configuration dgconf1 Warning ORA-16607
Primary Database tccracdb Error ORA-16810
Physical Standby Database racprdro Success ORA-00000

DataGuardBroker log

01/24/2018 08:59:49
Redo transport problem detected: redo transport to database racprdro has the following error:
ORA-16086: Redo data cannot be written to the standby redo log
01/24/2018 09:00:49
Redo transport problem detected: redo transport to database racprdro has the following error:
ORA-16086: Redo data cannot be written to the standby redo log

 

DGMGRL

 

更改

 

原因

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


文档内容
症状
更改
原因
解决方案

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.