Oraarch directory deleted from SAP server

[Former Member]

Hi Guys

Someone deleted Oraarch directory from our windows SAP Server but system continued to run normally.

I am not able to understand how it was running fine, as per my understanding System should have got Stalled like when it hangs when Oraarch get 100 % full.

Thanks

Kanchan

[volker_borowski2]

Hi,

sqlplus / as sysdba

archive log list

show parameter arch

This should be able to exclude a couple of possibilities

Volker

[former_member204746]

Hi,

my theory:

it probably was still working because on Unix, Oracle will get the iNode number of the directory once and will not ask the OS for it... when you delete a file, the inode still exist and Oracle might still be writing to that directory

[Former Member]

Eric,

this was my first guess too.

But reading the question again I saw Kanchan was talking about our windows SAP Server.

I am not that good at Windows administration. But never heard of something like that there.

regards

[Former Member]

I suppose (and hope) this situation didn't last for a long time?

Even when oraarch directory is full, Oracle and SAP won't hang immediately.

Oracle will continue to write to the online redo log files, in origlog and mirrlog directories.

In normal operation the contents of full online redo log files will be copied to oraarch directory, and files will be emptied.

Only when Oracle needs another empty online redo log file, and can't find any, Oracle will hang.

Anyway, have a look at your alert log file. There should be error messages, if Oracle wasn't able to write to oraarch directory.

hope this helps