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 >
Suggestions about how to proceed if you are just getting started with blogging or searching for topics to blog about.Read More >
There are many blog posts out there about active database duplication. However, they were all tested in an ideal environment or condition. What happens when a tablespace is created during the middle of active duplication and how to resolve the…Read More >