Encountering error ORA-19836 when taking and moving Oracle RMAN backup to the Oracle Cloud (OCI)



Error:


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c1 channel at 10/11/2018 10:06:22
ORA-19836: cannot use passphrase encryption for this backup



Bug 21315524 : ORA-19836: CANNOT USE PASSPHRASE ENCRYPTION FOR THIS BACK


Solution

Workaround is instead of using set encryption on identified by only; use set encryption on ; in backup script.

SET ENCRYPTION IDENTIFIED BY "foadbbackup23" ONLY;

Replace with 

SET ENCRYPTION ON;





If you like please follow and comment