RMAN-05589: Materialized objects in skipped tablespaces prevent duplication
Cause:
This error occur due to the materialized views in tablespace which prevents duplication process
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 02/17/2021 08:37:41
RMAN-05501: aborting duplication of target database
RMAN-05589: Materialized objects in skipped tablespaces prevent duplication
Workaround:
I find very rare resource in google for this issue nor i couldnt skip the tablespace which contain materialized views
Only workaround suggested by oracle is to include the tablespace having MV and drop it after duplication