Transportable Tablespace in Oracle - TTS - Database Migration Using TTS Simple Steps
ฝัง
- เผยแพร่เมื่อ 17 ส.ค. 2020
- We have 2 database in 2 different pc
S1=
---
ip address : 192.168.0.181
hostname : pc181.oracle.com
SID : catdb
Now create tablespace (sales) , create a user with default tablespace sales
login as new user create a table , insert few records.commit it.
our target transport this tablespace (sales) to another pc (T1)
sales tablespace=datafile+metada(datafile copy to 2nd pc by scp/ftp....and metadat by expdp)
$ expdp system directory=data_pump_dir dumpfile=sales.dmp transport_tablespaces=sales
T1=
---
---
ip address : 192.168.0.182
hostname : pc182.oracle.com
SID : prod
sales datafile location /u01/app/oracle/oradata/prod/sales01.dbf
sales.dmp dumpfile location data_pump_dir(/u01/app/oracle/admin/catdb/dpdump/sales.dmp)
now use impdp to insert metadata to local db datadictioary and relation between data and metadata)
check my video and steps::::
#TTS #TransportableTablespace #Migration
Please do follow me and support me on,
LinkedIn: / mallik034
TH-cam: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Email: malluramadurg@gmail.com
LinkedIn: / mallik034
TH-cam: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
![[안방1열 풀캠4K] 베이비몬스터 'FOREVER' (BABYMONSTER FullCam)│@SBS Inkigayo 240707](http://i.ytimg.com/vi/_2HL-ogzzBU/mqdefault.jpg)
Thanks for sharing good video.
You are welcome.
Very informative
Thanks
Thanks for sharing vedio it help for us.
& Please make vedio for expdp & impdp related
Sure I will do it one session on expdp and impdp.
Would you please do a video on Zero downtime patching in 19.3 rac database?
Very good presentation. Can the Source DB be Oracle 11.2.0.4 on Linux (64-Bit) and Target be Oracle 19c on Linux (64-Bit)?
Good👍
Thanks and keep watching my videos and also do share with your friends and colleagues.
i have 2 questions :
1.what is difference in normal export/import and transortable tablespace bcz same export/import of a tablespace we can do with exp/imp ?
2.tablespace you are taking export remains unavilable for write operations during this ...?
plz reply
This is really great.. so in case of ASM storage we have to copy all the datafile from source nd paste in on target server.nd also should mention all the datafiles in transportable_datafile clause will importing .. correct.. when this kind of method is recommended .. for what db size .
If DB size is huge then go for transportable_datafile else go for RMAN restore
How to transfer datafiles from source asm to target asm?
@malliko34 why should I use transportable tablespaces if I could do a normal export and create the necessary objects like the user, profile, tbs, roles, etc then import? What's the benefits of using transportable tablespaces and the normal approach I talked about above?
If you are doing 100TB database migration then export and import will take months where as TTS will complete within a day or 2 days.
@@Mallik034 Ok but how to take full database (on Linux Server) and migrate to another database(on Windows Server)
You no need to take manual RMAN backup.
XTTS as automated script which will take rman backup from linux and which is compatible with Windows.
pls refer these below MOS document
1166561.1
1389592.1
I have my database 11.2.0.1 I want o upgrade it to 11.2.0.4 without downtime can please guide me on this one
Are planning to upgrade on the same server?
Use golden gate or transportable tablespace
@@Mallik034 I want the best possible way to get zero down time its a rac
@@mughees52 Goldengate and datapump is the best option you have because of the version differences