Errors in file /u01/app/oracle//admin/pr09/bdump/pr09_ckpt_29193.trc: ORA-01171 (See ORA-01171.ora-code.com): datafile 12 going offline due to error advancing checkpoint ORA-01110 (See ORA-01110.ora-code.com): data file 12: '/u01/oradata/pr09/agile_indx101pr09.ora' ^^^^^^^^^^^^^ ... Is this ext3 ?
... are there corresponding /var/log/messages entries for these EIO errors tht would impugn the scsi layer or other goodies downwind? Trying to establish if this is an EIO pushed up from a software layer (perhaps powerpath) ? Being intermittant there whould be /var/log/messages goodies to clue us in