High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

查询备库v$archived列出现applied=no的情况,但最新的都是yes

dataguard架构standby备库查询v$archived_log视图发现过去3个月前有applied=no的记录,但最近的3个月都是yes,观察alert日志发现这些显示未应用的日志在alert日志中出现这种”Media Recovery Log /u01/app/oracle/ARCHIVELOG1_239_1133850399.dbf“记录,同一条日志前几次报错,最后一次未报错,目前这些日志已经被删除,查询v$archive_gap视图显示为空,主备库也正常同步中,但仍不清楚为何出现v$archived_log视图发现过去3个月前有applied=no的记录,是这些日志没有应用上吗,历史记录中有数据丢失吗,我如何确认丢失了哪些数据,或者这是正常现象数据并未丢失,请帮忙分析

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center