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.
Oracle 12.2 or higher
BCT is enabled.
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
220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168
22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168
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:
A document exists discussing this issue ORA-00487 CTWR Process Terminated With Error During Rman Backup (Doc 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.
The following articles may provide more information or related information to this article:
- Oracle MOS - Patch results for bug 28410431
- Oracle MOS - Bug 28410431
- Oracle MOS - ORA-00487 CTWR process terminated with error during rman backup (Doc ID 28410431.8)