Tuesday, May 29, 2007

[Oracle 10G + ASM] ORA-00376: file 5 cannot be read at this time

We have used Oracle 10G R2 RAC + ASM on Redhat 4 (EMC cx700 Storage)

I found below errors on alert log and can't inserted, updated and deleted datas in database.

Sun May 27 01:12:34 2007
SUCCESS: diskgroup ARCH was mounted
SUCCESS: diskgroup ARCH was dismounted
SUCCESS: diskgroup ARCH was mounted
SUCCESS: diskgroup ARCH was dismounted
SUCCESS: diskgroup ARCH was mounted
SUCCESS: diskgroup ARCH was dismounted
Sun May 27 01:19:11 2007
Errors in file /oracle/product/admin/DB/udump/db3_ora_15854.trc:
ORA-00376: file 5 cannot be read at this time
ORA-01110: data file 5: '+DATA/db/datafile/undotbs3.257.617849281'
ORA-00376: file 5 cannot be read at this time
ORA-01110: data file 5: '+DATA/db/datafile/undotbs3.257.617849281'
ORA-00376: file 5 cannot be read at this time
ORA-01110: data file 5: '+DATA/db/datafile/undotbs3.257.617849281'
ORA-00372: file 5 cannot be modified at this time
ORA-01110: data file 5: '+DATA/db/datafile/undotbs3.257.617849281'

So I resolve By:

I checked and recovered data file

SQL> select name,status,file# from v$datafile where status ='RECOVER';
NAME
--------------------------------------------------------------------------------
STATUS FILE#
------- ----------
+DATA/db/datafile/undotbs3.257.617849281
RECOVER 5


RMAN> run {
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type DISK;
recover datafile 5;
}
recover completed.

SQL> alter database datafile 5 online;

This can resolve this problem. But i don't know How It's happened!

2 comments:

Alfredo said...

Hi I had the same problem with 11G RAC + ASM on Oracle Linux 5 (EMC CX3-10c). Have you found the cause?
I hope to stay in contact

Regards
Alfredo Trejo

Surachart Opun said...

I'm not sure... But my problem while My database heavy insert/update/delete

if you often see the problem. you should open SR.

On old version: may see it when convert database to use AUM (Automatic Undo Management) and old rollback segment tablespace is taken offline, some SQL starts failing with the following errors pointing to the old rollback segment tablespace.