ORA-16086: Redo data cannot be written to the standby redo log
Problem:
Standy throws error
select dest_name, status, error from gv$archive_dest;
LOG_ARCHIVE_DEST_1 ERROR ORA-16086: Redo data cannot be written to the standby redo log
Discovery: it does not like service in parameter
log_archive_dest_1=‘SERVICE=stby VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=stby REOPEN=60′
Solution:
change parameter with ASM diskgroup
alter system set log_archive_dest_1=’LOCATION=+ORADATA1 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=stby REOPEN=60′ scope=spfile sid=’*’;
No comments yet