Dear mas sholehuddin,

coba cek drive 'c:\oracle\admin\ora\bdump\' dan drive 'E:\ARCHIVE',  
kelihatannya sudah penuh.
O/S-Error: (OS 112) There is not enough space on the disk.

regard,
subekti

  ----- Original Message ----- 
  From: M. Sholehhudin Nurisma Tsalasanto 
  To: [email protected] 
  Sent: 24 July 2007 16:37
  Subject: [indo-oracle] Error Archiving


  Salam,

  Saya menggunakan Oracle 9i di Windows 2003 server dan mengatifkan mode 
archivelog.

  Tetapi beberapa hari ini terjadi error pada waktu proses archiving 
(sebelumnya nggak masalah). Beberapa pesan error yang ada di file alert.log 
adalah sebagai berikut:

  ----------------------------------------------------------
  Mon Jul 23 09:32:21 2007
  ARC0: Evaluating archive log 11 thread 1 sequence 727
  ARC0: Beginning to archive log 11 thread 1 sequence 727
  Creating archive destination LOG_ARCHIVE_DEST_1: 'E:\ARCHIVE\1_727.DBF'
  ARC0: Error 19504 Creating archive log file to 'E:\ARCHIVE\1_727.DBF'
  Mon Jul 23 09:32:21 2007
  Errors in file c:\oracle\admin\ora\bdump\ora1_arc0_2400.trc:
  ORA-19504: failed to create file "E:\ARCHIVE\1_727.DBF"
  ORA-19504: failed to create file "E:\ARCHIVE\1_727.DBF"
  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 11 thread 1 sequence 727
  ARCH: Archival stopped, error occurred. Will continue retrying
  ARCH: 
  Mon Jul 23 09:32:21 2007
  ORA-16038: log 11 sequence# 727 cannot be archived
  ORA-19504: failed to create file ""
  ORA-00312: online log 11 thread 1: 'E:\REDOLOG\REDO7_1'
  ORA-00312: online log 11 thread 1: 'E:\REDOLOG\REDO7_2'
  ----------------------------------------------------------

  Terus saya cek di drive tujuan file archive masih tersisa sekitar 9 GB.

  Kira-kira kenapa yaa??

  Mohon pencerahannya...

  Trims.

  ---------------------------------
  Bergabunglah dengan orang-orang yang berwawasan, di bidang Anda di Yahoo! 
Answers

  [Non-text portions of this message have been removed]



   

[Non-text portions of this message have been removed]

Kirim email ke