Flashback

Migrating Flashback Data Archive (FDA) tables

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

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 …

Virtual Classroom Seminar: Fallback Is Your Insurance – on Nov 11, 2021

Posted on November 10, 2021 by Mike.Dietrich Workshop 4

No worries, I haven’t become lazy recently. But the past weeks were more busy than anything I have experienced so far. And I had a full week off and enjoyed the silence and absence from blogs and cell phones and email in the mountains. But now I’m back – and surprise, surprise – this week on Thursday we’ll have our 11th Virtual Classroom Seminar: Fallback Is Your Insurance – on Nov 11, 2021.

Fallback Seminar

When will it happen?

Thursday, Nov 11, 2021 – 10:00h CET

What are we going to talk about?

Fallback and Rollback. How to secure your job. …

Database Migration from non-CDB to PDB – The Fallback Challenge

There are several pitfalls when you plugin a non-CDB into a CDB environment. I’d like to highlight some of them – and show you potential workarounds as well. This is part of a series of blog posts to make your migration from non-CDB to PDB a bit smoother.

Photo by Sebastian Grochowicz on Unsplash

Database Migration from non-CDB to PDB – The Fallback Challenge

As I work with customers on upgrades and migrations for a very long time, I know how important a proper fallback is.

When you attempt a migration from a non-CDB to PDB, you need to plan …

Guaranteed Restore Points and COMPATIBLE parameter

Posted on April 12, 2018 by Mike.Dietrich Fallback 12

A while ago I blogged about Fallback Strategy: Flashback Database to Guaranteed Restore Points. I included a recommendation that you must not change the COMPATIBLE setting. But I should have been a bit more clear and precise about Guaranteed Restore Points and COMPATIBLE parameter settings.

Guaranteed Restore Points and COMPATIBLE parameter

First of all, you can’t use FLASHBACK DATABASE to a Guaranteed Restore Point when you changed to COMPATIBLE parameter. This was a common pitfall in older Oracle releases.

But with Oracle Database 12.2.0.1 we add a tiny change which prevents you from accidentally changing COMPATIBLE while your fallback …

Oracle 12.2 underscores appear in SPFILE – be aware when you flashback

Posted on September 19, 2017 by Mike.Dietrich Fallback Flaws and Pitfalls 10

I did blog in the past weeks about Fallback Strategies with Flashback Database. But two of my reference customers came across an interesting issue when they tried to fallback: Oracle 12.2 underscores appear in the SPFILE – magically – and prevent the fallback using the existing SPFILE.

Oracle 12.2 underscores appear in SPFILE – be aware when you flashback

In one case it happened during a test, in the other case it happened during a live fallback after the Data Guard Broker has interfered with the upgrade causing real trouble. In both cases the SPFILE sits in ASM.

Both …

Fallback Strategy: Flashback Pluggable Database

Posted on August 30, 2017 by Mike.Dietrich Fallback Single-/Multitenant 6

Since Oracle Database 12.2 an important feature works now for pluggable databases as a Fallback Strategy: Flashback Pluggable Database in Oracle 12.2. This was missing in Oracle Database 12.1.

Actually I missed this feature a lot as I use “Flashback” almost everyday. And you could only rewind the entire deployment with a FLASHBACK DATABASE command.

Fallback Strategy: Flashback Pluggable Database

Fallback Strategy: Flashback Pluggable Database in Oracle 12.2 Actually having the possibility to flashback a pluggable database without effecting the other PDBs is really important. Did you ever want to try out what happens if you TRUNCATE TABLE SYS.PROPS$? Give it a try – but set a …

Switch on/off + Remove – Journey to the Oracle Cloud – II

Posted on December 4, 2015 by Mike.Dietrich Cloud Removal 6

What happened so far on my Journey to the Cloud?

Day 2 of my Cloud exploration journey.

In my blog posts about my DBaaS Cloud journey I won’t explain …

Flashback

Migrating Flashback Data Archive (FDA) tables

What is Flashback Data Archive (FDA)?

Virtual Classroom Seminar: Fallback Is Your Insurance – on Nov 11, 2021

When will it happen?

What are we going to talk about?

Database Migration from non-CDB to PDB – The Fallback Challenge

Database Migration from non-CDB to PDB – The Fallback Challenge

Guaranteed Restore Points and COMPATIBLE parameter

Guaranteed Restore Points and COMPATIBLE parameter

Oracle 12.2 underscores appear in SPFILE – be aware when you flashback

Oracle 12.2 underscores appear in SPFILE – be aware when you flashback

Fallback Strategy: Flashback Pluggable Database

Fallback Strategy: Flashback Pluggable Database

Switch on/off + Remove – Journey to the Oracle Cloud – II

What happened so far on my Journey to the Cloud?

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Follow me on Twitter

Recent Posts