【Vegas原创】ORA-16040 standby destination archive log file is locked解决
来源:互联网 发布:win8摄像头软件 编辑:程序博客网 时间:2024/05/17 23:04
ORA-16040:
standby destination archive log file is lockedCause: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
0 0
- 【Vegas原创】ORA-16040 standby destination archive log file is locked解决
- 【Vegas原创】ORA-16040 standby destination archive log file is locked解决
- 【Vegas原创】DB或DG出现的ORA-16038解决-日志无法归档(startup时log不能archive)
- 【Vegas原创】DB或DG出现的ORA-16038解决-日志无法归档(startup时log不能archive)
- 【Vegas原创】ORA-01103:"database name *** in control file is not @@@" 解决
- 【Vegas原创】ORA-01103:"database name *** in control file is not @@@" 解决
- 【Vegas原创】ORA-01113: file 1 needs media recovery解决
- 【Vegas原创】ORA-01113: file 1 needs media recovery解决
- 【Vegas原创】ORA-16038解决
- 【Vegas原创】ORA-16038解决
- 【Vegas原创】ORA-01031: insufficient privileges解决
- 【Vegas原创】ORA-01031: insufficient privileges解决
- ORA-28000: the account is locked解决
- 解决ORA-28000: the account is locked
- 解决ORA-28000: the account is locked
- 解决ORA-28000: the account is locked
- ORA-16072: a minimum of one standby database destination is required
- ORA-16072: a minimum of one standby database destination is required
- 【Vegas原创】RMAN数据库Daily备份脚本(Linux版)
- 【Vegas原创】RMAN数据库Daily备份脚本(Linux版)
- 【Vegas原创】DG Build(Linux版)
- 【Vegas原创】DG Build(Linux版)
- linux压缩
- 【Vegas原创】ORA-16040 standby destination archive log file is locked解决
- 【Vegas原创】ORA-16040 standby destination archive log file is locked解决
- 【Vegas原创】DB和DG的切换
- 【Vegas原创】DB和DG的切换
- Linux之rsync
- 不规则动词过去式和过去分词大表
- 不规则动词过去式和过去分词大表
- 【Vegas原创】对应父节点的树状返回查询
- 【Vegas原创】对应父节点的树状返回查询