My Oracle Support Banner

ORA-16086: Redo Data Cannot Be Written To The Standby Redo Log (Doc ID 2281449.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.

Symptoms

In primary database

SQL> SELECT RECOVERY_MODE database_mode, type, status FROM V$ARCHIVE_DEST_STATUS WHERE DEST_ID=2;

DATABASE_MODE TYPE STATUS
----------------------- ---------------- ---------
IDLE UNKNOWN ERROR

SQL> SELECT status, error FROM V$ARCHIVE_DEST_STATUS WHERE STATUS <> 'DEFERRED' AND STATUS <> 'INACTIVE' WHERE DEST_ID=2;

STATUS ERROR
--------- -----------------------------------------------------------------
ERROR ORA-16086: Redo data cannot be written to the standby redo log

Changes

Primary  database was restarted

Cause

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

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


In this Document
Symptoms
Changes
Cause
Solution


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