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

MOSC Banner

DG备库数据文件状态异常

database version:11.2.0.4

DG模式最大性能

主库查询,gap_status为 NO GAP

select status,gap_status,recovery_mode from v$archive_dest_status where dest_id=2;

备库查询数据文件状态,单个数据文件recover(监控告警数据文件状态异常)

select file#,status,name from v$datafile;

如果手动在主上切个归档或者自动产生归档,备库数据文件状态由recover变成online,一段时间数据文件状态又变成recover。

请问这种情况正常吗还是可能什么原因导致的,影响使用吗

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