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

Last updated on AUGUST 04, 2018

Applies to:

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

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