Path: text.usenetserver.com!out03a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!l77g2000hsb.googlegroups.com!not-for-mail
From: "Keith" <kknauss@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: RMAN level 0 complains it can't find archivelogs
Date: 28 Mar 2007 07:23:16 -0700
Organization: http://groups.google.com
Lines: 19
Message-ID: <1175091796.555511.295680@l77g2000hsb.googlegroups.com>
References: <1174992234.586565.20580@n76g2000hsh.googlegroups.com>
   <1174994794.623178.316130@e65g2000hsc.googlegroups.com>
   <1174996562.334722.40660@p15g2000hsd.googlegroups.com>
   <46096C62.1080301@dial.pipex.com>
   <1175088286.008935.208260@d57g2000hsg.googlegroups.com>
NNTP-Posting-Host: 216.111.89.3
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1175091798 16544 127.0.0.1 (28 Mar 2007 14:23:18 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 28 Mar 2007 14:23:18 +0000 (UTC)
In-Reply-To: <1175088286.008935.208260@d57g2000hsg.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.10) Gecko/20070226 Fedora/1.5.0.10-1.fc6 Firefox/1.5.0.10 pango-text,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: l77g2000hsb.googlegroups.com; posting-host=216.111.89.3;
   posting-account=apWImQwAAACL8gAmMe0vURlatPFh_FSq
Xref: usenetserver.com comp.databases.oracle.server:424887
X-Received-Date: Wed, 28 Mar 2007 09:23:18 EST (text.usenetserver.com)

On Mar 28, 9:24 am, "Andy Kent" <andykent.bristol1...@virgin.net>
wrote:
> That seems to have been the solution I needed to go for. I'd assumed
> rather foolishly that one of the Crosscheck options in EM would tidy
> the logs up, but it seemed I needed to revert to the good old command
> line.
>
> Now .... will that hatchet job have had any implications for
> recoverability? We won't need to go back in time, just to recover
> quickly from a failure.
>
> Andy

If you configure autobackup for your controlfile in RMAN and you are
using an spfile, both we be automatically included in your backupset.
Also, I would recommend using RMAN to backup and delete your archive
logs so Oracle "knows" where they are.  Otherwise RMAN will only be
able to do so much for you and you limit its functionality.