Oracle教程

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

本站中文解释

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


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

相关推荐