Re: When LOG_ARCHIVE_DEST fills up?

Chris Little (chris.little_at_cho.ge.com) wrote:

: I read a long time ago that when the LOG_ARCHIVE_DEST fills up (there's
: no space left on the disk), that the database comes to a halt. However, I
: forget the details and can't seem to find a detailed description of the
: event in the documentation. I'm wondering what happens to current
: transactions, when does the halt take place (when a the archiver tries to
: write the redo log file or when the log writer tries to write to that
: redo log file again, but discovers that it hasn't been written by the
: archiver yet.)
 

: If anyone can provide the details or point me to the appropriate
: documentation, I would be most grateful. Thanks in advance for your help.
 

: Chris Little
: SAP Basis Admin & Oracle DBA
: GE Fanuc Automation

Actually, this happened to us (accidently) last week. Believe it or not, ORACLE actually recovered totally as soon as wee freed up enough space for the archived redo log to be completely written out - and continued running as if nothing had happened.

This is running 7.1.4 for SVR4. It did take about 2 hours to straighten itself out though !

-- 
Michael Marsden                   "It's the car, right ? Chicks dig the car"
ORACLE Database Consultant                              -- BATMAN Forever --
mmarsden_at_netcom.com, mmarsden_at_ozemail.com.au  
Disclaimer: I own the company so I can say what I like !