Transportable Tablespace from RMAN backup.
Assumptions* Tablespace name=TTBS* Same platform (source and target)* We have RMAN backup of the database
RMAN> transport tablespace TTBStablespace destination ‘/opt/oracle/ttbs_dir’auxiliary destination ‘/opt/oracle/aux_ttbs’datapump directory DATA_PUMP_DIRdump 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 TTBSauxiliary destination – in this location RMAN creates temporary database and [...]
Archive for the ‘Transportable TBS’ Category
Transportable TBS – Part 3
Posted in Transportable TBS on February 4, 2008 | Leave a Comment »
Transportable TBS – Part 2
Posted in Transportable TBS on January 26, 2008 | Leave a Comment »
Assumptions* Tablespace name: TTBS* Source platform: Linux (32 bit)* Target platform: Solaris (64 bit)
To Identify the endian formatselect d.platform_name, endian_formatfrom v$transfortable_platform tp, v$database dwhere tp.platform_name=d.platform_name;
List of all platform and respective endian formatselect * from v$transfortable_platform order by platform _id;
Source Machine
1. check tablespace is transprtablea. execute this procedureexec dbms_tts.transport_set_check=(‘ttbs’,true);
b. check for any violationsselect * from transport_set_violations;
2. [...]
Transportable TBS – Part 1
Posted in Transportable TBS on January 26, 2008 | Leave a Comment »
Assumptions* Tablespace name=TTBS* Same platform (source and target) Source Machine1. check tablespace is transprtable a. execute this procedure exec dbms_tts.transport_set_check=(‘ttbs’,true);b. check for any violationsselect * from transport_set_violations;
2. Make tablespace read onlyalter tablspace ttbs read only;
3. Identify the datafilesselect file_name from dba_data_files where tablespace_name=’TTBS’;
4. Export tablespace’s metadataexpdp directory=dump1 dumpfile=expdp_ttbs.dmp transportable_tablespace=ttbs logfile=expdp_ttbs.log job_name=j15. Copy datafile and export [...]
