• Oracle

    ORA-19809, Failed RMAN Backups and Flashback

    Flashback Recovery Area is a common gotcha in many locations as time goes by, so I thought it might be worthwhile to review, since for me, it’s all new.  My last two shops, due to design, had no use for it… Flashback Recovery Area, (FRA) is an intriguing feature and should not be confused as the same as the flashback feature- The ability to flashback to a given time or flashback a table when something has gone wrong has benefits over recovery that is easy for anyone who’s had the to perform either task can appertain.   Per Andy Colvin,…

  • Oracle

    Migrating Jobs in Enterprise Manager 12c- not for the faint of heart… :)

    These are instructions that allowed me to migrate over a large library of EM12c jobs from an existing, split EM console, (Linux) and OMS Repository(Windows) to a single server environment without requiring me to recreate them new. Disclaimer** The migration is a multi-step process that was performed on: A NEW EM12c 12.0.1.0 with the latest bundle patch, OS 64-bit Linux 11.2.0.3.0 repository a FULL backup of the OMS repository before performing. A full documentation of your EM jobs that are up to date! The source environment the EM jobs were datapumped from: 11.2.0.3.0 OMS repository on Windows 2008 EM12c, without…

  • DBA Life - Oracle - SQLServer

    Miracle Oracle World 2012 Recap

    I ended up so wrapped up in everything going on when I returned home that I never did get my Miracle Oracle World 2012 post out on my blog, (bad DBA Goth Princess!:)) so here it is! Miracle Oracle World, (aka MOW2012, hashtag #MOW2012) is a yearly event held by Mogens Noorgard and his company Miracle, (http://www.miracleas.dk/ ) at Hotel Legoland in Billund, Denmark each year. This year was no exception and I was thrilled when Mogens asked me while in attendance at RMOUG’s Training Days if I would come to Denmark and do my presentation on EM12c, (then let…