Oracle Database Discussions

Hi All,

I'm working on a 11g DB.

I have following errors in alert.log:

ORA-00604: error occurred at recursive SQL level 1

ORA-00376: file 2 cannot be read at this time

ORA-01110: data file 2: '+A/mydb/datafile/sysaux.258.818084821'

I try to find any analysis about this problem on internet. Here some logs:

SQL> SELECT segment_name,tablespace_name, status

FROM dba_rollback_segs;

....

------------------------------ ------------------------------ ----------------

....

SQL> select name,online_status,error

from v$datafile join v$recover_file using (file#);

NAME

--------------------------------------------------------------------------------

ONLINE_ ERROR

------- -----------------------------------------------------------------

+A/mydb/datafile/sysaux.258.818084821

OFFLINE

SQL> select name , status from v$datafile ;

...

+A/mydb/datafile/sysaux.258.818084821

RECOVER

...

SQL> select FILE_NAME,TABLESPACE_NAME,ONLINE_STATUS,STATUS from dba_data_files;

------------------------------ ------------------------------ ------- ---------

18084821

Then I try to recover the datafile:

SQL> recover datafile 2;

ORA-00279: change 3347348 generated at 06/19/2013 14:02:55 needed for thread 2

ORA-00289: suggestion : +E

ORA-00280: change 3347348 for thread 2 is in sequence #24

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

AUTO

ORA-00308: cannot open archived log '+E'

ORA-17503: ksfdopn:2 Failed to open file +E

ORA-15045: ASM file name '+E' is not in reference form

I don't know the reason of recover check in '+E'.

Really I don't know how to manage ASM.

Can you help me to investigate it?

Can you also suggest me some book, or something else, where to study about ASM?

Thanks a lot,

Ste