Path: news.easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!feed2.news.rcn.net!rcn!feeder.qis.net!sn-xit-02!supernews.com!postnews1.google.com!not-for-mail
From: allanwtham@yahoo.com (godmann)
Newsgroups: comp.databases.oracle.server
Subject: Re: lost of redo logs
Date: 3 Mar 2002 18:46:21 -0800
Organization: http://groups.google.com/
Lines: 14
Message-ID: <95cd51c.0203031846.1e1b16c4@posting.google.com>
References: <95cd51c.0202281826.26770596@posting.google.com> <a5oei1$qto$1@lust.ihug.co.nz>
NNTP-Posting-Host: 161.142.78.83
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1015209981 24426 127.0.0.1 (4 Mar 2002 02:46:21 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 4 Mar 2002 02:46:21 GMT
Xref: easynews comp.databases.oracle.server:137333
X-Received-Date: Sun, 03 Mar 2002 19:44:27 MST (news.easynews.com)

Howard,

   For inactive, I find that clearing the logs is easier than drop and 
create a new log groups.

   For active, if it is already archived, I still think leaving a gap/hole is
not good. I normally try to issue a checkpoint and clear the log. If it is
impossible, I do an incomplete recovery. Am I on the right track?

   I am a little blurr with active(archived) and active(not yet archived)
cases!

  Allan W. Tham
  Oracle DBA
