PERL scripts for large migrations supported on all platforms (except Windows)

This topic fits very well as I present about +100 TB migrations today at the “Harmony” User Group Conference in Finland.

Finland May Helsinki 2017

Finland in May

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 with other Unix based operating systems. However, any non-Linux operating system must be on 11.2.0.4.

Please be aware that “Unix” is important here:
The scripts are not supported (and won’t work) if you use them with MS Windows platforms.

Another caveat with the note to be aware of:

It does not talk explicitly about “Full Database Migrations”. And not about Full Transportable Export/Import. I’ve had several customers hitting this trap using the procedure described in the note but ending up with just parts of their database being migrated. Please keep in mind that you will have to move everything in SYSTEM tablespace (and potentially in SYSAUX such as AWR) as well as otherwise you’ll end up with data but will miss your grants, roles, synonyms etc. That’s why we highly recommend the Full Transportable Export/Import procedure as it takes care on all this.

You may please download my slide deck about how to use the PERL scripts for a large migration – it’s the talk I gave at Harmony Conference 2017:

–Mike

Oracle Database 12.2 for Exadata/SuperCluster available

Oracle Database 12.2.0.1 on-premises for Exadata and SuperCluster is now available for download from Oracle eDelivery/SoftwareCloud.

Connect to eDelivery and login.

Search for: “Oracle Database” and mark “Oracle Database Enterprise Edition …


.

Click on “Select Platforms” and select “Linux x86-64“, then hit “Continue“:

Once you accepted the license agreement you’ll be able to download the software:

Please be aware that the software can be installed on Oracle Exadata and Oracle SuperCluster ONLY. To take advantage of the full potential of Oracle Database
12c Release 2
you should upgrade to the latest Exadata Software Release 12.2.1.1.0 before upgrading databases to 12c Release 2. Exadata
Software 12.2.1.1.0 supports Smart Scan functionality for Oracle Database 12c
Release 2 and is available via OSDC.

For the release of Oracle Database 12.2.0.1 on-premises for other platforms please see MOS Note:742060.1.

–Mike

Oracle Exadata at Thomson Reuters

Very cool presentation released about the introduction of Oracle Exadata systems at Thomson Reuters, a customer we did visit in the past onsite in Minneapolis, MN 🙂

Oracle Engineered Systems at Thomson Reuters

Engineered Systems, the Foundation of Efficiency

-Mike

Patches, Patch Sets, Patch Bundles, Bundled Patches …

Ouch … just realized that it has been a while since I posted a new topic on the blog. But actually the past weeks I was busy doing workshops, working with customers – and finally (yes!!) participating on an Exadata training class. Sitting there for 3 days, listening the instructor, playing around with the cell simulator and all the exercises was quite a nice change from the daily business. And I believe I’ve learnt something useful 🙂

Well, daily business, this brings me back to a topic which hit my inbox today again for the 2nd time in a few weeks. Somebody has opened an SR with Oracle Support and refered to my blog entry from January recommending Exadata Bundled Patch 3 for a typical RAC/GI 11.2.0.2 installation. Simple reason why I recommended this: Exadata Bundle Patches get released each month, they contain critical fixes for RAC, GI and ASM – and optimizer fixes.

After a discussion with Support later on I’ve added a note below this article saying that Oracle Support will still recommend a combination of the latest PSU together with the latest PSU GI. But both don’t contain optimizer fixes. And I’ve learned a few weeks ago that there are now also Grid Infrastructure Bundle Patches being released.

So my personal recommendation if you are not sure which patch to apply:
Open an SR and ask Oracle Support. And once you login to support.oracle.com please try out the Upgrade Planner on the PATCHES/UPDATES page.