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

Last updated on SEPTEMBER 09, 2017

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

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 hundreds of Community platforms