Alguma solução para esse erro? DBW0: terminating instance due to erro

[Muricy 0]

Simplesmente ele acusa esse erro todos os dias e desmonta a base.

 

Tue Apr 24 02:08:10 2007

KCF: write/open error block=0x79 online=1

file=2 D:\APPS\SIXX\ORACLEEXE\ORADATA\XE\UNDO.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.'

Tue Apr 24 02:08:11 2007

Errors in file d:\apps\sixx\oracleexe\app\oracle\admin\xe\bdump\xe_dbw0_3668.trc:

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

ORA-01114: IO error writing block to file 2 (block # 121)

ORA-01110: data file 2: 'D:\APPS\SIXX\ORACLEEXE\ORADATA\XE\UNDO.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

Tue Apr 24 02:08:12 2007

Errors in file d:\apps\sixx\oracleexe\app\oracle\admin\xe\bdump\xe_q001_1048.trc:

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

 

Tue Apr 24 02:08:12 2007

Errors in file d:\apps\sixx\oracleexe\app\oracle\admin\xe\bdump\xe_psp0_3040.trc:

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

 

Tue Apr 24 02:08:12 2007

Errors in file d:\apps\sixx\oracleexe\app\oracle\admin\xe\bdump\xe_lgwr_3568.trc:

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

 

Tue Apr 24 02:08:13 2007

Errors in file d:\apps\sixx\oracleexe\app\oracle\admin\xe\bdump\xe_mman_2788.trc:

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

 

Tue Apr 24 02:08:13 2007

Errors in file d:\apps\sixx\oracleexe\app\oracle\admin\xe\bdump\xe_ckpt_2896.trc:

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

 

Tue Apr 24 02:08:14 2007

Errors in file d:\apps\sixx\oracleexe\app\oracle\admin\xe\bdump\xe_j000_1028.trc:

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

 

Tue Apr 24 02:08:15 2007

Errors in file d:\apps\sixx\oracleexe\app\oracle\admin\xe\bdump\xe_pmon_3504.trc:

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

 

Tue Apr 24 02:08:25 2007

Errors in file d:\apps\sixx\oracleexe\app\oracle\admin\xe\bdump\xe_reco_2164.trc:

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

 

Tue Apr 24 02:08:25 2007

Errors in file d:\apps\sixx\oracleexe\app\oracle\admin\xe\bdump\xe_smon_3964.trc:

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

 

Tue Apr 24 02:08:28 2007

Instance terminated by DBW0, pid = 3668

Dump file d:\apps\sixx\oracleexe\app\oracle\admin\xe\bdump\alert_xe.log

[alphamek 2]

Verifica se o serviço de ARCHIVE está ativo, sendo que seu banco de dados está em NOARCHIVELOG.Para verificar se está ativo, logue no SQL*PLUS com sys as sysdba.depois faça:SQL > archive log listE poste os resultados.Abraços,