介绍

V$LOGSTDBY_STATE视图整合了V$LOGSTDBY和V$LOGSTDBY_STATS视图的信息，提供了查询Data Guard逻辑备用数据库的运行状态。

限制

此视图仅适用于逻辑备用数据库。

视图详情

下面列表信息来源于Oracle 11G官方文档，本人仅做简单翻译，方便下次查询；暂时没有逻辑备份的Data Guard环境，里面的多数内容暂无法验证。

字段名	字段类型	描述	译	备注
PRIMARY_DBID	NUMBER	Database ID (DBID) of the primary database	主数据库的DBID
SESSION_ID	NUMBER	LogMiner session ID allocated to SQL Apply.	应用SQL的会话ID
REALTIME_APPLY	VARCHAR2(64)	Y indicates that SQL Apply is running in real-time apply mode. If a standby redo log is configured, SQL Apply applies changes as they are written to the standby redo log files. N indicates that SQL Apply applies changes as each archived redo log file is received.	Y-表示备库运行在实时应用模式下，N-表示收到主库的redo log后才会应用。	这个可能理解有问题，待有机会再确定。
STATE	VARCHAR2(64)	INITIALIZING - LogMiner session has been created and coordinator has attached to it LOADING DICTIONARY - SQL Apply is loading the LogMiner dictionary WAITING ON GAP - SQL Apply is waiting for a log file to be sent from the primary database APPLYING - SQL Apply is actively mining or applying transactions WAITING FOR DICTIONARY LOGS - SQL Apply is waiting for the archived logs containing the LogMiner dictionary to be shipped from the primary database IDLE - SQL Apply has applied all changes available at the logical standby, and is caught up with the primary database	正在初始化 - 已创建logminer会话，协调器已配置 载入字典 - SQL应用正在加载LogMiner字典 等待 - SQL应用正在等待主数据库发送的日志文件 应用中 - SQL应用正在应用或挖掘日志 等待字典日志 - SQL应用正在等待从主数据库发送的存档日志，该日志包含LogMiner字典 空闲 - SQL应用已应用所有可用的更改，并在逻辑待机状态