Full Transportable Export/Import

We are hiring: Software Development Senior Director “Database Utilities”

Posted on August 5, 2021 by Mike.Dietrich General 0

This is the first time that I send out such a blog post. But since many of you read this blog, and a high number of people follow me on LinkendIn, maybe you’ll be interested as We are hiring: Software Development Senior Director “Database Utilities”. And it could be you!

We are hiring: Software Development Senior Director "Database Utilities"

Photo by Alessandro Erbetta on Unsplash

I can tell you by heart that you’d join one of the best teams in Oracle.

So please read the job description here – and if your profile matches plus you are looking for a new challenge, you should apply right away. You …

Fallback Strategies with Full Transportable Export/Import

Posted on March 2, 2018 by Mike.Dietrich Fallback Transportable 3

I received an interesting question about how to implement Fallback Strategies with Full Transportable Export/Import several times within the past weeks. So it may be a good idea to showcase some possible scenarios.

Full Transportable Export/Import is an Oracle 12c feature which allows you to do a transportable tablespace migration but Data Pump will take away all the manual steps with only one command. You may need to have markers to revert to in order to avoid restarting the entire operation from scratch again.

And there are some special behaviors to know about, at first with Full Transportable Export/Import but …

Transportable Tablespaces – Does it work between SE2 and EE?

Posted on November 14, 2017 by Mike.Dietrich Transportable 2

Transportable Tablespaces - Does it work between SE2 and EE? I thought I had blogged about this topic already. But it seems to be that I stored this information somewhere else. Randomly I receive this question: Oracle Transportable Tablespaces – Does it work between SE2 and EE?

In addition often the question gets precised: Does it work in both directions or just one-way?

Transportable Tablespaces and Full Transportable Export/Import

Please find more information about these two very common Oracle database migration features:

Transportable Tablespases: Character Sets – Same same but different? (May 25, 2016)
Transportable Tablespaces and Read-Only in Oracle 12c (Dec 2, 2016)
Full Transportable Export/Import – Things

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

Posted on May 18, 2017 by Mike.Dietrich Transportable Uncategorized 5

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

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 …

Can you EXCLUDE tablespaces from Full Transportable Export/Import?

Posted on May 17, 2017 by Mike.Dietrich Transportable 16

Question: Can you EXCLUDE one or more tablespaces when doing a Full Transportable Export/Import?

First of all, this question came up already twice in real world customer migrations. So it’s not a totally unusual question. In one case a tablespace called USERS got precreated and some data did get stored. In the second case we did use RMAN incremental backups to migrate a very large database (>100TB) and some tablespaces weren’t part of the backup set.

I did brainstorm with Roy – and I dug into my notes from some years ago when the question was raised to me as …

Hands-On Lab available: Upgrade to Oracle Database 12.2.0.1

Posted on March 29, 2017 by Mike.Dietrich Hands-On Lab Oracle Database 12.2.0.1 17

Thanks to Roy – our Hands-On Lab “Upgrade, Migrate and Consolidate to Oracle Database 12.2” is now available for download from OTN.

Instructions and technical requirements are clearly documented on the OTN page as well. The lab is based on Virtual Box and can be easily imported upon download and unzip.

You can always access the lab via the blog’s top menu as well:

Hands-On Lab – Access via the Blog

Inside the lab you’ll find :

UPGR – an Oracle 11.2.0.4

Transportable Tablespaces and READ ONLY in Oracle Database 12c

Posted on December 2, 2016 by Roy.Swonger Data Pump Time Zone - DST Transportable 1

We recently worked with a customer who noticed that they were not able to use transportable tablespaces to connect the same tablespace data files to two databases at the same time, even after setting the tablespaces READ ONLY in SQL*Plus. This is new behavior in 12c, and many customers are not yet aware of this change. Here are the details of what changed, why, and how you might want to deal with it if the changes affect your environment.

What Changed?

Starting in 12.1, data pump sets tablespaces read write during the import phase of a transportable tablespace …

