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 >
“Seriously John, do you blog about anything else?” Yeah, well… Evidence is strongly against me so far. :) One of the more common questions I’ve received as a followup to my Build an E-Business Suite 12.1.3 Sandbox In VirtualBox in…Read More >
Here are the Top 5 things in Oracle E-Business Suite world that will have major impact in 2014 and beyond. 1. Oracle E-Business Suite 12.2 Now Available 2013 started on a low note in Oracle E-Business Suite (EBS) World. Many…Read More >
The performance of any Oracle database heavily relies on query execution(s). The reasons for any SQL statement’s execution plan changes could include a variety of actions, like gathering optimizer statistics (table, index, schema etc.) changing optimizer parameters, schema definitions, adding…Read More >
As most DBAs are aware, the clean deletion of the old statspack snaps is very difficult up to rdbms version 9i. Thanks to the statspack.purge procedure introduced by oracle from 10gR1 version, now it’s possible to purge un-referenced data too….Read More >