Oracle教程 2023-03-24

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

Oracle ASM ACFS加密视图V$ASM_ACFS_ENCRYPTION_INFO可以用来查询Oracle ACFS文件系统中加密文件和元数据的加密信息。此视图中的字段信息就是某个文件系统特定加密算法的设定，将每个加密块的加密算法通过此视图查询出来。

使用方法：

1) 首先需要创建一个键管理器。

SQL> CREATE KEYSTORE ‘/etc/oracle/encrypted_data’
IDENTIFIED BY ‘*******’
KEY_SIZE 512 ;

2) 然后需要为ACFS加密文件系统设置一个加密算法：

SQL> ALTER SYSTEM SET ENCRYPTION KEYSTORE_TYPE=ACFS
KEYSTORE ‘/etc/oracle/encrypted_data’
ALGORITHM AES_CBC_256 ;

3) 查看V$ASM_ACFS_ENCRYPTION_INFO视图，从中查看所有文件系统中加密文件和元数据的加密信息。

SQL> SELECT FILE_NAME, ENCRYPTION_ALGORITHM, OFFSET, LENGTH
FROM V$ASM_ACFS_ENCRYPTION_INFO ;

V$ASM_ACFS_ENCRYPTION_INFO displays encryption information for every mounted Oracle ACFS.

Column	Datatype	Description
`FS_NAME`	`VARCHAR2(1024)`	File system mount point (foreign key to `V$ASM_FILESYSTEM`)
`VOL_DEVICE`	`VARCHAR2(256)`	Name of the Oracle ADVM device
`SET_STATUS`	`VARCHAR2(7)`	Indicates whether encryption parameters have been set on the file system (`YES`) or not (`NO`); otherwise `UNKNOWN`.
`ENABLED_STATUS`	`VARCHAR2(8)`	Indicates whether file system level encryption is enabled (`ENABLED`) or not (`DISABLED`); otherwise `UNKNOWN`.
`ALGORITHM`	`VARCHAR2(7)`	Encryption algorithm used. AES is the only supported algorithm.
`KEY_LENGTH`	`VARCHAR2(7)`	Key length used for the encryption key
`LAST_REKEY_TIME`	`DATE`	Time that the volume was last rekeyed
`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 For this view, the value is always `0`.