Oracle Database Migration Methods - Goldengate, Transportable Tablespace, RMAN, Export - Import & DG

Подписаться 21 тыс.

Просмотров 23 тыс.

50% 1

Oracle Database Migration Methods - Goldengate, Transportable Tablespace, RMAN, Export - Import & DG
======================================================
GoldenGate Replication (Similar Tools)
Cross Platform Transportable Tablespaces (XPTTS)
- TTS (Simple Method)
- Fast XPTTS (with incremental backups) - 1389592.1
RMAN Backup/Restore
- RMAN backup and restore
• Database Migration Doc...
- RMAN (with incremental backups)
Export and Import
- Traditional
- Data Pump
5) Data Guard (heterogeneous dataguard)
#Migration #TTS #GG #DG #RMAN #Export #Import
Please do follow me and support me on,
LinkedIn: / mallik034
RU-vid: / 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
RU-vid: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg

Опубликовано:

8 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 42

@sahaniarunitm 3 года назад

Untouched topic you are delivering on internet, appreciate !

@Mallik034 3 года назад

Thank you. Keep watching my sessions and also share with all your friends and colleagues

@saisruthi9609 3 года назад

Thanks crystal clear explanation.

@Mallik034 3 года назад

Glad it was helpful!

@sairamakrishna5995 3 года назад

Thank you so much for uploading such a great stuff down to earth sir thank you

@Mallik034 3 года назад

You are welcome

@ManojYadav-lw8tu 3 года назад

Excellent explanation.

@Mallik034 3 года назад

Thanks

@eswar6311 3 года назад

Tnq Mallik

@gopikanagal2141 3 года назад

great efforts liked ur blogs and videos

@Mallik034 3 года назад

Thanks

@rithikachella 3 года назад

Excellent explanation

@Mallik034 3 года назад

Thanks

@sahaniarunitm 3 года назад

very nice content !

@Mallik034 3 года назад

Thank you! Keep watching my videos

@krish_djn 3 года назад

Good share.

@Mallik034 3 года назад

Thank you! Cheers!

@ajayyadav-nl6bw 3 года назад

Nice explain & please make one more. Vedio for rac upgradation also

@Mallik034 3 года назад

Sure I will

@clearvibesme 2 года назад

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?

@BHARARHROYAL 3 года назад

Good explanation. Please make one video of solaris to Linux migration with transportable tablespace method.

@Mallik034 3 года назад

Sure Bharath, I will try to do

@ankush_in_sync5998 Год назад

Sir can you tell me which type of commands and shell scripts are required for Oracle data migration?

@sowmyaananthoju9893 2 года назад

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?

@andelakshmipathi2389 3 года назад

Nice explanation, thank you so much, can you please give me demo on rman xptts method

@Mallik034 3 года назад

Tomorrow I am uploading a video on normal TTS. I Will upload very soon on xptts with incremental backup.

@srisp12 2 года назад

Can we migrate from 12c non cdb database to 19c non cdb using cloning or duplicate database method through network link

@ajeshkumar8560 Год назад

Can we do complete data migration from 12c to 19c using rman duplicate, my data size is of 2tb, Request u to plz suggest

@jamshedkhan6121 2 года назад

but while using rman icrementl why downtime required?

@anujsharma9952 3 года назад

Xptts with incremental option is not available on 11g correct?I believe it’s available from 12 c onwards

@Mallik034 3 года назад

Yes but there some backend option in 11g but it is not recommended

@andelakshmipathi2389 3 года назад

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) ?

@Mallik034 3 года назад

Yes we need to create all the users manually.

@theans786 3 года назад

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

@Mallik034 3 года назад

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)

@rehantayyab82 2 года назад

how to migrate 10tb database from solaris to linux ?

@pravinmore3542 3 года назад

HI malik,do u have video of oracle 12 migration from hp ux to linux platform

@Mallik034 3 года назад

No I have not yet one video on that. Noted your request & I will plan to do one on that

@rehantayyab82 3 года назад

@@Mallik034 plz try to make this video , specially migration of rac db from hp-ux to linux

@zulalinho007 2 года назад

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