As much as I hate to disagree with the DBA Goddess...
The database will not HANG. A more appropriate term is that further processing is
halted until it is able to archive the redo log before it begins to overwrite it.
You will receive a message in the alert log, I don't recall the exact text, but it is
along the lines of archiver stuck or unable to archive a log.
<waiting for the lightning bolt...>
Rachel Carmichael wrote:
>
> Yes you have to move them to tape and either compress or delete them
> once you have backed up the logs and datafiles.... Check out the
> Backup and Recovery Handbook by Velpuri, there are some pretty good
> examples there.
>
> If you don't clean out the archive directory on occasion, the database
> will hang when that filesystem is filled. you won't get a message that
> it's hung but it will hang.
begin:vcard
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
x-mozilla-html:TRUE
adr:;;;;;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard
