Oracle教程 2023-04-06

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

本站中文解释

Oracle视图V$STANDBY_LOG，它是查看当前应用或读一致性特性数据库实例中同步器正在使用的和已经使用过的日志之总览。这个视图可以用来检查当前应用程序和读一致性特性数据库实例中可用的日志，以及实例中已经使用过的日志。

使用该视图，可以检查备份数据库已经应用的日志，并保持最新的应用状态。

使用方法如下：
1、连接到备份数据库，运行以下SQL：
SELECT * FROM V$STANDBY_LOG;
2、它将会显示，每一行表示一个日志，表中包括：
– APPLIED：该日志是否被应用了恢复到备份数据库的标志
– LOGSEQUENCE：日志序列号
– FIRST_CHANGE#：最早发生变化的号码
– FIRST_TIME：最早发生变化的时刻
3、可以通过如下语句查看被执行和未被应用到备份数据库的最新日志信息：
SELECT * FROM V$STANDBY_LOG WHERE APPLIED=’NO’;

官方英文解释

V$STANDBY_LOG displays information about standby redo logs. Standby redo logs are similar to online redo logs, but standby redo logs are only used on a standby database that is receiving redo data from the primary database.

Column	Datatype	Description
`GROUP#`	`NUMBER`	Log group number
`DBID`	`VARCHAR2(40)`	Database ID of the primary database to which the standby redo logfile is assigned. If the standby redo logfile is unassigned, the value `UNASSIGNED` will be displayed.
`THREAD#`	`NUMBER`	Log thread number
`SEQUENCE#`	`NUMBER`	Log sequence number
`BYTES`	`NUMBER`	Size of the log (in bytes)
`BLOCKSIZE`	`NUMBER`	Block size of the logfile (512 or 4096)
`USED`	`NUMBER`	Number of bytes used in the log
`ARCHIVED`	`VARCHAR2(3)`	Archive status (`YES`) or (`NO`). See the `STATUS` column for further details.
`STATUS`	`VARCHAR2(10)`	Log status: `UNASSIGNED` – If `ARCHIVED` is `NO`, then the standby redo log has been archived and is again available. If `ARCHIVED` is `YES`, then the standby redo log has never been used and is available. `ACTIVE` – If `ARCHIVED` is `NO`, then the standby redo log is complete and waiting to be archived. If `ARCHIVED` is `YES`, then the standby redo log is currently being written to and is therefore not ready to be archived. For a given thread, there should be only one such log.
`FIRST_CHANGE#`	`NUMBER`	Lowest SCN in the log
`FIRST_TIME`	`DATE`	Time of the first SCN in the log
`NEXT_CHANGE#`	`NUMBER`	All redo records contained within this log will have an SCN lower than `NEXT_CHANGE#`. Only filled in once the log is complete. Also the lowest SCN of any redo record in the next log.
`NEXT_TIME`	`DATE`	All redo records contained within this log will have a timestamp lower than `NEXT_TIME`. Only filled in once the log is complete. Also the lowest timestamp of any redo record in the next log.
`LAST_CHANGE#`	`NUMBER`	All redo records contained within this log will have an SCN lower than `LAST_CHANGE#`. Only filled in once the log is complete. Also the lowest SCN of any redo record in the next log. L`AST_CHANGE#` is deprecated. Use `NEXT_CHANGE#` instead.
`LAST_TIME`	`DATE`	All redo records contained within this log will have a timestamp lower than `LAST_TIME`. Only filled in once the log is complete. Also the lowest timestamp of any redo record in the next log. `LAST_TIME` is deprecated. Use `NEXT_TIME` instead.
`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

数据运维技术 » Oracle 视图 V$STANDBY_LOG 官方解释，作用，如何使用详细说明

分享到：

本站中文解释

官方英文解释

相关推荐