DataPump Export from Data Guard
To save resources on your primary database when doing Data Pump exports and to avoid ORA-01555, you can use a snapshot standby database.
Future-proof Your Encrypted Database During Upgrade
When you upgrade an encrypted database to Oracle Database 19c you configure AutoUpgrade to change the keystore definition from sqlnet.ora to the new recommended parameter – WALLET_ROOT.
Performance Stability after Upgrade and Migration
Slides from talk to Danish Oracle User Group.
Upgrade Internals – Webinar
Here is a sneak peek into our upcoming webinar.
Control Upgrade Parallelism In AutoUpgrade
AutoUpgrade allows you to fine-tune the parallel options of a database upgrade.
Follow-up On Cool Features Webinar – Jan 2021
Follow-up on our Cool Features webinar with answers to the questions that we couldn’t answer live. Thanks for attending.
AutoUpgrade One-liner
You can specify all input to AutoUpgrade in a single command – without using a config file. Ideal for scripting and automation.
How to Upgrade a Single PDB
You can use AutoUpgrade to perform unplug-plug upgrade of your PDB. It is faster, but there are some things you must be aware of.
How to Upgrade with AutoUpgrade and Data Guard
It is easier to upgrade a Data Guard setup when using AutoUpgrade.
Upgrading in the Cloud – VM DB Systems – Automated Upgrade to 19c – The Details
Learn all the details about the automated upgrade in OCI. In addition, you can find answers to the most common questions.
New Version of AutoUpgrade
A new of AutoUpgrade is out and it contains several cool features like unplug/plug upgrade and better handling of data guard.
Upgrading in the Cloud – VM DB Systems – Automated Upgrade to 19c
It is now possible to upgrade your database in OCI to Database 19c with just a few clicks.
Is AutoUpgrade resumable?
Yes, it is. You can resume a terminated or lost session. AutoUpgrade will automatically pick up from where it left.
How to Migrate a Database Using Full Transportable Export Import and Incremental Backups
Even huge, TB-sized, databases can be migrated with very little downtime by using incremental backups. Now with step-by-step instructions.
Upgrade & Plug In: With ASM, Data Guard, TDE and no Keystore Password
You can upgrade and convert your database to a PDB without comprising your standby database. And you don’t even need the TDE keystore password.
How to Upgrade with Data Guard
Learn how to upgrade your database and keep the data guard setup intact.
Webinar: Upgrade Your Databases to 19c
Come join my talk on upgrading to Oracle Database 19c.
Minimal Downtime Migration with Full Transportable Export Import and Incremental Backups
Even huge databases can be migrated to the cloud with little downtime – even if you go across endian format. And you can even implicitly upgrade the database and convert to a PDB.
How to Stop Hardcoding Your TDE Keystore Password
If you store the keystore password in the Secure External Password Store, you don’t have to type it in cleartext ever again.
Enabling Local Undo With AutoUpgrade
You get much more functionality when using Local Undo in your CDB. Let AutoUpgrade enable it for you!
Move to the Cloud – Webinar
Get the slides from the webinar “Move to the Cloud – not only for techies”. Also, you can find the missing part on transportable tablespaces, and information about a recording.
Migration Strategies
We did a webinar today on Migration Strategies – Tips and Tricks and Insights and Secrets. Here is a wrap-up and link to the slides.
Debut on the Big Stage
In mid-October you can join our two webinars on database migration. One of them is exclusively about cloud migration – for techies only.
Classic Preupgrade Tool and Change of Server
If you are using the classic Preupgrade tool (preupgrade.jar) be sure to put it in the right place.
TDE from a Non-Security Guy
TDE Tablespace Encryption is a must-have in the cloud and something that most of us have to learn. I recently gave a presentation on the basics and what you will need to learn to survive in the cloud.
How To Gather Fixed Object Statistics After Upgrade With AutoUpgrade
With AutoUpgrade it is easy to gather fixed objects statistics a number of days after the actual database upgrade. Just like it is recommended.
How To Gather Fixed Objects Statistics After Upgrade
Often, re-gathering fixed objects statistics are one of those post-upgrade tasks that is forgotten – or completed in a wrong way. Here’s a quick way to avoid that.
Upgrading in the cloud – VM DB Systems – 11.2.0.4 to 19c (minimal downtime)
If your 11.2.0.4 VM DB System is sensitive to downtime, you can use incremental backups to your advantage when you need to upgrade and convert to PDB.
Upgrading in the cloud – VM DB Systems – 11.2.0.4 to 19c (simple)
Learn how to upgrade an 11.2.0.4 VM DB System to 19c. It also involves conversion from non-CDB architecture to a pluggable database. And it works for Standard Edition as well.
Upgrading in the cloud – VM DB Systems – Transfer Speed
How fast can you transfer data between VM DB Systems? In some situations when upgrading on VM DB Systems you must move data between systems.
Zero Downtime Migration – Migrate to Exadata DB System (ExaCS)
Using Zero Downtime Migration (ZDM) you can migrate from a regular system to Exadata DB System (ExaCS) and you can convert from single instance to RAC at the same time. And it is just as easy as any other ZDM migration.
Upgrade and profile scripts
The scripts glogin.sql and login.sql might kill your upgrade. Learn why and how to avoid.
Zero Downtime Migration – The Pro Tips
It is a little mix and match of all my notes that didn’t make it into the previous blog posts, but are still too good to go.
Zero Downtime Migration – Migrate Your Database
Let the fun begin. It’s time to migrate a database using ZDM – with zero downtime, of course.
Zero Downtime Migration – Install And Configure ZDM
The third post in the series shows you how to install and configure the ZDM service host
Zero Downtime Migration – Preparations
This post shows you how to prepare your source database and how to create a target database in OCI
Zero Downtime Migration
Zero Downtime Migration is a cool and free tool that you can use to migrate into OCI. This blog post introduces the tool and gives you a good overview of the process and all the details.
Why Aren’t You Using SQLcl?
SQLcl is the modern CLI for Oracle Database and it offers a ton of cool features and productivity boosts. Yet, still a lot of users are stuck in the last millennium aka SQL*Plus.
Upgrading in the cloud – VM DB Systems – What about downgrade?
What will you do if things go south? On a VM DB System in OCI you can’t do a database downgrade unless you make special preparations in the new release CDB. In this post I will discuss why it is so, and what you can do to have the option of downgrading.
Upgrading in the cloud – VM DB Systems – 12.2.0.1 PDB to 19c
In this blog post I will show you how to upgrade a 12.2.0.1 PDB to 19c when it is running in a VM DB System. I have a PDB called SALES and it is running Standard Edition 2 (yes, this procedure works for Standard Edition 2 as well). In a previous blog post I went over the restrictions that apply to VM DB System and having those in mind I can create a high-level plan for the upgrade
Upgrading in the cloud – VM DB Systems
This is the first post in a series on the entry-level database system in OCI – being Virtual Machine DB System (VM DB System). You don’t get the same specs as with Exadata DB Systems and Bare Metal DB Systems, but it is much more affordable and still a very good platform. There is good tooling that allows most operations to be fully automated. But there are some limitations that you must be aware of that makes upgrading slightly different.
