My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.