Database Backup and Recovery (MOSC)

MOSC Banner

rman duplicate and skip tablespace

edited Jun 30, 2009 3:42AM in Database Backup and Recovery (MOSC) 2 commentsAnswered
 Hi,
I am duplicating a db (idm1d) to another db (dbt1).

allover the duplication is file but there are issues with the skip tablespaces

in the duplicate script I had mentioned
SKIP TABLESPACE drsys,cwmlite,xdb ,SAMURAI_PROD,HORDE_DEV

it worked fine but in the duplicated db I see footprints of the skip tablespaces , not sure what can be done

SQL>  select file_name,tablespace_name ,bytes/1048576 bts from dba_data_files;

FILE_NAME                                                   TABLESPACE_NAME             BTS
---------------------------------------------                                         ------------------------------ ----------
/oradata/idm1d/dbt1/system_01.dbf                  SYSTEM                                800
/oradata/idm1d/dbt1/undotbs_01.dbf                 UNDOTBS                              2048
/orabase/product/9.2.0.8/dbs/MISSING00003     DRSYS

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center