-- 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