I moved our redo, control and datafiles to a different disk drive. Everything seemed ok. Lots of redo logs written and backups and exports occuring as usual. But for the last two nights I have gotten datafile failures. Help!
Does anyone have any suggections on what might be going on. This mornign I had to recover sysaux01.dbf and yesterday it was a different datafile.
Thanks!
Kathie
Below was first sign on trouble in alert log <<<<<<<<<<<<<<<<<<<
Original file E:\oracle\product\10.2.0\admin\eaulive\bdump\alert_eaulive.log
Thu Jan 10 05:00:04 2008
Errors in file e:\oracle\product\10.2.0\admin\eaulive\bdump\eaulive_j000_3712.trc:
ORA-12012: error on auto execute of job 57089
ORA-27369: job of type EXECUTABLE failed with exit code: The extended attributes are inconsistent.
Thu Jan 10 05:45:00 2008
The value (30) of MAXTRANS parameter ignored.
Thu Jan 10 05:45:00 2008
Thread 1 advanced to log sequence 1786
Current log# 2 seq# 1786 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\EAULIVE\REDO02.LOG
kupprdp: master process DM00 started with pid=19, OS id=2952
to execute - SYS.KUPM$MCP.MAIN('EAUDB_REFRESH', 'ECUTILITY', 'KUPC$C_1_20080110054500', 'KUPC$S_1_20080110054500', 0);
kupprdp: worker process DW01 started with worker id=1, pid=20, OS id=3776
to execute - SYS.KUPW$WORKER.MAIN('EAUDB_REFRESH', 'ECUTILITY');
Thu Jan 10 05:47:40 2008
Errors in file e:\oracle\product\10.2.0\admin\eaulive\udump\eaulive_ora_3124.trc:
ORA-00202: control file: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\EAULIVE\CONTROL01.CTL'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
Thu Jan 10 05:47:41 2008
Errors in file e:\oracle\product\10.2.0\admin\eaulive\udump\eaulive_ora_3124.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kxsdcbc+506] [PC:0x8A7A3E] [ADDR:0x18] [UNABLE_TO_READ] []
ORA-00202: control file: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\EAULIVE\CONTROL01.CTL'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
Thu Jan 10 05:47:41 2008
Errors in file e:\oracle\product\10.2.0\admin\eaulive\udump\eaulive_ora_3124.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kxsdcbc+506] [PC:0x8A7A3E] [ADDR:0x18] [UNABLE_TO_READ] []
ORA-00202: control file: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\EAULIVE\CONTROL01.CTL'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
Thu Jan 10 05:47:41 2008
Errors in file e:\oracle\product\10.2.0\admin\eaulive\udump\eaulive_ora_3124.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kxsdcbc+506] [PC:0x8A7A3E] [ADDR:0x18] [UNABLE_TO_READ] []
ORA-00202: control file: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\EAULIVE\CONTROL01.CTL'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
Thu Jan 10 05:50:04 2008
KCF: write/open error block=0x8 online=1
file=5 E:\ORACLE\PRODUCT\10.2.0\ORADATA\EAULIVE\UWEC_DATA.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 5: E:\ORACLE\PRODUCT\10.2.0\ORADATA\EAULIVE\UWEC_DATA.DBF
Thu Jan 10 06:45:00 2008
The value (30) of MAXTRANS parameter ignored.
Thu Jan 10 07:45:00 2008
The value (30) of MAXTRANS parameter ignored.
Thu Jan 10 08:45:00 2008
The value (30) of MAXTRANS parameter ignored.
Thu Jan 10 09:45:00 2008
The value (30) of MAXTRANS parameter ignored.
Thu Jan 10 10:45:00 2008
The value (30) of MAXTRANS parameter ignored.
Thu Jan 10 11:10:46 2008
The value (30) of MAXTRANS parameter ignored.
Thu Jan 10 11:45:00 2008
The value (30) of MAXTRANS parameter ignored.
Thu Jan 10 11:49:33 2008
Thread 1 advanced to log sequence 1787
Current log# 1 seq# 1787 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\EAULIVE\REDO01.LOG
Thu Jan 10 12:45:00 2008
The value (30) of MAXTRANS parameter ignored.
Thu Jan 10 13:01:56 2008
alter tablespace temp online
Thu Jan 10 13:01:56 2008
ORA-3217 signalled during: alter tablespace temp online...
Thu Jan 10 13:02:14 2008
alter tablespace uwec_data online
Thu Jan 10 13:02:14 2008
ORA-1113 signalled during: alter tablespace uwec_data online...
Thu Jan 10 13:05:17 2008
ALTER DATABASE RECOVER datafile 'E:\oracle\product\10.2.0\oradata\eaulive\uwec_data.dbf'
Thu Jan 10 13:05:17 2008
Media Recovery Start
parallel recovery started with 3 processes
Thu Jan 10 13:05:17 2008
Recovery of Online Redo Log: Thread 1 Group 3 Seq 1785 Reading mem 0
Mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\EAULIVE\REDO03.LOG
Thu Jan 10 13:05:20 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 1786 Reading mem 0
Mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\EAULIVE\REDO02.LOG
Completed: ALTER DATABASE RECOVER datafile 'E:\oracle\product\10.2.0\oradata\eaulive\uwec_data.dbf'
Thu Jan 10 13:05:42 2008
ALTER DATABASE RECOVER datafile 'E:\oracle\product\10.2.0\oradata\eaulive\users01.dbf'
Thu Jan 10 13:05:42 2008
Media Recovery Start
Thu Jan 10 13:05:42 2008
Media Recovery failed with error 1124
ORA-283 signalled during: ALTER DATABASE RECOVER datafile 'E:\oracle\product\10.2.0\oradata\eaulive\users01.dbf' ...
Thu Jan 10 13:07:39 2008
alter database datafile 'E:\oracle\product\10.2.0\oradata\eaulive\uwec_data.dbf' online
Thu Jan 10 13:07:39 2008
Starting control autobackup
Control autobackup written to DISK device
handle 'E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\EAULIVE\AUTOBACKUP\2008_01_10\O1_MF_S_643640859_3RDV7W2X_.BKP'
Completed: alter database datafile 'E:\oracle\product\10.2.0\oradata\eaulive\uwec_data.dbf' online
Thu Jan 10 13:09:40 2008
ALTER DATABASE RECOVER datafile 'E:\oracle\product\10.2.0\oradata\eaulive\UNDOTBS01.dbf'
Thu Jan 10 13:09:40 2008
Media Recovery Start
Thu Jan 10 13:09:40 2008
Media Recovery failed with error 1124
ORA-283 signalled during: ALTER DATABASE RECOVER datafile 'E:\oracle\product\10.2.0\oradata\eaulive\UNDOTBS01.dbf' ...
Thu Jan 10 13:10:19 2008
alter database datafile 'E:\oracle\product\10.2.0\oradata\eaulive\USERS01.dbf' online
Thu Jan 10 13:10:19 2008
Starting control autobackup
Control autobackup written to DISK device
last nights alert log <<<<<<<<<<<<<<<<<<<<<<<<
Fri Jan 11 01:56:58 2008
Thread 1 advanced to log sequence 1801
Current log# 2 seq# 1801 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\EAULIVE\REDO02.LOG
Fri Jan 11 02:45:00 2008
The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=20, OS id=2392
to execute - SYS.KUPM$MCP.MAIN('EAUDB_REFRESH', 'ECUTILITY', 'KUPC$C_1_20080111024500', 'KUPC$S_1_20080111024500', 0);
kupprdp: worker process DW01 started with worker id=1, pid=25, OS id=772
to execute - SYS.KUPW$WORKER.MAIN('EAUDB_REFRESH', 'ECUTILITY');
Fri Jan 11 03:10:36 2008
Thread 1 advanced to log sequence 1802
Current log# 1 seq# 1802 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\EAULIVE\REDO01.LOG
Fri Jan 11 03:18:41 2008
Thread 1 advanced to log sequence 1803
Current log# 3 seq# 1803 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\EAULIVE\REDO03.LOG
Fri Jan 11 03:25:35 2008
Thread 1 advanced to log sequence 1804
Current log# 2 seq# 1804 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\EAULIVE\REDO02.LOG
Fri Jan 11 03:45:00 2008
The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=20, OS id=3880
to execute - SYS.KUPM$MCP.MAIN('EAUDB_REFRESH', 'ECUTILITY', 'KUPC$C_1_20080111034500', 'KUPC$S_1_20080111034500', 0);
kupprdp: worker process DW01 started with worker id=1, pid=25, OS id=3612
to execute - SYS.KUPW$WORKER.MAIN('EAUDB_REFRESH', 'ECUTILITY');
Fri Jan 11 04:13:29 2008
Thread 1 advanced to log sequence 1805
Current log# 1 seq# 1805 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\EAULIVE\REDO01.LOG
Fri Jan 11 04:44:05 2008
KCF: write/open error block=0x676f online=1
file=3 E:\ORACLE\PRODUCT\10.2.0\ORADATA\EAULIVE\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: E:\ORACLE\PRODUCT\10.2.0\ORADATA\EAULIVE\SYSAUX01.DBF
Fri Jan 11 04:44:17 2008
KCF: write/open error block=0xdd73 online=1
file=1 E:\ORACLE\PRODUCT\10.2.0\ORADATA\EAULIVE\SYSTEM01.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.'
Fri Jan 11 04:44:17 2008
Errors in file e:\oracle\product\10.2.0\admin\eaulive\bdump\eaulive_dbw0_2608.trc:
ORA-01243: system tablespace file suffered media failure
ORA-01114: IO error writing block to file 1 (block # 56691)
ORA-01110: data file 1: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\EAULIVE\SYSTEM01.DBF'
ORA-27072: File I/O error
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.
ORA-27047: unable to read the header block of file
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
DBW0: terminating instance due to error 1243
Fri Jan 11 04:44:17 2008
Errors in file e:\oracle\product\10.2.0\admin\eaulive\bdump\eaulive_lgwr_2612.trc:
ORA-01243: system tablespace file suffered media failure
Fri Jan 11 04:44:18 2008
Errors in file e:\oracle\product\10.2.0\admin\eaulive\bdump\eaulive_ckpt_2616.trc:
ORA-01243: system tablespace file suffered media failure