Oracle教程 2023-02-24

Oracle 视图 V$RECOVERY_SLAVE 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图V$RECOVERY_SLAVE可以用于检查和监控当前数据库中进行中的数据库重放操作 (Data guard) 从备份日志应用到从库的信息。也可以用它来查看已经应用过的日志文件和未来需要应用的日志文件。

该视图包含以下信息：

1. SLAVE : 从库实例名称
2. CURRENT_FILE : 正在应用的日志文件
3. CURRENT_BLK : 该文件的起始位置
4. WORKING_FILE : 从备份文件中已被”应用”的最后一个日志文件
5. WORKING_BLK : 该文件的起始位置
6. LOW_SEQ# : 将要被应用的第一个日志文件的序列号
7. LOW_BLK# : 该文件的起始位置

使用方法：可以查询该视图来确定从库事务状态：

SELECT slave, current_file, working_file FROM V$RECOVERY_SLAVE;

官方英文解释

V$RECOVERY_SLAVE is used to track database media recovery processes to monitor their performance statistics and analyze a media recovery session.

Column	Datatype	Description
`START_TIME`	`DATE`	Start time of the recovery process
`TYPE`	`VARCHAR2(64)`	Type of recovery process being performed: `MEDIA RECOVERY Apply SLAVE` `MEDIA RECOVERY Merge Slave` `SERIAL MEDIA RECOVERY`
`ITEM`	`VARCHAR2(32)`	Item being measured. When `TYPE` is `MEDIA RECOVERY Apply SLAVE`, the possible values are: `Recovery ID` `Process ID` `Number of Redo Cache Full` `Number of Redo Cache Copy` `Number of CV Cached` `CV Applied OK` `CV Applied Stuck` `CV Applied Repair` `CV Applied Corrupt` `CV Applied Ckpt` `CV Applied Reapplied` `Total CV Processed Size` `Total CV Applied` `Number of Buffer Cache Full` `Number of Buffer Retries` `Number of Max Reads Issued` `Number of Unrcv Condition` `Number of Influx Buffer Flushed` `Number of Reap Request` `Number of Reap Wait IO` `Number of Reap No Buffer` `Number of Wait All Read` `Number of Buffer Pinged` `Buffer Ping Time` `Read Issue Time` `Number of Read Request Issued` When `TYPE` is `MEDIA RECOVERY Merge Slave`, the possible values are: `Recovery ID` `Process ID` `Number of Redo Cache Full` `Number of Redo Cache Copy` `Number of CV Cached` `Total Redo Read Bytes` `Total CV Parsed` When `TYPE` is `SERIAL MEDIA RECOVERY`, the possible values include values from the other two `TYPE`s.
`UNITS`	`VARCHAR2(32)`	The units of measurement for each item
`SOFAR`	`NUMBER`	Amount of work done so far
`TOTAL`	`NUMBER`	Total amount of work expected
`COMMENTS`	`VARCHAR2(248)`	Miscellaneous notes, which may display the recovery ID and process ID for current recovery session
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

本站中文解释

官方英文解释

相关推荐