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.… Continue reading...
October 13, 2020 – 11:00h CEST | 13:00 GST | 12:00 EEST | 10:00 BST
MIGRATION STRATEGIES – Tips and Tricks and Insights and SecretsIn the fourth summer webinar about Multitenant, we touched on some migration strategies. And now it’s time for us to dig deeper. We’d like to offer you further insights and a deep dive from a technical point of view, starting with Data Pump and Transportable Tablespaces, then Full Transportable Export Import, and adding RMAN Incremental Backups to decrease the downtime. Best practices and real-world experience will round up this two-hour webinar.
October will be a very busy month. Daniel and I are putting the slides together at the moment for the upcoming Upgrade to Oracle 19c – Virtual Classroom Series – Parts 5 and 6. We will speak about “Database Migration Techniques” and about “Move to the Cloud – For Techies Only“. No worries if you missed Parts 1-4 as you can watch all of them online on-demand. Find all links below.
Register for the Virtual Classroom Part 5 and Part 6 events
Find the overview for both events here …Continue reading...
A long time ago my colleagues published PERL scripts to assist especially with cross platform Transportable Tablespace migrations. The PERL scripts allow you to utilize incremental backups. This way you can decrease the downtime in a migration with large databases significantly. But there are different MOS Notes for xTTS PERL scripts available. Which one should you take?
Transportable Tablespaces and Incremental Backups
The biggest pain points in a transportable tablespace migration are usually the size of the database and its complexity. With RMAN Incrementally Rolled Forward Backups you can tackle the size aspect. Instead of having a long downtime …Continue reading...
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 …Continue reading...
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
I was shocked. Positively. We’ve had a packed room on Wednesday at Oracle Open World 2017 for our talk together with Jay Barnhart of Centric Consulting on How to Migrate 100 TB databases in less than one day. And we’ve had so much fun. Thanks for coming by, thanks for being so active. This makes all the travel and the stress really worth it.
OOW 2017 – Slides Download: Migrate 100 TB databases in less than one day
I gave a quick overview about all Transportable Tablespaces techniques, about how to use the PERL scripts to deal with very …Continue reading...
This topic fits very well as I present about +100 TB migrations today at the “Harmony” User Group Conference in Finland.
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...
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 …Continue reading...
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.
Starting in 12.1, data pump sets tablespaces read write during the import phase of a transportable tablespace …Continue reading...
Roy and I blogged about Full Transportable Export/Import in the past:
- Full Transportable Export/Import White Paper
- Full Transportable Export/Import – Things to Know
- Full Transportable Export/Import – Migrating an 188.8.131.52 database to Oracle Database 12c- into the Oracle Cloud
- Exclude Stats differently for TTS and FTEX
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 …Continue reading...
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...
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, …Continue reading...
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 …Continue reading...
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:
The basic steps to transport statistics from one database to another fast and
One of the really cool and helpful features in Oracle Database 12c is called Full Transportable Export/Import. It combines the basics of transportable tablespaces – of course cross-platform, cross-endianess, cross-version – with Data Pump taking care on all the stuff not stored in tables and indexes, such as views, synonyms, trigger, packages etc. And you can even reduce downtime by combining the feature with incrementally converted RMAN backups.
And the best thing: this will work with an Oracle Database 184.108.40.206/4 to Oracle Database 12c – so you don’t have to be on Oracle Database 12c in order to …Continue reading...