Full Transportable Export/Import – PAR File Examples

Posted on November 3, 2016 by Mike.Dietrich Data Pump Transportable 14

Roy and I blogged about Full Transportable Export/Import in the past:

If you haven’t heard of this database feature, it allows you to migrate a full database by using Transportable Tablespaces as a base technology but letting Data Pump do all the manual steps for you in a one-command migration. And if needed, it works with RMAN Incremental Backups as well in order to …

Full Transportable Export/Import – Things to Know

Posted on July 4, 2016 by Mike.Dietrich TDE - Transparent Database Encryption Time Zone - DST Transportable 8

This blog post is an addition to:

Full Transportable Export/Import – Migrating an 11.2.0.4 database to Oracle Database 12c- into the Oracle Cloud

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 …

Full Transportable Export/Import – Migrating an 11.2.0.4 database to Oracle Database 12c- into the Oracle Cloud

Posted on June 27, 2016 by Mike.Dietrich Cloud Data Pump Transportable Video / Viewlet 38

Full Transportable Export/Import – one of the coolest features in Oracle Database 12c

We blogged about Full Transportable Export/Import a while back. It is – no doubt – one of the coolest features in Oracle Database 12c. And it is part of our Hands-On Lab exercise (Hands On Lab – Upgrade, Migrate, Consolidate to Oracle Database 12c) as well.

It utilizes the technique of Transportable Tablesspaces – cross-platform, cross- Endianness, cross-version – but lets Oracle Data Pump do all the “dirty” work of rebuilding everything kept in your SYSTEM and SYSAUX tablespace including views, synonyms, public objects, …

Transportable Tablespaces – Characters Sets – Same same but different?

Posted on May 25, 2016 by Mike.Dietrich Transportable 3

All credits go to Don Wolf, an Oracle Advanced Customer Support engineer from Ohio as he dug out this information 🙂 Thanks Don!

Do database character sets have to match EXACTLY for Transportable Tablespaces?

That sounds like a simple question. When you look into our big slide deck the answer will be a straight “Yes”. No doubts. Regardless if you would like to do Transportable Tablespaces or Full Transportable Export/Import your sources and your target’s database character sets must be equal. Otherwise Data Pump won’t allow you to process the meta data import.

But Don was wondering about slightly differing …

Data Pump – Exclude Stats differently for TTS and FTEX

Posted on April 20, 2016 by Mike.Dietrich Data Pump Transportable 15

Nice little best practice for statistics and Data Pump when doing either Transportable Tablespaces or Full Transportable Export-Import (credits to Roy and Dean Gagne).

Transport Statistics via a Staging Table

First of all we always recommend to exclude statistics when doing a Data Pump export as the import of such stats takes way longer than transporting them via a stats table. If you are unfamiliar with transporting stats between databases please see the Oracle Performance Tuning Guide with a nice tutorial:

Importing and Exporting Optimizer Statistics

The basic steps to transport statistics from one database to another fast and

Full Transportable Export/Import

We are hiring: Software Development Senior Director “Database Utilities”

Fallback Strategies with Full Transportable Export/Import

Transportable Tablespaces – Does it work between SE2 and EE?

Transportable Tablespaces and Full Transportable Export/Import

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

Can you EXCLUDE tablespaces from Full Transportable Export/Import?

Question: Can you EXCLUDE one or more tablespaces when doing a Full Transportable Export/Import?

Hands-On Lab available: Upgrade to Oracle Database 12.2.0.1

Transportable Tablespaces and READ ONLY in Oracle Database 12c

Full Transportable Export/Import – PAR File Examples

Full Transportable Export/Import – Things to Know

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

Transportable Tablespaces – Characters Sets – Same same but different?

Do database character sets have to match EXACTLY for Transportable Tablespaces?

Data Pump – Exclude Stats differently for TTS and FTEX

Transport Statistics via a Staging Table

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts

Follow me on Twitter