Transportable

Monitor progress of Oracle Data Pump impdp

This blog post is a quick brain dump. I realized that I have so many “blog posts to write” that I need to dump the ideas or information much quicker. So, feel free to comment and correct. These queries may be useful when you run a larger import, and you would like to monitor progress of Oracle Data Pump impdp.

Monitor Data Pump progress during impdp

To monitor the progress of Data Pump during impdp you can use the following queries.

What object types are left?

select unique object_type_seqno, object_type
from system.sys_import_full_01
where 
Continue reading...

Virtual Classroom Seminar 12: Migrating Very Large Databases on Dec 9, 2021

It looks to me that every possible event in 2021 happens in October/November/December 2021. No complaint from my side – but just in case you wonder about so little update activity on our blogs since weeks. We are just so busy in delivering virtual seminars. Which is good – but it requires lots of effort on our side as we want to deliver decent quality and real tech content. And now, since the year is almost at its end, it is time for our final Virtual Classroom Seminar 12: Migrating Very Large Databases on Dec 9, 2021 this year.

Virtual Classroom Seminar 12: Migrating Very Large Databases  on Dec 9, 2021

Photo

Continue reading...

PERL scripts for large migrations supported on all platforms (except Windows)

This topic fits very well as I present about +100 TB migrations today at the “Harmony” User Group Conference in Finland.

Finland May Helsinki 2017

Finland in May

The question whether the PERL scripts for RMAN incrementally rolled forward backups we deliver via MOS Note 1389592.1 (11G – Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup) will be supported for migrations to non-Exadata systems such as Oracle SuperCluster as well.

And yes, now we got an update into the note saying:

Although preferred destination system is Linux (either 64-bit Oracle Linux or a certified version of RedHat Linux), this procedure can be used

Continue reading...

Full Transportable Export/Import – Things to Know

This blog post is an addition to:

Seth Miller commented the pitfall of having a serious issue during the Data Pump run, Data Pump exiting and not finishing, and you’ll have to do the entire backup/restore/incremental-roll-foward thing again. Without any doubt, this is no fun at all.

So let me point out a few things to take into consideration – and some of them are not obvious I guess.

Do you need to backup/restore/incremental-roll-forward again?

When you let do Data Pump all the manual …

Continue reading...