Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help! -- Oracle shut down Unexpectedly

597658Sep 12 2007 — edited Sep 12 2007

here is my log file, there is plenty of hard drive space and my dbase server has 4GB memory.(although i dont know how much was being used at the time it went down)

Also there is a disk backup that starts around 3:00am, could this be interfering with Oracle???

we are using Oracle 10g
Any Help is appreciated...

<<<excerpt of log>>>

Wed Sep 12 03:39:54 2007
KCF: write/open error block=0x62e4 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.'
Wed Sep 12 03:39:54 2007
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_dbw0_2132.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 3 (block # 25316)
ORA-01110: data file 3: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.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.

DBW0: terminating instance due to error 1242
Wed Sep 12 03:39:54 2007
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_ckpt_2140.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Wed Sep 12 03:39:54 2007
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j000_1388.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Wed Sep 12 03:39:54 2007
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_2120.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Wed Sep 12 03:39:54 2007
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mman_2128.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Wed Sep 12 03:39:55 2007
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_lgwr_2136.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Wed Sep 12 03:39:56 2007
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_psp0_2124.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Wed Sep 12 03:39:56 2007
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2144.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Wed Sep 12 03:40:06 2007
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_q001_3116.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Wed Sep 12 03:40:08 2007
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_reco_2148.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Wed Sep 12 03:40:09 2007
Instance terminated by DBW0, pid = 2132
Dump file c:\oracle\product\10.2.0/admin/orcl/bdump\alert_orcl.log

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 10 2007

Added on Sep 12 2007

#general-database-discussions

2 comments

414 views