Oracle教程 2023-03-26

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

_SYNC_IO

V$BACKUP_SYNC_IO视图提供了RMAN归档和备份操作的IO同步信息。直接使用select * from v$backup_sync_io;语句可查看IO同步的状态、操作、输出文件等。用到此视图的主要场景包括：

1. 监控RMAN的备份和归档操作。通过V$BACKUP_SYNC_IO，可查看当前正在进行的RMAN备份和归档过程；

2. 检查备份和归档的状态。V$BACKUP_SYNC_IO允许查看正在运行的备份和归档操作的状态；

3. 确定指定备份和归档操作的输出文件。V$BACKUP_SYNC_IO可以用来确定指定备份和归档操作生成的输出文件；

4. 发现I/O性能问题。V$BACKUP_SYNC_IO可以用来跟踪I/O性能的表现性能，从而发现I/O性能问题。

V$BACKUP displays the backup status of all online data files.

Column	Datatype	Description
`FILE#`	`NUMBER`	File identifier
`STATUS`	`VARCHAR2(18)`	File status: `NOT ACTIVE`, `ACTIVE` (backup in progress), `OFFLINE NORMAL`, or description of an error. `NOT ACTIVE` indicates that the file is not currently in backup mode (that is, an `ALTER TABLESPACE ... BEGIN BACKUP` or `ALTER DATABASE BEGIN BACKUP` statement has not been issued), whereas `ACTIVE` indicates that the file is currently in backup mode.
`CHANGE#`	`NUMBER`	System change number when backup started
`TIME`	`DATE`	Time the backup started
`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

分享到：