Monthly Archives: May 2008

11g Snapshot Database

A new feature called the Snapshot DATABASE in 11g reduces the amount of manual steps in previous versions to accomplish the same tasks.   See other posts about DATAGUARD and FLASHBACK.  This allows you to use a physical standby for all sorts of tasks … Continue reading

Posted in 11g, DATA GUARD, FLASHBACK, Physical Standby, Recovery | Tagged | Leave a comment

What makes a good Oracle DBA?

Speaking at many conferences this seems to be the question asked most often.  Perhaps that organization is migrating to a new database platform, under new management or wary of their current DBA (s).  1.  How often is the database down?  Keep … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Recovery Scenario: Deleted online redo logs and controlfile

oracle@nodename:/u03/oradata[SID18] > ls SID3 SID2 SID28 SID1 oracle@nodename:/u03/oradata[SID18] > rm -rf SID2* I realize that typing a * instead of an 8 too late, hit Enter key already. Try to figure out what was damaged. This is a non-production database … Continue reading

Posted in Recovery | Tagged | 5 Comments