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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s