How to fix the Oracle error ORA-19699: cannot make copies with compression enabled?

In this post, you’ll learn more about the Oracle ErrorORA-19699: cannot make copies with compression enabled with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-19699: cannot make copies with compression enabled

Reason for the Error ORA-19699: cannot make copies with compression enabled

Datafile copies with compression are not supported.

How to fix the Error ORA-19699: cannot make copies with compression enabled ?

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

If the function DBMS_BACKUP_RESTORE.BACKUPPIECECREATE is called outside RMAN, then the incompatible values are being passed for the parameters DOCOMPRESS and IMAGCP. If this message occurs during an RMAN job, then this is an internal error in RMAN, and you should contact Oracle support.