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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment