ORA-16086: Redo Data Cannot Be Written To The Standby Redo Log
Last updated on SEPTEMBER 09, 2017
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterInformation 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