ORA-19504: failed to create file

[Subramaniyan.S]

Hi,

We get the following error message while oracle archiving process.


ARC1: Completed archiving log 2 thread 1 sequence 15224
Mon Apr 10 22:17:10 2006
Thread 1 advanced to log sequence 15226
Current log# 1 seq# 15226 mem# 0: /oradata1/trds/redo01a.log
Current log# 1 seq# 15226 mem# 1: /oradata2/trds/redo01b.log
Mon Apr 10 22:17:10 2006
ARC0: Evaluating archive log 3 thread 1 sequence 15225
ARC0: Beginning to archive log 3 thread 1 sequence 15225
Creating archive destination LOG_ARCHIVE_DEST_1: '/oradata1/arch/trds10000015225_1'
ARC0: Error 19504 Creating archive log file to '/oradata1/arch/trds10000015225_1'
Mon Apr 10 22:17:11 2006
Errors in file /oracle/app/product/oracle/9.2.0/admin/trds/bdump/trds1_arc0_3389.trc:
ORA-19504: failed to create file "/oradata1/arch/trds10000015225_1"
ORA-19504: failed to create file "/oradata1/arch/trds10000015225_1"
ORA-27044: unable to write the header block of file <<<<<<
Linux-ia64 Error: 28: No space left on device <<<<<<<<
Additional information: 3
ARC0: Archiving not possible: error count exceeded
ARC0: Failed to archive log 3 thread 1 sequence 15225
ARCH: Archival stopped, error occurred. Will continue retrying
Mon Apr 10 22:17:11 2006
ORACLE Instance trds1 - Archival Error
ARCH: Connecting to console port...
Mon Apr 10 22:17:11 2006
ORA-16038: log 3 sequence# 15225 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 3 thread 1: '/oradata1/trds/redo03a.log'
ORA-00312: online log 3 thread 1: '/oradata2/trds/redo03b.log'
ARCH: Connecting to console port...
ARCH:
Mon Apr 10 22:17:11 2006
ORA-16038: log 3 sequence# 15225 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 3 thread 1: '/oradata1/trds/redo03a.log'
ORA-00312: online log 3 thread 1: '/oradata2/trds/redo03b.log'
Mon Apr 10 22:17:11 2006
Errors in file /oracle/app/product/oracle/9.2.0/admin/trds/bdump/trds1_arc0_3389.trc:
ORA-16038: log 3 sequence# 15225 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 3 thread 1: '/oradata1/trds/redo03a.log'
ORA-00312: online log 3 thread 1: '/oradata2/trds/redo03b.log'
ARC0: Evaluating archive log 3 thread 1 sequence 15225
ARC0: Beginning to archive log 3 thread 1 sequence 15225
_______________________________________________

the df output is:

/dev/md1 11087040 8608384 1915460 82% /
none 0 0 0 - /proc
usbdevfs 0 0 0 - /proc/bus/usb
/dev/sda2 408784 12300 396484 4% /boot/efi
none 0 0 0 - /dev/pts
/dev/md4 10079020 8730036 836988 92% /oracle
none 16644496 0 16644496 0% /dev/shm
/dev/md3 5039552 34104 4749452 1% /tmp
/dev/md2 9071024 132376 8477852 2% /var
/dev/spdev/spa3 10079084 7498056 2069028 79% /orastage
/dev/spdev/spc1 51504316 44612180 4275868 92% /orastage1
/dev/sdc4 173144160 78960736 94183424 46% /oradata1
/dev/sdd 199227488 108155744 91071744 55% /oradata2

-----------------------------------------------

Having lot of space in /oradata1 FS.

What could be the problem?

Please help.

Thanks in advance

Subbu

[Claudio Cilloni]

maybe you're running out of inodes, if your filesystem type is ext3. could you post the output of 'df -i' command?