Menu de navegação

[souzaParticipante]

Meu banco há alguns dias caiu repentinamente e gostaria de ajuda para identificar o que ocorreu. Abrindo o alert.log pude identificar coisas estranhas , como:

Shutting down instance: further logons disabled
Shutting down instance (immediate)

Mon Sep 24 17:30:39 2007
ARC0: Evaluating archive log 2 thread 1 sequence 951
ARC0: Beginning to archive log 2 thread 1 sequence 951
Creating archive destination LOG_ARCHIVE_DEST_1: ‘G:ORACLEARCHIVEARCH_ORAINFO1_951.LOG’
ARC0: Error 19504 Creating archive log file to ‘G:ORACLEARCHIVEARCH_ORAINFO1_951.LOG’
Mon Sep 24 17:30:39 2007
Errors in file e:oracleadminorainfo1bdumporainfo1_arc0_5864.trc:
ORA-19504: failed to create file “G:ORACLEARCHIVEARCH_ORAINFO1_951.LOG”
ORA-19504: failed to create file “G:ORACLEARCHIVEARCH_ORAINFO1_951.LOG”
ORA-27044: unable to write the header block of file
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 112) There is not enough space on the disk.
ARC0: Archiving not possible: error count exceeded
ARC0: Failed to archive log 2 thread 1 sequence 951
Mon Sep 24 17:30:39 2007
Errors in file e:oracleadminorainfo1bdumporainfo1_arc0_5864.trc:
ORA-16038: log 2 sequence# 951 cannot be archived
ORA-19504: failed to create file “”
ORA-00312: online log 2 thread 1: ‘E:ORACLEORADATAORAINFO1REDO02A.LOG’
ORA-00312: online log 2 thread 1: ‘F:ORACLEORADATAORAINFO1REDO02B.LOG’
ORA-00312: online log 2 thread 1: ‘G:ORACLEORADATAORAINFO1REDO02C.LOG’

Shutting down instance (immediate)
License high water mark = 169
Mon Sep 24 20:49:44 2007
ALTER DATABASE CLOSE NORMAL
Mon Sep 24 20:49:44 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon Sep 24 20:49:45 2007
Shutting down archive processes
Archiving is disabled
Mon Sep 24 20:49:45 2007
ARCH shutting down
Mon Sep 24 20:49:45 2007
ARC0: Archival stopped
Mon Sep 24 20:49:45 2007
Thread 1 closed at log sequence 953
Successful close of redo thread 1.
Mon Sep 24 20:49:46 2007
Completed: ALTER DATABASE CLOSE NORMAL
Mon Sep 24 20:49:46 2007
ALTER DATABASE DISMOUNT
Mon Sep 24 20:49:46 2007
ARCH shutting down
Mon Sep 24 20:49:46 2007
ARC1: Archival stopped
Mon Sep 24 20:49:46 2007
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Sep 24 20:49:53 2007
Starting ORACLE instance (normal)
Mon Sep 24 20:49:53 2007
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_SESSION = 0

Alguém poderia me ajudar a identifcar tais problemas

[Marcio68AlmeidaParticipante]

Aparentemente ele não caiu, foi derrubado com shutdown immediate…
O que eu percebi é que não há espaço para a geração de archive log.
Ou permissão de gravação…
Veja espaço em disco.
O Archivelog foi desabilitado quando subiu pela segunda vez…

[Autor]

Posts