Category Archives: Flashback Database

Oracle 19c New Features

Hello, friends!

Oracle 19c is now available for Oracle Cloud and Exadata.  It’s not yet available for “on-premises”, but it will no doubt be available shortly.  Well, hopefully.

19c is the terminal release of 12.2, which means that prior to Oracle’s versioning changes, it would have been referred to as 12.2.0.3.  As of the time of writing, it will be supported for the next 4 years under Premium Support and 3 years under Extended Support.

This is probably going to be the version that those waiting to pull the plug on upgrading to 12c are going to move to as 18c is still quite buggy (especially for versions < 18.1.5)

Bear in mind that there is no support for 19c on Linux 6.  The minimum versions of the O/S and kernels are as follows:

  • Oracle Linux 7.4 with the Unbreakable Enterprise Kernel 4: 4.1.12-112.16.7.el7uek.x86_64 or later
  • Oracle Linux 7.4 with the Unbreakable Enterprise Kernel 5: 4.14.35-1818.1.6.el7uek.x86_64 or later
  • Oracle Linux 7.4 with the Red Hat Compatible kernel: 3.10.0-693.5.2.0.1.el7.x86_64 or later
  • Red Hat Enterprise Linux 7.4: 3.10.0-693.5.2.0.1.el7.x86_64 or later
  • SuSE Linux Enterprise Server 12 SP3: 4.4.103-92.56-default or later

It’s been 17 years since I worked with an Oracle database running on SuSE, but there must be some hiding out there somewhere!

One thing to bear in mind, though, is that the upgrade to 19c on Exadata can be quite painful.  If you moved to 18c and found it to be nice and (relatively) easy, don’t be surprised if 19c is trickier.

As we try and contain our excitement, here are some of the features I think are going to be the most useful.

Continue reading

Advertisements
Tagged

Calling FLASHBACK DATABASE from RMAN

Recently, I discovered a cool tweak that I really should have known about before now, given the number of times I’ve performed FLASHBACK DATABASE in the past.

You are probably aware that in order to FLASHBACK DATABASE, not only do you need the Flashback logs, but the corresponding archive logs must also be accessible.

Continue reading

Tagged , ,
Advertisements
%d bloggers like this: