Thứ Hai, 29 tháng 5, 2017

Transport tablespace in pluggable database cross platform

-- Transport tablespace in pluggable database cross platform
1/ From source
SYS@CDB>alter tablespace example read only;
2/ From source
RMAN> backup to platform 'IBM Power Based Linux' format '/tmp/example.bk' tablespace ncdb:example datapump format '/tmp/example.dmp' ;

Starting backup at 29-MAY-17
using channel ORA_DISK_1
Running TRANSPORT_SET_CHECK on specified tablespaces
TRANSPORT_SET_CHECK completed successfully

Performing export of metadata for specified tablespaces...
   EXPDP> Starting "SYS"."TRANSPORT_EXP_CDB_Cwfz":
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/TYPE/TYPE_SPEC
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/TYPE/TYPE_BODY
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/PROCACT_INSTANCE
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/XMLSCHEMA/XMLSCHEMA
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/TABLE
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/GRANT/OWNER_GRANT/OBJECT_GRANT
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX/INDEX
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX/FUNCTIONAL_INDEX/INDEX
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/COMMENT
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/REF_CONSTRAINT
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX/BITMAP_INDEX/INDEX
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/TRIGGER
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/STATISTICS/MARKER
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PROCACT_INSTANCE
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PROCDEPOBJ
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
   EXPDP> Master table "SYS"."TRANSPORT_EXP_CDB_Cwfz" successfully loaded/unloaded
   EXPDP> ******************************************************************************
   EXPDP> Dump file set for SYS.TRANSPORT_EXP_CDB_Cwfz is:
   EXPDP>   /u01/app/oracle/product/12.1.0/dbhome_1/dbs/backup_tts_CDB_67093.dmp
   EXPDP> ******************************************************************************
   EXPDP> Datafiles required for transportable tablespace EXAMPLE:
   EXPDP>   /u01/app/oracle/oradata/CDB/orcl/example01.dbf
   EXPDP> Job "SYS"."TRANSPORT_EXP_CDB_Cwfz" successfully completed at Mon May 29 14:25:57 2017 elapsed 0 00:01:31
Export completed

channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00050 name=/u01/app/oracle/oradata/CDB/orcl/example01.dbf
channel ORA_DISK_1: starting piece 1 at 29-MAY-17
channel ORA_DISK_1: finished piece 1 at 29-MAY-17
piece handle=/tmp/example.bk tag=TAG20170529T142415 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting full datafile backup set
input Data Pump dump file=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/backup_tts_CDB_67093.dmp
channel ORA_DISK_1: starting piece 1 at 29-MAY-17
channel ORA_DISK_1: finished piece 1 at 29-MAY-17
piece handle=/tmp/example.dmp tag=TAG20170529T142415 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 29-MAY-17
3/ copy to dest
4/ Import to CDB2
[oracle@edd1r2p1 sales]$ rman target sys/oracle@pdb3_3

RMAN> restore foreign tablespace example format '/u01/app/oracle/oradata/CDB2/PDB3_3/CDB2/502D38BBAFF53BA4E0530100007FFEE3/datafile/example.dbf' from backupset '/tmp/example.bk' dump file from backupset '/tmp/example.dmp';
5/ change to read write
SYS@CDB2>select tablespace_name,status from dba_tablespaces;

TABLESPACE_NAME       STATUS
------------------------------ ---------
SYSTEM       ONLINE
SYSAUX       ONLINE
TEMP       ONLINE
TBS1       ONLINE
EXAMPLE       READ ONLY
SYS@CDB2>alter tablespace example read write;

Tablespace altered.

SYS@CDB2>select * from hr.regions;

 REGION_ID REGION_NAME
---------- -------------------------
1 Europe
2 Americas
3 Asia
4 Middle East and Africa



Không có nhận xét nào:

Đăng nhận xét