9.187 V$RMAN_ENCRYPTION_ALGORITHMS

V$RMAN_ENCRYPTION_ALGORITHMS displays supported encryption algorithms. It is used by the RMAN client to validate user-requested algorithms.

This view lists AES128, AES192, and AES256 encryption algorithms for the current release. The default algorithm is AES256.

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 for CFB encryption mode (YES) or not (NO). CFB encryption mode is used when the COMPATIBLE initialization parameter is set to a value less than 23.0.0.0. Otherwise, refer to the IS_DEFAULTXTS column. This value is set by Oracle AI 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.
IS_DEFAULTXTS	VARCHAR2(3)	Indicates whether this is the default encryption algorithm for XTS encryption mode (YES) or not (NO). XTS encryption mode is used when the COMPATIBLE initialization parameter is set to a value greater than or equal to 23.0.0.0. Otherwise, refer to the IS_DEFAULT column. This value is set by Oracle AI Database and may vary for each Release (that is, it is not dependent on user-specified RMAN configuration).
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