Oracle教程

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

本站中文解释

是系统视图，存放着关于备份设备的限制信息，比如可以使用的类型、每个设备的类型、大小、当前状态、可以备份的最大数据块大小等信息。该视图可以用来查看系统中当前可用的备份设备的状态，并可根据其中的信息进行后续的相关操作，比如确定备份设备的大小、查看备份设备是否空闲等。

使用V$BACKUP_DEVICE视图，可以使用一条SQL语句来检索多个备份设备的相关信息：

SELECT * FROM v$backup_device;

官方英文解释

V$BACKUP_DEVICE displays information about supported backup devices.

If a device type does not support named devices, then one row with the device type and a null device name is returned for that device type. If a device type supports named devices then one row is returned for each available device of that type. The special device type DISK is not returned by this view because it is always available.

Column Datatype Description

DEVICE_TYPE

VARCHAR2(17)

Type of the backup device

DEVICE_NAME

VARCHAR2(513)

Name of the backup device

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$BACKUP_DEVICE 官方解释，作用，如何使用详细说明
分享到：

相关推荐