Among the most critical but often most neglected database administration tasks is testing restore from backup. But sometimes, you don’t have a test system handy, and need to test the restore on the same host as the source database. In…Read More >
Lately, I am becoming infatuated with RMAN again. Have you ever run “restore database preview”? Are you curious about how the recovery SCN are determined? Media recovery start SCN is 1515046 Recovery must be done beyond SCN 1515051 to clear…Read More >
Musings about COLLABORATE, the 9th version of which is happening in Las Vegas USA from April 7-11 2014.Read More >
OakTable Network will be holding its OakTable World for the very first time during the COLLABORATE conference.Read More >
This year COLLABORATE 14 is being held at The Venetian and Sands Expo Center in Las Vegas, April 7-11. Some Pythian folks will be attending and speaking at the event, so be sure to watch for their presentations: Session Date…Read More >
There are many posts out there about validating backup. However, none seem to address some recent concerns a client of mine had. Currently, backup validation is performed once a week and the question asked, “How to validate all archivelog backup?”…Read More >
The RMAN VALIDATE RECOVERY FILES command is a simple way to validate all backups, or so I thought.
In some versions it is broken, and in the versions where the bug has been fixed, it is even more broken.
When we talk about logical corruption, there are two different failure states that fall under this label: Accidental or incorrect modification of application data by a user or application. In this scenario, a user or application, either by misadventure or…Read More >
What’s the most elaborate thing you have done with DataPump? So there I was, given the requirement to export multiple partitions for multiple tables where each partition has its own dump file having the format “tablename_partitionanme.dmp”, pondering how this can…Read More >