Oracle Database 11gR2 Migration/Upgrade to 19c using Data Pump

[@abukanu1614]

You're absolutely one of the best I've ever watched.

[@bobsukki]

Thank you! I appreciate

[@SureshKumar-no3eo]

very informative, Hi Sir Your vedios are very good and helpful for us.

[@jeanbaptiste323]

Good stuff grand frere. JB here.

[@bobsukki]

Thank you JB 🙏🏽

[@jeanbaptiste323]

Just subscribed as well.

[@samamjgrake2291]

This is really helpful thank you Ni TSOH. Please can you make a video on upgrading a CDB.

[@bobsukki]

I am glad you liked it... I am working a few other things at the moment. I certainly could make a CBD upgrade video when time permits. Thank you 🙏

[@rowlandjones3872]

really good material, thanks

[@OliverShey]

This is gold!!!! Thanks

[@bobsukki]

Glad you enjoyed it!

[@habtamutamir4918]

It's quite interesting. Would you please provide one video on cross platform transportable tablespace with incremental backup set to reduce downtime of the database on database migration.

[@bobsukki]

I will see what I can do about that! Thank you

[@MA-lo4xk]

As you are excluding most of the schemas , do we need full=y export? Why not just export(include) the application schema only (must smaller list) and thats it, instead of having a long list of excluded shemas? Your thoughts much appreciated. Thank you

[@bobsukki]

You could do that too.

[@MA-lo4xk]

Great video thank you for sharing sir. Out of interest what about roles and privaleges or anything , will they be included the export/import? Secondly instead of creating a new dump directory can we not use the one already there? thank you

[@bobsukki]

Yes, absolutely

[@badscrew4023]

Good stuff!

[@bobsukki]

Thanks!

[@lizbeseka152]

Super helpful!

[@bobsukki]

Thank you 🙏🏽

[@suryaardi8400]

Is role automatically created on target or will be created manually?

[@hasan6964]

Thanks alot, it was really helpful. one question though you exclude statistics and didn't import it?

[@bobsukki]

Yes... particularly for data refreshes only. Excluding stats will improve speed of export as by defaut this is included. That said, your choice will be driven by your enviromens needs as sometimes if you exclude stat, you might find that you are missing some indexes.

[@albertoguilberto8194]

Love your channel video 👍🏽

[@bobsukki]

Thanks so much! 🙏🏽

[@Best_Stocks]

Is this method feeasible for 7TB db?

[@bobsukki]

I would not recommend this method for large databases as this will require alot of time for the exp and imp processes. If you choose to, it will require alot of resources and parallelism

[@MA-lo4xk]

Should we be doing export and import as sysdba? I thought oracle does not recommend this?

[@bobsukki]

Yes we can, it depends, especially when I am doing a Full=Y. Otherwise, use the SYSTEM user

[@cookiedough3199]

Thank you so much for this very informative video Quick question, you mentioned in the video that you wouldn't want to replace the system and sys schema from 19c with that of 11g , so why did you not exclude sys and system from your export? looks like you included sys, system, sysman, dbsnmp etc... which are all Oracle-maintained. I'd like to know if I should exclude my sys and system users Thank you!

[@bobsukki]

Great catch, I noticed I should have included sys and system schemas in the exclude schema clause of the parfile. Please add them to your parfile. I added them to the exclude clause in the video notes 👍🏾👍🏾

[@fabianalbertoloerasalas659]

is it just enough if I exclude just SYS and SYSTEM schemas?

[@bobsukki]

Yes you can! 👌🏽

[@jawidtalash3645]

Thanks alot for the wonderful video,I followed the same step and face with the below issue please guide what can be the reason. i have taken the backup from 11g database and restored it in 19c but after comparison there was 3gb data difference,what can be the issue please reply.

[@bobsukki]

Try using this sql statement on both databases to compare and identify the schemas with different sizes... SELECT OWNER, SUM(BYTES)/1024/1024/1024 SIZE_IN_GB FROM DBA_SEGMENTS GROUP BY OWNER;

[@jawidtalash3645]

@@bobsukki Thanks alot Sir, now it shows the difference 300MB,I think it should be ok now.

[@khaleemoozeer5224]

Resourceful video. However I would like to know if i can use this video for migrating oracle11g grid infrastructure to 19C grid infrastructure. Please help.

[@bobsukki]

I am glad you found it resourceful. Yes, you can use thesame methodology with an 11g to 19c RAC database migration scenario 👍🏾