Transportable Tablespace from RMAN backup.
Assumptions
* Tablespace name=TTBS
* Same platform (source and target)
* We have RMAN backup of the database
RMAN> transport tablespace TTBS
tablespace destination ‘/opt/oracle/ttbs_dir’
auxiliary destination ‘/opt/oracle/aux_ttbs’
datapump directory DATA_PUMP_DIR
dump file ‘expdp_ttbs_01.dmp’
import script ‘impdp_ttbs_01.sql’
export log ‘expdp_ttbs.log’;
Explanation:
tablespace destination – in this location RMAN stores datafiles of the TTBS
auxiliary destination – in this location RMAN creates temporary database and later deletes it.
datapump directory – in this export dump of metadata of TTBS is stored
dump file – Name of the datapump dump file
import script – RMAN creates import file which can be used to import the metadata
Possible Error:
While importing i got the below error. i just created the user_name in the database.
ORA-29342: user user_name does not exist in the database
