ORA-19699: cannot make copies with compression enabled ORACLE 报错 故障修复 远程处理

文档解释

ORA-19699: cannot make copies with compression enabled

Cause: Datafile copies with compression are not supported.

Action: 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.

ORA-19699错误指示着不可以使用压缩功能进行资料复制，即复制PIECE或者COPY动作时不可以启动COMPRESS参数，此为RMAN复制内容中COPY或PIECE时忽略COMPRESS参数而报错：

官方解释

ORA-19699: RMAN cannot make copies with compression enabled

Cause: The COPY or PIECE rman command was issued with COMPRESS enabled.

Action: Ignore COMPRESS in the rman command.

常见案例

1.当在RMAN进行数据备份的时候，添加了compress的参数，但是又报了ORA-19699错误；

2.有时在RMAN进行数据迁移或者数据备份的时候，可能会出现ORA-19699错误；

一般处理方法及步骤

1.忽略COMPRESS参数，也就是卸载段copy与piece命令中COMPRESS参数；

2. 将COMPRESS参数改为NOCOMPRESS，也就是确保copy与piece命令确实没有行COMPRESS参数；

3.大多数情况下，从归档队列读取数据时引发的这种错误，只要重启归档后端进程ａｒｃｓｅｒｖ，把RMAN session关闭，在再重新连接就可以解决。