I need to restore an audit table from a database, so I was trying to do a
duplicate / skip tablespace.
Works fine till the end when I get this:
Checking that duplicated tablespaces are self-contained
The following materialized objects were found in skipped tablespaces
Materialized table COWPERF_MVIEW on tablespace COWS_DATA
Materialized table EUL5_MV437988 on tablespace PROD_10GR2_END_USER_DATA
Materialized table MV_TTTL_PRF_CUM_PERF on tablespace PARIS_DATA
Materialized index COWPERF_MVIEW on tablespace COWS_DATA
Oracle instance started
RMAN-03002: failure of Duplicate Db command at 08/22/2016 09:53:08
RMAN-05501: aborting duplication of target database
RMAN-05589: Materialized objects in skipped tablespaces prevent duplication
For some ODD reason, Oracle requires you to restore tablespaces that have
Materialized Views, even if the MVs aren't at all related to the schema or
object you are attempting to retrieve. I'm a bit in shock as the
application schemas are well defined and self contained but at the same
time, they are LARGE and I don't want to restore those freaking tablespaces
since I don't need any of that data. Unreal.
*Restriction Note: *
You MUST NOT exclude
- SYS-owned objects
- or tablespaces with rollback segments,
- nor tablespaces containing "MATERIALIZED VIEWS"!
