Backups can completely age out of the Zero Data Loss Recovery Appliance

With a name like Zero Data Loss Recovery Appliance, one would think every scenario had been thought of which Oracle would prevent against right?  Well not so fast!  Read the article on MOS "(RA10) Bug 22378407 : BACKUPS WILL AGE OUT COMPLETELY IF ONE STOPS CREATING THEM" from note ID 2112880.1 which seems to be half process issue, and half bug since it doesn't prevent this from happening!

Weekend Learning: Backing up and recovering Hyperion Planning applications

Tonight we have our first Weekend Learning of the year, and it is a pretty good one if you have Hyperion Planning in your environment from My Oracle Support article "How to Backup And Recover a Hyperion Planning Application" via document ID 1195635.1 and while I will be glad I had this at hand I really hope I never need to use it.  :}

ALERT: DB corruption after 12c upgrade for compressed tables during recovery

Did you compress tables on 11g before going to 12c?  If so, you need to check out My Oracle Support article "ALERT Bug 21682261 Corruption during Recovery after upgrading to 12c for Compressed Tables" from document ID 2058461.1 because you can run into corrupted tables if you need to recover them!  This is the worst possible news for a database because it violates all of the ACID principles and if you get to the recovery stage you already have your data in question!

Weekend Learning: Recovering with RMAN from before last resetlogs

Did you know that each time you open an Oracle database using the resetlogs parameter it will synchronize with RMAN and as a result it remembers what "version" of your database has been opened so restoring to a point prior to that takes some work.  Take a peek at note ID 1070453.6 on My Oracle Support for the document "RMAN: Point-in-Time Recovery of a Backup From Before Last Resetlogs" that has all of the details!