ORA-16014 ORA-00312 备库没有归档路径的报错
交易系统的主库在公司机房，备库在外面的IDC机房。备库搬回到公司，service_name从trade1改为了trade3，,unique_name也从从trade1改为了trade3。 启动后无异常，不久开始报备库延迟。alert.log 日志显示没有可用的归档路径。
|
1 2 3 4 5 6 7 |
Tue Jan 07 06:53:58 2020 Archiver process freed from errors. No longer stopped Tue Jan 07 06:58:58 2020 ARCH: Archival stopped, error occurred. Will continue retrying ORACLE Instance xxx - Archival Error ORA-16014: log 13 sequence# 4095 not archived, no available destinations ORA-00312: online log 13 thread 1: '/u01/app/oracle/oradata/xxxx/std_redo03.log' |
错误原因： 操作疏忽，忘记修改log_archive_dest
Read more