Oracle instance doesn't start under control of Oracle Disk Manager (ODM) module
Article ID: 100013041
Updated On:
Description
Error Message
Errors seen in the Oracle alert log during online attempt:
Errors in file /sbisrdbprd/ora/diag/rdbms/sbisr1p/SBISR1P/trace/SBISR1P_smon_17768.trc:
ORA-01115: IO error reading block from file (block # )
ORA-01110: data file 1: '/sbisrdbprd/ora/data01/SBISR1P/system_0001.dbf'
ORA-17500: ODM err:ODM ERROR V-41-4-2-230-5 Input/output error
ORA-17500: ODM err:ODM ERROR V-41-4-2-230-5 Input/output error
Cause
Issue related to a sparse file. It transpired that ODM could not cope with the "hole" encountered in the dbf file and failed to online the instance.
Resolution
Using the file "system_0001.dbf" as an example, the workaround is as follows:
shut down the database
cp system_0001.dbf system_0001.OLD
/opt/VRTS/bin/odmmkfile system_0001.dbf –s
dd if=system_0001.OLD of=system_0001.dbf
The steps above essentially backs up the dbf file, and then uses odmmkfile to create a file with preallocated, contiguous disk space, and copies the dbf file into the new file using dd. Once complete, the instance can then be started under ODM control.
Engineering are set to enhance ODM in the 6.2 release due at the end of the year. This will be performed via e 3269552
Applies To
RedHat 6.5
SFHA 6.0.300.300
Oracle 11.2.0.4
Issue/Introduction
