rman duplicate and skip tablespace
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
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
0