Custom Search . . .

Saturday, December 25, 2010

ORA-01157: cannot identify/lock data file 37 - see DBWR trace file

Greeting!!! One of our RAC environment getting the below error

ORA-01157: cannot identify/lock data file 37 - see DBWR trace file
ORA-01110: data file 37: '+D02/datafile/01_data.306


This error means only one instance mounted to ASM others are DISMOUNTED. Even when we try to mount the ASM Instance getting the above message.

All the RAC services up but still getting same error .

Work Around:

ALTER SYSTEM CHECK DATAFILES.

After execute this command the one of cluster sync process released from hung stage. We’re able to connect the instance.

Welcome your comments and suggestion, Thanks

1 comment:

Anonymous said...

Thanks it resolved our problem as well.