aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

ORA-16434: Archive log for branch string thread string sequence string cannot be queued.

ORA-16434: Archive log for branch string thread string sequence string cannot be queued.
Cause: An archive log needed by the standby database to resolve a redo gap was not found on the primary database. This is a fatal situation during a switchover because the primary database waits for the target standby to be clear of all archive log gaps before allowing the switchover to proceed. If a redo gap cannot be resolved, the switchover cannot succeed.
Action: If the specified log is listed in V$ARCHIVED_LOG for the DEST_ID of the local destination on the primary database but no longer exists in that location on disk, the archived log can be copied back to that location to allow gap processing to automatically resolve the gap. If the specified log has been purged from V$ARCHIVED_LOG, the archived log can be copied to disk on either the primary or standby database and registered using the ALTER DATABASE REGISTER OR REPLACE LOGFILE command.

请先 登录 后评论

1 个回答

小智
ORA-16434:归档日志的分支字符串线程字符串序列字符串不能排队。,
.原因:在主数据库上找不到备用数据库解析重做间隙所需的存档日志。这是切换期间的致命情况,因为主数据库等待目标备用数据库清除所有归档日志间隙,然后才允许切换继续。如果无法解决重做间隙,则切换不能成功。,
.操作:如果在V $ ARCHIVED_LOG中为主数据库上的本地目标的DEST_ID列出了指定的日志,但在磁盘上该位置不再存在该日志,则归档日志可以复制回该位置,以允许间隙处理自动解决差距。如果指定的日志已从V $ ARCHIVED_LOG中清除,则归档日志可以复制到主数据库或备用数据库上的磁盘,并使用ALTER DATABASE REGISTER OR REPLACE LOGFILE命令注册。,
.
请先 登录 后评论