How to fix the Oracle error ORA-19961: compression algorithm string requires advanced compression option to be enabled?

In this post, you’ll learn more about the Oracle ErrorORA-19961: compression algorithm string requires advanced compression option to be enabled with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-19961: compression algorithm string requires advanced compression option to be enabled

Reason for the Error ORA-19961: compression algorithm string requires advanced compression option to be enabled

Requested compression algorithm in initialization parameter or by RMAN configuration requires that the advanced compression option be enabled and it was not.

How to fix the Error ORA-19961: compression algorithm string requires advanced compression option to be enabled ?

You can fix this error in Oracle by following the below steps

Change initialization parameter advanced_compression_option_usable to true or change RMAN configurations and retry the operation.