RMAN-03009, ORA-00487 CTWR Process Terminated With Error Encountered During SnapSync (KBA9501)

Issue

During an Oracle dSource SnapSync operation, the following error is encountered:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on DLPX_CHANNEL_0 channel at 08/25/2022 10:15:35
ORA-00487: CTWR process terminated with error
RMAN-03009: failure of backup command on DLPX_CHANNEL_1 channel at 08/25/2022 10:03:38
ORA-00487: CTWR process terminated with error
RMAN-03009: failure of backup command on DLPX_CHANNEL_0 channel at 08/25/2022 10:00:56
ORA-00487: CTWR process terminated with error
RMAN-03009: failure of backup command on DLPX_CHANNEL_1 channel at 08/25/2022 09:57:26
ORA-00487: CTWR process terminated with error

This error may be encountered at any time during the backup phase.

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies

Major Release	All Sub Releases
6.0	6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0, 6.0.6.0, 6.0.6.1, 6.0.7.0, 6.0.8.0, 6.0.8.1, 6.0.9.0, 6.0.10.0, 6.0.10.1, 6.0.11.0, 6.0.12.0, 6.0.12.1, 6.0.13.0, 6.0.13.1, 6.0.14.0, 6.0.15.0
5.3	5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0, 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0

Resolution

This error may be encountered as a result of Oracle Bug 28410431  ORA-00487 CTWR process terminated with error during rman backup.  The issue is discussed in MOS at the following link:

https://support.oracle.com/epmos/faces/DocContentDisplay?id=28410431.8

A document exists discussing this issue ORA-00487 CTWR Process Terminated With Error During Rman Backup (Doc ID 2705215.1)
https://support.oracle.com/epmos/faces/DocContentDisplay?id=2705215.1

However, the article does not specify all affected versions of Oracle, though patches for this issue can be found for 12.2, 18, 19, and others.  This link will perform a search and return results for patches addressing 28410431.

The Oracle documentation discusses the removal and recreation of the BCT file or disabling BCT as a workaround, but ultimately Delphix recommends installation of the Oracle patch to resolve this issue. Disabling BCT is expected to increase job times for incremental backup operations.  Deletion and recreation of the BCT file may not ultimately resolve the issue, and the error may be encountered again.

If the workarounds or patch application do not resolve the issue, please engage Delphix and Oracle Support.