Re: Managing Archived Redo Logs

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Wed, 23 Jul 2003 16:26:39 -0400
Message-Id: <25998.339255@fatcity.com>

I believe that if the database is "hung" because of the archiver unable to write because of the lack of disk space, you can still connect using the svrmgr. It at least gives you a method of snooping around of your alert log doesn't point to the problem.
Ron

>>> wisernet100_at_yahoo.com 07/23/03 04:14PM >>> no lightening bolt, remind me not to post things after lunch...

the database will appear to hang. you like that phrasing better? :)

If you cycle around in the redo logs to the point where Oracle would have to overwrite an unarchived log, no one can log into the database and most processes will stop, waiting for the log to be archived.  

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

  ---

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Wed Jul 23 2003 - 15:26:39 CDT