【Vegas原创】ORA-16040 standby destination archive log file is locked解决
ORA-16040: |
standby destination archive log file is locked |
Cause: | The target standby destination archive log file is currently locked. This indicates that the file is being archived to by another Remote File Server (RFS) process. |
Action: | Check for and eliminate duplicate standby destination archive log service names defined for the primary database. |
产生原因:
做DG的时候,忘记将DG的pfile的参数修改。
解决方案:
将DG的Pfile的以下四个参数值修改正确:
log_archive_dest_2
log_archive_dest_state_2
fal_server
fal_client
喜欢请赞赏一下啦^_^