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

网络编程 Oracle 视图 V$RMAN_ENCRYPTION_ALGORITHMS 官方解释，作用，如何使用详细说明 10-17

本站中文解释

Oracle视图V$RMAN_ENCRYPTION_ALGORITHMS用于显示RMAN支持的加密算法的名称及其版本。

使用该视图可以很方便的查看哪些加密算法对RMAN可用。通过查看使用那些加密算法，操作者可以及早检测到有潜在安全漏洞，以确定当前使用的加密算法是否可以满足安全需求。

使用该视图的方法如下：

SELECT * FROM V$RMAN_ENCRYPTION_ALGORITHMS;

这将显示RMAN支持的所有安全算法的名称及其版本。

官方英文解释

V$RMAN_ENCRYPTION_ALGORITHMS displays supported encryption algorithms. It is used by the RMAN client to validate user-requested algorithms. This view will list AES128, AES192, and AES256 encryption algorithms for the current release. The default algorithm is AES128.

Column	Datatype	Description
`ALGORITHM_ID`	`NUMBER`	Number to identify the algorithm
`ALGORITHM_NAME`	`VARCHAR2(64)`	Name of the algorithm (for example, AES128, AES192, or AES256)
`ALGORITHM_DESCRIPTION`	`VARCHAR2(64)`	Description of the algorithm
`IS_DEFAULT`	`VARCHAR2(3)`	Indicates whether this is the default encryption algorithm (`YES`) or not (`NO`). This value is set by Oracle Database and may vary for each Release (that is, it is not dependent on user-specified RMAN configuration).
`RESTORE_ONLY`	`VARCHAR2(3)`	Indicates whether this algorithm can be used for restore only (`YES`) or not (`NO`). If the value is `NO`, then the algorithm is also allowed for backup. This column is useful in determining whether an encryption algorithm is deprecated for backup purpose.
`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

编辑：一起学习网

标签：加密算法,视图,名称,版本,操作者