Oracle教程 2023-03-23

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

_DEVICE 可用于查看RMAN 当前备份类别、设备中。

Oracle视图V$RMAN_BACKUP_TYPE_DEVICE用来提供RMAN命令中当前使用到的备份类型、设备，以及设备可以识别的备份类型信息。

该视图中可以查到：channel_name (通道名)、configuration (备份配置)、device_type (设备类型)、id (编号)、reuse (重用的状态)、type (备份类型)等信息。

如何使用：可以使用以下SQL语句查看当前使用的备份设备名和备份类型：

SELECT channel_name, type, configuration FROM V$RMAN_BACKUP_TYPE_DEVICE;

V$RMAN_BACKUP_TYPE displays information about RMAN backup types.

Column Datatype Description

Column	Datatype	Description
`WEIGHT`	`NUMBER`	Used to set precedence order of different backup types in reports.
`INPUT_TYPE`	`VARCHAR2(13)`	Used to represent possible filters used in creating various reporting screens.
`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

WEIGHT

NUMBER

Used to set precedence order of different backup types in reports.

INPUT_TYPE

VARCHAR2(13)

Used to represent possible filters used in creating various reporting screens.

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

分享到：