Migration

Migrating Flashback Data Archive (FDA) tables

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.

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 …

Continue reading...

We are hiring … Developers and a Product Manager

Our team is growing – not only the Upgrade team but also the Data Pump team. And we have a challenging new project where we search developers for. So yes, We are hiring … Developers and a Product Manager.

Software Developer – Cloud Migration Analyzer

At first, we are looking mostly for skilled developers. We have a new challenging and interesting project which our VP, Roy Swonger, owns. And there we look at first for developers with either very good APEX skills but also database knowledge or people who are good in programming …

Continue reading...

Virtual Classroom Seminars 10-12: Videos and Slides are available

Thanks to all of you for participating in our last 3 web seminar session. And since some of you had to leave earlier in one of the Virtual Classroom Seminars 10-12: Videos and Slides are available for download and on-demand viewing.

Virtual Classrom Seminar - Migrating Large Databases

No registration is required – you can watch all of our seminars anytime.

And as usual, our workshops are free of buzz words and explain only technical topics. The presenters Roy Swonger, Daniel Overby Hansen, Rodrigo Jorge, Bill Beauregard and myself, we all love to talk about technical topics, show and share demos and put …

Continue reading...

Migrating Very Large Databases – Virtual Classroom Seminar 12

Register here:

https://go.oracle.com/LP=114938?elqCampaignId=302203

 

Webinar Details

Date: December 9, 2021

Start Time: 09:00 GMT / 10:00 CET / 11:00 EET / 13:00 GST

Duration: 120 mins

Webinar Description

There is no clear definition what “large” means. But we think about database of many Terabytes and more. Large databases require different considerations. Often there is not much spare space available. Our focus is to show and demonstrate how to migrate really large databases as quickly as possible following our dogma of “the more simple the better”. But if downtime restrictions come into play, we may need to chose more complex solutions.

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...

UKOUG21: Huh, it is fixed in Oracle 23c? Insights …

https://ukoug.org/page/mikedietrichtogether21

In this talk we will give rare insights into how Oracle Database Development works.

Have you ever asked yourself how “Development” at Oracle , 19cgeworks? And why regression test take hours and not only minutes?

Or why Support tells you, “it will be fixed in 23c” even though there is no 23c available yet?

It’s pure magic – and we will give some insights!

“Have you every heard from Oracle Support “”It will be fixed in 21c or 23c””? And wondered if you should upgrade now, and how you should upgrade when the release is not there yet?

In …

Continue reading...

Upgrading a non-CDB to Oracle Database 21c with AutoUpgrade

Yesterday I wrote about the installation of Oracle Database 21c on Linux. But today it is time for Upgrading to Oracle Database 21c with AutoUpgrade.

Upgrading a non-CDB to Oracle Database 21c with AutoUpgrade

Photo by Arjun MJ on Unsplash

AutoUpgrade

You may have heard it already from us and other colleagues, but we can’t repeat it often enough: There is only one recommended tool to upgrade your databases – and this is AutoUpgrade.

In my 21c home, I’m checking the deployed version of AutoUpgrade at first:

[CDB3] oracle@hol:/u01/app/oracle/product/21/rdbms/admin
$ java -jar autoupgrade.jar -version
build.hash 57ab246
build.version 21.1.3
build.date 2021/04/21 13:32:13
build.max_target_version 21
build.supported_target_versions 12.2,18,19,21
build.type production

Now please …

Continue reading...

Virtual Classroom: Performance Testing Using the Oracle Cloud for Upgrades and Migrations

Register here!

for May 19, 2021 – 10:00h CET

WE HAD TO MOVE IT FROM March 17 to May 19.

Virtual Classroom Web Seminar No.9:

Performance Testing Using the Oracle Cloud for Upgrades and Migrations

Everybody talks “cloud”, but what about the practicalities? We’ve already delivered a full 2-hour talk about how to migrate to the Oracle Cloud (“Move to the Cloud—Not Only for Techies”), and this time we’ll go beyond pure migration. How do you test? What are the best practices? And which special features can you expect in the various cloud deployments? We assume you have on-prem …

Continue reading...

Sign Up Now: Database Release Strategy and Patching Best Practices on Feb 4 – 10am PST

Tomorrow we’ll start our new Virtual Classroom Web Seminar Series, this time for the Americas in a convenient 10am – noon Pacific Time zone. So this is your final change to Sign Up Now: Database Release Strategy and Patching Best Practices on Feb 4 – 10am PST.

Sign Up Now: Database Release Strategy and Patching Best Practices on Feb 4 - 10am PST

Photo by Etty Fidele on Unsplash

Why you want to participate?

Roy, Daniel and I will kick of this series with the Episode 1: Database Release Strategy and Patching Best Practices for a reason. We get a ton of question regarding both topics every day. Everybody wants to know about …

Continue reading...

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

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.

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 …

Continue reading...

UKOUG 20 – Move to OCI – For Experts and Beginners

Registration:

https://ukoug.org/page/ukougconf2mikedietrich

Date/Time:

Dec 2, 2020 – 15:00h GMT – 16:00h CET

Abstract:

Do you plan to move your data or your database(s) to OCI (Oracle Cloud Infrastructure)?

We will show you all the different options and varieties. Then you can easily choose what works best for you. Whether you’d like to do it all manual, or if you prefer fully automated solution – in this talk we will demonstrate them.

Whether you migrate to DBCS, ExaCS, Bare Metal or VM, we have the right solution for you.

Fully marketing-free – our goal is to give you a technical overview …

Continue reading...

UKOUG 20 – Move to ADB – For Experts and Beginners

Registration:

https://ukoug.org/page/ukougconf20mikedietrich

