{データポンプ}トランスポータブル表領域

演習

 

https://docs.oracle.com/cd/F19136_01/admin/transporting-data.html#GUID-F7B2B591-AA88-4D16-8DCF-712763923FFB
https://docs.oracle.com/cd/F19136_01/bradv/creating-transportable-tablespace-sets.html#GUID-123F4E45-0324-4D1D-980F-E176A9E22C87


-- PDB11 PDB12 PDB13
alter session set container=pdb11;
alter session set container=pdb12;
alter session set container=pdb13;


create directory ORA_DIR as '/home/oracle';
select * from all_directories;

 

     Data Pumpトランスポータブル表領域

 


-- PDB11
COLUMN PLATFORM_NAME FORMAT A40
COLUMN ENDIAN_FORMAT A14
 
SELECT PLATFORM_ID, PLATFORM_NAME, ENDIAN_FORMAT 
  FROM V$TRANSPORTABLE_PLATFORM
  ORDER BY PLATFORM_ID;


col con_name format a10
select CON_ID,CON_ID_TO_CON_NAME(CON_ID) con_name, tablespace_name,plugged_in, status
from cdb_tablespaces
where tablespace_name = 'TBS01'
;


ALTER TABLESPACE TBS01 READ ONLY;

expdp system/oracle@localhost:1523/pdb11.example.com dumpfile=tts.dmp directory=ORA_DIR transport_tablespaces=TBS01

rman target / 

CONVERT TABLESPACE pdb11:TBS01
TO PLATFORM 'Linux x86 64-bit'
FORMAT '/home/oracle/%U';

cp -p /home/oracle/data_D-ORCL_I-1717115726_TS-TBS01_FNO-49_m13hbqhq /oradata/orcl/pdb12/tbs01.dbf


ALTER TABLESPACE TBS01 READ write;

 

 

-- PDB12

impdp system/oracle@localhost:1523/pdb12.example.com dumpfile=tts.dmp directory=ORA_DIR TRANSPORT_DATAFILES=/oradata/orcl/pdb12/tbs01.dbf


col con_name format a10
select CON_ID,CON_ID_TO_CON_NAME(CON_ID) con_name, tablespace_name,plugged_in, status
from cdb_tablespaces
where tablespace_name = 'TBS01'
;

ALTER TABLESPACE TBS01 READ WRITE;

 

     RMANトランスポータブル表領域


-- PDB11

col con_name format a10
select CON_ID,CON_ID_TO_CON_NAME(CON_ID) con_name, tablespace_name,plugged_in, status
from cdb_tablespaces
where tablespace_name = 'TBS02'
;

rman target / 

TRANSPORT TABLESPACE pdb11:TBS02
   TABLESPACE DESTINATION '/home/oracle'
   AUXILIARY DESTINATION '/tmp';


cp -p /home/oracle/tbs02.dbf /oradata/orcl/pdb13/tbs02.dbf

 

 


-- PDB13

impdp system/oracle@localhost:1523/pdb13.example.com dumpfile=dmpfile.dmp directory=ORA_DIR TRANSPORT_DATAFILES=/oradata/orcl/pdb13/tbs02.dbf


col con_name format a10
select CON_ID,CON_ID_TO_CON_NAME(CON_ID) con_name, tablespace_name,plugged_in, status
from cdb_tablespaces
where tablespace_name = 'TBS02'
;

ALTER TABLESPACE TBS02 READ WRITE;