Re: Managing Archived Redo Logs

From: Daniel Fink <daniel.fink_at_sun.com>
Date: Wed, 23 Jul 2003 12:52:24 -0600
Message-Id: <25998.339224@fatcity.com>

This is a multi-part message in MIME format.

--------------E3194594A90F7774352A32FA
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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.

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.

--------------E3194594A90F7774352A32FA
Content-Type: text/x-vcard; charset=us-ascii; name="daniel.fink.vcf"

Content-Transfer-Encoding: 7bit
Content-Description: Card for Daniel Fink
Content-Disposition: attachment;

filename="daniel.fink.vcf"

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:daniel.fink_at_sun.com
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard

--------------E3194594A90F7774352A32FA-- Received on Wed Jul 23 2003 - 13:52:24 CDT