Hi all,

DB:10.2.0.3 in RAC/Dataguard config
O/S: RHEL 4

We have just moved datafiles from one ASM diskgroup to another. We had to move the datafiles because the underlying LUN for that
particular ASM diskgroup was suspect and a new disk rebuild is needed. Once the
datafile was online we ran a normal application query and got the error:

Code:
SQL> select count(*) from plateimages t
where t.datetime > sysdate -24
and t.datetime < sysdate -19
and t.id like 'YR06BGE%'
--and substr(id,(length(id)-13),4) = '0002' 2 3 4 5 ;

select count(*) from plateimages t
*
ERROR at line 1:
ORA-00376: file 2724 cannot be read at this time
ORA-01110: data file 2724:
'+VGROUP36/dbh/datafile/img3_id_2008_02_12.365.648647395'

We checked dba_data_files to confirm that the file was online and available:

SQL> select * from dba_data_files where 
file_id=2724;


FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- 
-----------
ONLINE_
-------
+VGROUP36/dbh/datafile/img3_id_2008_02_12.365.648647395
2724 IMG3_ID_2008_02_12 AVAILABLE
1024
ONLINE
I can see no other errors and no trace files have been generated. We have a standby configuration and restored the above file from the
standby but we got the same error.

Any advise will be much appreciated,

Thanks in advance,
Chucks