TTS

Migrating Flashback Data Archive (FDA) tables

Posted on April 8, 2022 by Mike.Dietrich Export - Import 11

This morning I received an email question from a customer asking whether there is support for the Migrating Flashback Data Archive (FDA) tables in Oracle 19c. And since this is not the first time I received this question, I thought it may be good to have a blog post about it.

Photo by Anita Jankovic on Unsplash

What is Flashback Data Archive (FDA)?

Well, google it. Actually I was looking for a link in our documentation but to my surprise I found the usual suspects such as Tim Hall’s excellent oracle-base page – but not much in our own doc …

Sign up for the Upgrade 19c Virtual Classroom Seminars for the US, Canada and LAD

Posted on January 21, 2021 by Mike.Dietrich Workshop 7

It took a while. And many of you asked whether we will run our Virtual Classroom Seminars we ran successfully for Australia and New Zealand in April and from June to now in EMEA for the US, Canada and South and Latin America time zones as well. And we do. It’s time to Sign up for the Upgrade 19c Virtual Classroom Seminars for the US, Canada and LAD.

Photo by Philippe Bout on Unsplash

Everything you need to know about Upgrade, Migration and Consolidation

When we ran these events especially for EMEA, a lot of colleagues asked us whether …

Transportable Tablespaces: Keep tablespace files read-only

Posted on October 5, 2020 by Mike.Dietrich Transportable 8

When you Transport Tablespaces, you may be aware of a change in behavior a long while ago. When your tablespace import has been finished, a tablespace will be taken read-write automatically. But there may be situations when you’d like the previous behavior. Now you can have this with Transportable Tablespaces: Keep tablespace files read-only.

Transportable Tablespaces: Keep tablespace files read-only

Photo by freestocks on Unsplash

Default Behavior

Since Oracle Database 12c a tablespace will be taken read-write once the meta data import has been completed automatically. This was different in previous database releases. We used the technique a long time ago for a telco provider …

Test Transportable Tablespaces without Read-Only Mode

Posted on October 2, 2020 by Mike.Dietrich Transportable 2

From time to time I deal with Transportable Tablespaces as an upgrade and migration approach. But TTS has one major flaw, especially when databases get really really big in the 3-digit-terabyte sizes or more: You will need to switch your tablespaces into read-only mode. But since Oracle Database 19c, you can Test Transportable Tablespaces without Read-Only Mode.

Test Transportable Tablespaces without Read-Only Mode

Photo by freestocks on Unsplash

Transport Constraints

Transportable Tablespaces (TTS) is a very common technique, especially when you need to migrate databases across Endianness. Since Oracle 10g, TTS works even from Big Endianness to Little Endianness platforms, and vice versa. Only if …

Upgrade to Oracle 19c – Virtual Classroom Series – Parts 5 and 6

Posted on October 1, 2020 by Mike.Dietrich Workshop 2

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.

Upgrade to Oracle 19c – Virtual Classroom Series - Parts 5 and 6

Photo by Austin Distel on Unsplash

Register for the Virtual Classroom Part 5 and Part 6 events

Find the overview for both events here …

Transportable Tablespaces – Example and strange error with a PDB

Posted on July 7, 2020 by Mike.Dietrich Data Pump Single-/Multitenant Transportable 6

Yesterday I was browsing around for a useful simple example to test Transportable Tablespaces. A colleague mailed with the other day with a strange error message. The attempt to import into a PDB in Oracle 19c failed. My first thought: Oh, this is simple. But I failed, too. And even worse, I couldn’t find a single useful note in MyOracle Support (MOS) for ORA-31640, ORA-27037, Linux-x86_64 Error: 2 with Additional information: 7. So I decided to summarize this in Transportable Tablespaces – Example and strange error with a PDB.

Transportable Tablespaces - Example and strange error with a PDB

Photo by Kerensa Pickett on Unsplash

A simple Transportable Tablespace

Different MOS Notes for xTTS PERL scripts – Use V4 scripts

Posted on January 28, 2019 by Mike.Dietrich Transportable 67

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?

Photo by VanveenJF on Unsplash

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 …

ORACLE_MAINTAINED attribute can be pretty helpful

Posted on March 21, 2018 by Mike.Dietrich General 11

You may have seen my two blog posts about Oracle supplied objects and Oracle supplied user schema and roles a few days ago, One person commented asking about what to do with these. And I agree: It looks a bit harsh to deal with two external files to query Oracle supplied stuff. But actually (as Patrick Hurley commented as well) there is a much easier way since Oracle Database 12c to deal with objects created and supplied by Oracle: the ORACLE_MAINTAINED attribute can be pretty helpful.

ORACLE_MAINTAINED attribute can be pretty helpful

In Oracle Database 12.1.0.1 we added a column …

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

OOW 2017 – Slides Download: Migrate 100 TB databases in less than one day

Posted on October 5, 2017 by Mike.Dietrich OOW Transportable 0

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 …

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 …

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 …

Note:1389592.1 Public – Speed Up Cross Platform Transportable Tablespaces (xTTS) with RMAN Incremental Backups

Posted on February 10, 2012 by Mike.Dietrich Transportable 4

As we have already mentioned in our recent workshops the MOS Note:1389592.1 is public now:

MOS Note:1389592.1
Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backups

This technique currently works for migrations to Linux64 and is supported by Oracle Support for Exadata migrations only. It utiliuzes RMAN incremental backups to reduce the large amount of downtime it takes to copy and convert the datafiles cross Endianness.

Two requirements must be met to use this new functionality:

Oracle 11.2.0.2 plus Exadata BP12 (patch 12982245)
One-off patch 13340675 contains the RMAN extension and is currently available on top of BP12 on

TTS

Migrating Flashback Data Archive (FDA) tables

What is Flashback Data Archive (FDA)?

Transportable Tablespaces: Keep tablespace files read-only

Default Behavior

Test Transportable Tablespaces without Read-Only Mode

Transport Constraints

Upgrade to Oracle 19c – Virtual Classroom Series – Parts 5 and 6

Register for the Virtual Classroom Part 5 and Part 6 events

Transportable Tablespaces – Example and strange error with a PDB

A simple Transportable Tablespace

Different MOS Notes for xTTS PERL scripts – Use V4 scripts

Transportable Tablespaces and Incremental Backups

ORACLE_MAINTAINED attribute can be pretty helpful

ORACLE_MAINTAINED attribute can be pretty helpful

Fallback Strategies with Full Transportable Export/Import

Transportable Tablespaces – Does it work between SE2 and EE?

Transportable Tablespaces and Full Transportable Export/Import

OOW 2017 – Slides Download: Migrate 100 TB databases in less than one day

OOW 2017 – Slides Download: Migrate 100 TB databases in less than one day

Transportable Tablespaces and READ ONLY in Oracle Database 12c

Transportable Tablespaces – Characters Sets – Same same but different?

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

Note:1389592.1 Public – Speed Up Cross Platform Transportable Tablespaces (xTTS) with RMAN Incremental Backups

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts

Follow me on Twitter