DUPLICATE SKIP TABLESPACE failes RMAN-05586 RMAN-05587 RMAN-05588 RMAN-05589 (Doc ID 1287276.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.2.0.2 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 16-Apr-2014***

Symptoms


RMAN DUPLICATE - SKIP TABLESPACE failes with Error:
.
RMAN-05589: Materialized objects in skipped tablespaces prevent duplication


Recovery Manager: Release 11.2.0.2.0 - Production on Tue Jan 25 11:59:28 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

RMAN-06005: connected to target database: FCN (DBID=1665110539)
RMAN-06549: connected to auxiliary database: FCNDUP (not mounted)
...
run {
set until time "to_date('24-JAN-2011:16:15:00', 'DD-MON-YYYY:HH24:MI:SS')" ;

SET NEWNAME FOR DATABASE TO '/u01/app/oracle/oradata/FCNDUP/%b';
SET NEWNAME FOR TEMPFILE 1 TO '/u01/app/oracle/oradata/FCNDUP/tempfile01.dbf' ;

DUPLICATE TARGET DATABASE
TO FCNDUP
SKIP TABLESPACE
'EXAMPLE',           # This Tablespace contains "MATERIALIZED VIEWS"
'RCVCAT',
'DATA'
LOGFILE
GROUP 1 ('/u01/app/oracle/oradata/FCNDUP/redo01a.log',
'/u01/app/oracle/oradata/FCNDUP/redo01b.log') SIZE 4M REUSE,
GROUP 2 ('/u01/app/oracle/oradata/FCNDUP/redo02a.log',
'/u01/app/oracle/oradata/FCNDUP/redo02b.log') SIZE 4M REUSE,
GROUP 3 ('/u01/app/oracle/oradata/FCNDUP/redo03a.log',
'/u01/app/oracle/oradata/FCNDUP/redo03b.log') SIZE 4M REUSE ;
}
...
...
RMAN-06199: database mounted
RMAN-05547: Checking that duplicated tablespaces are self-contained
RMAN-05586: The following materialized objects were found in skipped tablespaces
RMAN-05587: Materialized table CAL_MONTH_SALES_MV on tablespace EXAMPLE
RMAN-05587: Materialized table FWEEK_PSCAT_SALES_MV on tablespace EXAMPLE
RMAN-05588: Materialized index FWEEK_PSCAT_SALES_MV on tablespace EXAMPLE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/25/2011 12:00:39
RMAN-05501: aborting duplication of target database
RMAN-05589: Materialized objects in skipped tablespaces prevent duplication

Recovery Manager complete.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms