ORA-16014 ORA-00312 备库没有归档路径的报错
1,927 total views, 2 views today
交易系统的主库在公司机房,备库在外面的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_1中的db_unique_name从trade1变成trade3,备库接收主库的redo条目,缺找不到自己对应的归档路径(原有路径是db_unique_name=trade1对应的路径)。
1 |
log_archive_dest_1 string LOCATION=/u01/app/oracle/arch valid_for=(all_logfiles,all_roles) db_unique_name=trade1 |
解决办法:
设置正确的unique_name对应的归档路径,然后重启MRP进程,问题解决。
1 |
alter system set log_archive_dest_1='LOCATION=/u01/app/oracle/arch valid_for=(all_logfiles,all_roles) db_unique_name=trade3'; |