Oracle Introduces New Database Software

Oracle recently announced a new product, Oracle Big Data SQL. It’s designed to run on the Oracle Exadata database machine, creating a shared connection for exchanging data more efficiently between a company’s data silos. One of the long-time issues with collecting big data is that it’s difficult to compile and really maximize its value. Oracle […]

Clearing Unused Corrupt (Nologging) Blocks

I recently had the unfortunate experience of having to restore / recover a database that had undergone ‘nologging’ operations after the latest backup. Of course, the presence of blocks recovered through a nologging operation causes ORA-01578 errors such as ORA-01578: ORACLE data block corrupted (file # 11, block # 91658) ORA-01110: data file 11: ‘+DATADG/tollprd/datafile/toll_t01.256.849581711′ […]

Intel Introduces Custom Chip Design for Oracle

Intel has added one more custom processor to its list of tailored processor chips. Oracle’s new database machine, the Exadata Database X4-8, will now have core count and processor frequency dynamically scaled for its software workloads. This is ideal for businesses involved with integration of big data, a growing mobile community and more complex database […]

Understanding UNDO

Sooner or later, every Oracle DBA will hit a problem of some sort that is related to the concept of Oracle “Undo”. The Oracle Undo performs a few very important functions in the database; these being the support of read-consistent queries and Flashback queries, supporting transactions (COMMIT and ROLLBACK), and recovering from database crashes. Along […]

Recovery of ASM Disks Using Backup Blocks on AIX

There are some simple commands (not all well documented) ┬áto debug an ORA-15032 “not all operations performed” when a disk group won’t mount. Validate the device permissions and ownership on all nodes with a simple “ls -l /dev/rdisk*” command and correct any issues found. Run the storage check of the cluster verify utility. cluvfy comp […]