一起学习网 一起学习网

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

本站中文解释

(只读)用途:报告有关当前可用和禁用的RMAN压缩算法的信息。

Oracle视图V$RMAN_COMPRESSION_ALGORITHM是一个只读视图,提供了RMAN可用和已禁用的压缩算法的信息。可用于优化RMAN备份性能,节省存储空间。

使用此视图时,可以使用诸如ALGORITHM_NAME,ALGORITHM_DESC,可用性等列收集有关压缩算法的信息。 ALGORITHM_NAME列显示已经可用的算法的名称,ALGORITHM_DESC列提供有关可以使用的算法的描述,而AVAILABILITY列显示算法是启用还是禁用。

官方英文解释

V$RMAN_COMPRESSION_ALGORITHM provides descriptions of supported compression algorithms. It is used by the RMAN client.

ColumnDatatypeDescription

ALGORITHM_ID

NUMBER

Algorithm ID

ALGORITHM_NAME

VARCHAR2(64)

Name of the algorithm (for example, LOW, MEDIUM, DEFAULT, or HIGH)

INITIAL_RELEASE

VARCHAR2(18)

First Oracle Database release when this compression algorithm was available

TERMINAL_RELEASE

VARCHAR2(18)

Last Oracle Database release that supported using this compression algorithm to create new backups. Existing backups can always be restored, even if they use a deprecated compression algorithm.

ALGORITHM_DESCRIPTION

VARCHAR2(64)

Description of the algorithm

ALGORITHM_COMPATIBILITY

VARCHAR2(18)

Required database compatibility level for the algorithm (for example, 11.2.0 for DEFAULT)

IS_VALID

VARCHAR2(3)

Indicates whether the algorithm is valid with regard to the compatibility setting (YES) or not (NO). The value is YES if ALGORITHM_COMPATIBILITY <= DATABASE_COMPATIBILITY.

REQUIRES_ACO

VARCHAR2(3)

Indicates whether the algorithm requires the Advanced Compression Option (YES) or not (NO)

IS_DEFAULT

VARCHAR2(3)

Indicates whether the algorithm is the default compression algorithm that RMAN uses to create compressed backup sets (YES) or not (NO)

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