Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub


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

Column Datatype Description
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