RMAN Convert Transportable with Data Pump Highlevel step by step actions

 Dear All,

In this post i am sharing RMAN Convert Transportable with Data Pump .

ON-PREM

• Check the DPUMP_DIR already exists

 • Alter tablespace dbaltab read only;

 expdp system/oracle12@oracleprem:1539/xepdb1 TRANSPORT_TABLESPACES=DBALTAB TRANSPORT_FULL_CHECK=YES DIRECTORY=dpump_dir dumpfile=exp_dbaracsinfo_con_tts.dmp logfile=exp_dbaracsinfo_con_tts.log

$mkdir -p /opt/oracle/conv_df

 RMAN> CONVERT TABLESPACE DBALTAB to platform='Linux x86 64-bit' format '/opt/oracle/conv_df/%U';

$scp -i /home/oracle/.ssh/id_rsa /opt/oracle/dumps/exp_dbaracsinfo_con_tts.dmp oracle@120.41.126.36:/u01/app/oracle/admin/export/.

$ scp -i /home/oracle/.ssh/id_rsa /opt/oracle/conv_df/data_D-XE_I-2908503447_TS[1]DBALTAB_FNO-14_01uk3kl3 oracle@120.41.126.36:/u01/app/oracle/admin/export/.

SQL> Alter tablespace dbaltab read write;

 On OCI

SQL> Drop user dbaracsinfo cascade;

SQL> Drop tablespace dbaltab including contents and datafiles;

• Create directory dpump_dir as ‘/u01/app/oracle/admin/export’;

 • Select name from v$datafile , get the path

 cp /u01/app/oracle/admin/export/data_D-XE_I-2908503447_TS-DBALTAB_FNO[1]14_01uk3kl3 +DATA/OCI18_FRA1B5/9A182239BFCB2161E0530200000AF690/DATAFILE/dbaltab01.d bf

• Create the user on destination environment

SQL>  create user dbaracsinfo identified by OCIDbsytem007## temporary tablespace temp;

SQL> Grant create session to dbaracsinfo;

 User created.

 • Perform the import

 $ impdp system/OCIdbasystem2##@10.1.0.2:1521/pdb1.sub12192155370.vcndbal.oraclevcn.c om DIRECTORY=dpump_dir TRANSPORT_DATAFILES='+DATA/OCI18_FRA1B5/9A182239BFCB2161E0530200000AF6 90/DATAFILE/dbaltab01.dbf' dumpfile=exp_dbaracsinfo_con_tts.dmp

Login check data and make the tablespace as read write

 SQL> alter tablespace dbaltab read write;

Tablespace altered

Thanks,

Srini