Date/Time:

Dec 1, 2020 – 15:00h GMT – 16:00h CET

Abstract:

I will cover all the potential paths into ADB. It’s no rocket science. But with the ALWAYS FREE TIER available, this maybe even useful for your apart from your current job. Whatever data you have, Excel, CSV, or entire databases. We will showcase how to efficiently and quickly upload your data.

SQL Developer Web, SQL Developer, Data Pump, SQL Loader, MV2ADB and more – and we’ll showcase everything. So you can choose the best solution for your own purpose.

No marketing involved – we won’t sell you …

Continue reading...

Upgrade Essentials – Videos for the Virtual Classroom Series 2020

Roy, Daniel and I ran 6 workshops in our Virtual Classroom Series 2000 format. Each of them is between 90 and 120 minutes. This sounds quite long but of course you can scroll forward if you are interested in only a part of it. We consider those the Upgrade Essentials – Videos for the Virtual Classroom Series 2020. As as we now completed the 6th web seminar, it’s time for a short recap.

Is Upgrade that complicated?

Good question. If upgrade is so easy as we say, why do you need 6 virtual sessions …

Continue reading...

APAC OUG: 3 PDBs and much more

Continue reading...

Check your Unified Auditing Policies after upgrading to Oracle 19c

This may become a longer blog post. One of the customers I work with for many years contacted me a few weeks ago. After upgrade to 19c, it looked like as if some Unified Auditing Policies weren’t correct anymore. It started as a tiny issue, but thanks to the customer who analyzed down to the bones, it seems to be bigger than we thought at the beginning. So you may Check your Unified Auditing Policies after upgrading to Oracle 19c as well.

Check your Unified Auditing Policies after upgrading to Oracle 19c

Photo by Felix Luo on Unsplash

Unified Auditing

Actually a lot of my customers use Unified Auditing these …

Continue reading...

Virtual Classroom: Migrate to the Cloud – For Techies Only

  • October 15, 2020 – 11:00h CEST | 13:00 GST | 12:00 EEST | 10:00 BST
    MOVE TO THE CLOUD – For Techies
    .
    Whether you have databases in a cloud environment, or you plan to lift databases soon, this webinar is for you. We won’t cover cloud solution benefits but will show you how you can migrate your database(s) into the Oracle Cloud. We’ll start with Autonomous and also cover migration into VMs, Bare Metal, OCI, ExaCS and ExaCC. And we’ll look at minimizing downtime strategy, where ZDM can help. This two-hour webinar is not strictly for technical geeks‒but
Continue reading...

Virtual Classroom: Migration Strategies – Tipps & Tricks & Secrets

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.

 

REGISTRATION

Continue reading...

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

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...

SOUG – Migration to Multitenant

Register here: https://soug.ch/soug-day-september-21st-2020/

 

Migration to Multitenant with Oracle 19c – Mike Dietrich, Oracle Corporation

Abstract
How do you migrate to Oracle Multitenant?
Sounds simple – but the devil is in the detail.
Database components, time zone, patches – a lot of potential pitfalls. And not to forget the outage.
In 45 mins I will make you fit for a successful migration to the CDB-architecture.

Language
English

Room
Live-stream via Zoom…

Continue reading...

Cloud Migrations: The New Kid on the Blog – DOHDATABASE.com

You may have realized that you will find mostly on-prem database upgrade and migration topics covered on my blog. Which doesn’t mean that you can’t use most of these techniques to migrate to the cloud either. But it’s really hard to write about everything in full detail. Hence, today I’d like to introduce you to Cloud Migrations: The New Kid on the Blog – DOHDATABASE.com. And no, I was never a fan of this American boyband from the 80s and 90s 😉

Cloud Migrations: The New Kid on the Blog - DOHDATABASE.com

Find Daniel’s blog at: https://dohdatabase.com

DOHDATABASE … huh?

Cloud Migrations: The New Kid on the Blog - DOHDATABASE.com

Daniel Overby Hansen

As you may have read a …

Continue reading...

Upgrade Seminars 2020 – Recap and Videos on-demand

Thank you for participating in our 4 Database Upgrade to Oracle 19c seminars in the past two weeks. There were over 800 questions during the seminars – and it was a good idea that we prerecorded them. This way, I could answer your questions as it was a more convenient time for me than for Roy. We enjoyed it a lot – and from the feedback I read, most of you enjoyed it, too. Now please read about Upgrade Seminars 2020 – Recap and Videos on-demand below.

The Slides

I uploaded all 4 decks …

Continue reading...

Collection of EBS upgrade information for Oracle Database 19c

This was the question I received the most often during the Virtual Classroom web seminars last week: “Can you say something about EBS upgrades with 19c?”. And I promised to publish a blog post about it. But as I’m not an EBS expert, I can only share a Collection of EBS upgrade information for Oracle Database 19c. For all further inquiries, please open an SR or get in touch with your Oracle contact.

Recap – EBS and Oracle 19c

In September 2019, right before Oracle Open World, we announced the certification of EBS …

Continue reading...

Upgrade to Oracle Database 19c – Virtual Classroom Series

Roy and I delivered a similar seminar already for the Australia and New Zealand region. And now it is time at a more convenient time zone setting for EMEA and India. So if you are not tired of web seminars yet, please sign up for our Upgrade to Oracle Database 19c – Virtual Classroom Series.

Upgrade to Oracle Database 19c - Virtual Classroom Series

Photo by Bima Rahmanda on Unsplash

4 Web Seminars – Going far beyond upgrades

The idea for this series of 4 web seminars is to cover not only the database upgrade itself. You will get much more than technical upgrade information. And we will …

Continue reading...