Background ========== We had been performing flashback testing on a dev database testing upgrade rollback options. The testing plan was as follows:- 1. Cold database backup 2. Create GRP 3. Application upgrade 4. Flashback database 5. Application upgrade 6. Flashback…
Been looking upgrading to 12c recently and with that comes the upgrade of the rman catalog. The current plan was to leave the RDBMS at 11g but upgrade the catalog to 12.1.0.2 to cover the new databases. From experience it…
Been doing alot of RMAN related work and realised that I’ve not got anything up here to reference so here is the start of a few RMAN articles. This article assumes that you know what RMAN is and understand what…
Hit a problem yesterday, working on a new site reviewing database configurations when i discovered tape backups listed from 2008. After a bit of investigation it turned out they hadnt backed up to tape since 2010 so these bad boys…
PROBLEM: The other day i was tasked with copying one of our customer databases back to one of our HO servers. Easy enough – 500Gb drives are 10 a penny nowaday but how to do this securely without having to…
Issue: Production database server went down with no chance of being recovered without intervention from god Resolution: Once the server had been rebuilt and the database software installed blah blah it was time to start the recovery. Luckily for us…
myoracledbablog 