Present we are using this Delta history, SRM table, Transformation table to check dml type, date modified, source value, transformation .we need automation script without checking this all steps?
Small query, I tried to migrate from 12.2 to 19c using rman xptts (with incremental), at the final step importing metadata it throws error, user deosn't exit, Do we need to create all users with default tablespaces in target as same as source database ? could please tell me which takes less downtime when compared Fast XPTTS and Fast XPTTS (incremental backup) ?
Sir we are using xtts method to do cross platform migration. The one challenge we are facing is during the cut over the final incremental backup and restore takes more time. It takes hours to complete. Is there any way to speed up this. Also for a 13 TB database to get migrated how much resources is required on the target server in terms of cpu and memory
Hi Thameem, You can increase parallel threads to increase or speedup the restore and also restore depends on the Target server CPUs and Cores. In my case 45 TB restore used to take 5 to 7 hours. Restore also depends on the notwork speed and Target servers performance. For 13TB restore on Target Server I recommend. Memory: 64 GB to 128 GB (Min) Core / CPUs : Depends on the customer (Recommended go for min 16 CPUs)
Hi, thank you for your video. I used Doc ID 2471245.1 for migration of 12.2 oracle database on AIX to same version to Linux x86_64, and on phase 5 while importing metadata , impdp fails with ora-39123 and ora-29342. Do you have any idea how to resolve this problem? Thanks
Untouched topic you are delivering on internet, appreciate !
Thank you. Keep watching my sessions and also share with all your friends and colleagues
Thanks crystal clear explanation.
Glad it was helpful!
Excellent explanation.
Thanks
Excellent explanation
Thanks
Sir can you tell me which type of commands and shell scripts are required for Oracle data migration?
Thank you so much for uploading such a great stuff down to earth sir thank you
You are welcome
Good share.
Thank you! Cheers!
great efforts liked ur blogs and videos
Thanks
Tnq Mallik
Nice explain & please make one more. Vedio for rac upgradation also
Sure I will
very nice content !
Thank you! Keep watching my videos
Nice explanation, thank you so much, can you please give me demo on rman xptts method
Tomorrow I am uploading a video on normal TTS. I Will upload very soon on xptts with incremental backup.
Present we are using this Delta history, SRM table, Transformation table to check dml type, date modified, source value, transformation
.we need automation script without checking this all steps?
Good explanation. Please make one video of solaris to Linux migration with transportable tablespace method.
Sure Bharath, I will try to do
Can we do complete data migration from 12c to 19c using rman duplicate, my data size is of 2tb, Request u to plz suggest
What if the 11g source database is encrypted TDE and MEK is stored in HSM and want to migrate to EXACC.. which method u prefer?
Can we migrate from 12c non cdb database to 19c non cdb using cloning or duplicate database method through network link
Xptts with incremental option is not available on 11g correct?I believe it’s available from 12 c onwards
Yes but there some backend option in 11g but it is not recommended
but while using rman icrementl why downtime required?
how to migrate 10tb database from solaris to linux ?
Small query, I tried to migrate from 12.2 to 19c using rman xptts (with incremental), at the final step importing metadata it throws error, user deosn't exit, Do we need to create all users with default tablespaces in target as same as source database ?
could please tell me which takes less downtime when compared Fast XPTTS and Fast XPTTS (incremental backup) ?
Yes we need to create all the users manually.
Sir we are using xtts method to do cross platform migration. The one challenge we are facing is during the cut over the final incremental backup and restore takes more time. It takes hours to complete. Is there any way to speed up this. Also for a 13 TB database to get migrated how much resources is required on the target server in terms of cpu and memory
Hi Thameem,
You can increase parallel threads to increase or speedup the restore and also restore depends on the Target server CPUs and Cores.
In my case 45 TB restore used to take 5 to 7 hours.
Restore also depends on the notwork speed and Target servers performance.
For 13TB restore on Target Server I recommend.
Memory: 64 GB to 128 GB (Min)
Core / CPUs : Depends on the customer (Recommended go for min 16 CPUs)
HI malik,do u have video of oracle 12
migration from hp ux to linux platform
No I have not yet one video on that. Noted your request & I will plan to do one on that
@@Mallik034 plz try to make this video , specially migration of rac db from hp-ux to linux
Hello.
May you share your script?
Thank you.
Already shared script on our Telegram group @mallik034.
Hope you already got that
Hi, thank you for your video. I used Doc ID 2471245.1 for migration of 12.2 oracle database on AIX to same version to Linux x86_64, and on phase 5 while importing metadata , impdp fails with ora-39123 and ora-29342. Do you have any idea how to resolve this problem?
Thanks