Hello,
I have a SE 10.2.0.1.0 database
Wed Mar 23 22:20:08 2016
KCF: write/open error block=0x6cdc online=1
file=3 C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF
error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.'
Automatic datafile offline due to write error on
file 3: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF
no backup is available!
File is in RECOVER mode
select name, status from v$datafile
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF
RECOVER
This error is from a couple of months ago, no backup is available for it. Database has been restarted a couple of times, what I get now is
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\pit0_j001_1912.trc:
ORA-12012: error on auto execute of job xx
ORA-00376: file ORA-00376: file 3 cannot be read at this time
ORA-01110: data file 3: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF'
ORA-06512: at "EXFSYS.DBMS_RLMGR_DR", line 15
however I did a dbv and
backup validate check logical tablespace SYSAUX;
there are no corrupted blocks
CanI bring it back online in some way?