Oracle 11g

What Does oracle-rdbms-server-11gR2-preinstall Not Do?

I was working on a project to clone Oracle install to a new Linux server and this should be simple as oracle-rdbms-server-11gR2-preinstall RPM can be used to configure the server, right? So simple that I did not read the documentation. However, I did review Requirements for Installing Oracle 11gR2 RDBMS on RHEL6 or OL6 64-bit…

RMAN – Validating Archivelog Backup

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?” List Backups – [D}atafile and [A]rchivelog backup from Incremental Level 0/1 RMAN> list backup summary;…

Oracle Free Block Corruption – Test Case

My very first blog post at Pythian – Trick or Treat? So there I was, faced with more that 4000 block corruptions as shown from v$database_block_corruption. The script  corrupt_seg.sql identified the corruption as Free Block Corruption (block not associated with any segments). So how can free block corruption be removed? One method is to format the corrupted…

OEM Notification on Generated Trace Files

The predefined metric “Dump Area Used (%)” can monitor space consumption for dump destination of oracle database. However, it just triggers on percentage occupied, and if there are several databases on the host using the same file system for trace files destination, the metric notifies DBA for all databases at once. I decided to create…

Insider’s Guide to ODA Performance

If you are interested in the topic of ODA performance but missed the webinar or if you want to hear it again, you can view our recording here. I also uploaded the slides to slideshare, so you can take a better look at our benchmark results and study our consolidation methods at your own pace.