Flashback Data Archive Enhancements in Oracle Database 12c

Having played around with Flashback Data Archive in 11g, I figured I would get through the 12c enhancements pretty quickly. I didn’t account for the fact I’m a donkey and can’t see the wood for the trees. Luckily, I know some people who aren’t stupid and they gave me a nudge in the right direction, allowing me to spot my silly mistake. Thanks Bjoern and Connor:)

So after lots of wasted time, here is the article.

For the most part, it’s an evolution, but the new bits are pretty darn cool. I guess a lot of people will focus on two main things:

  • It is now a free feature, provided you don’t use compression, available in all versions. The change to use no compression by default has been back-ported to 11.2.0.4, so it’s free there too, which is nice!
  • The contents of contexts can now be stored in the flashback archive, so you can have access to the USERENV and custom context values that were set in the session when the DML was processed. This makes it possible to replace all those crappy old audit triggers with FDA!

There’s some other stuff in there that’s kind-of nice too. I think it’s worth checking it out, especially at its new price. :)

Cheers

Tim…

 

RMAN Enhancements in 11g…

My trip through the 11g new features continues with RMAN Ehancements. These combined with the Data Recovery Advisor and Flashback and LogMiner Enhancements I wrote about previously show that Oracle are really putting a lot of effort into getting this area right. I guess the Data Recovery Advisor will be the most outstanding new feature for most people, but there are loads of tweaks all round that all help to make life easier for us guys on the coal face.

Cheers

Tim…

Flashback, LogMiner and The Light Fantastic…

I put an article about Flashback and LogMiner new stuff live the other day, but forgot to put a post here. Better late than never. I feel a bit cheap and dirty admitting this, but I’m starting to like the web based Enterprise Manager. :)

The new LogMiner interface is really easy to use, and the integration with Flashback Transaction is right on the money. I guess LogMiner isn’t the sexiest of features, and I’ve had very little cause to use it since I first tried it out in 8i, but at least now it’s a no-brainer in terms of ease of use.

On a separate note, I finished The Light Fantastic last night. It seemed marginally more serious than the first book, but was still very funny. The introduction of character Cohen was very cool. Had me in stitches. I adopted a Sean Connery accent (in my head) for most of his dialog. Off to the book shop on the way home to buy the next couple…

Cheers

Tim…