Path: text.usenetserver.com!out01b.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!nx01.iad01.newshosting.com!newshosting.com!69.16.185.11.MISMATCH!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!f63g2000hsf.googlegroups.com!not-for-mail
From: artmerar@yahoo.com
Newsgroups: comp.databases.oracle.server
Subject: Re: RMAN Archivelog question
Date: Tue, 9 Sep 2008 10:27:21 -0700 (PDT)
Organization: http://groups.google.com
Lines: 53
Message-ID: <4881ecea-d807-4301-a769-680071e4a8c9@f63g2000hsf.googlegroups.com>
References: <6c5339dd-56aa-4f7d-9033-e78141fb2557@y38g2000hsy.googlegroups.com> 
 <q87bc4tk7lqrhapcpjildb919bpts08boq@4ax.com> <6709a9b7-4823-411c-872e-3b9a695f07df@79g2000hsk.googlegroups.com> 
 <ek5dc49u1a0p3o0fkih59bvve70mea0orm@4ax.com>
NNTP-Posting-Host: 208.65.116.5
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1220981241 23495 127.0.0.1 (9 Sep 2008 17:27:21 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 9 Sep 2008 17:27:21 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: f63g2000hsf.googlegroups.com; posting-host=208.65.116.5; 
 posting-account=Te8R5QoAAAD0OcZ51Bsj60HqyktlOVZb
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) 
 Gecko/2008070208 Firefox/3.0.1,gzip(gfe),gzip(gfe)
Xref: usenetserver.com comp.databases.oracle.server:447872
X-Received-Date: Tue, 09 Sep 2008 13:27:21 EDT (text.usenetserver.com)

On Sep 9, 10:35=A0am, sybra...@hccnet.nl wrote:
> On Tue, 9 Sep 2008 06:50:09 -0700 (PDT), artme...@yahoo.com wrote:
> >On Sep 8, 4:47=A0pm, sybra...@hccnet.nl wrote:
> >> On Mon, 8 Sep 2008 11:01:47 -0700 (PDT), artme...@yahoo.com wrote:
> >> >If you use the DELETE INPUT in your backup command (PLUS ARCHIVELOG),
> >> >would you even need to do a crosscheck?
>
> >> A crosscheck is necessary when someone decides to delete backups or
> >> archivelogs without using RMAN, ie directly from the OS.
>
> >> It is appreciated
> >> a) you answer doc questions yourself by reading the docs
> >> b) don't ask questions two times within a few minutes.
>
> >> --
> >> Sybrand Bakker
> >> Senior Oracle DBA
>
> >Sybrand,
>
> >Sometimes the documentation is not really clear. =A0For example, if I
> >use a recovery window, say 2 weeks, and my archive logs are included
> >in my level 0 backup and I use a DELETE INPUT to remove the archive
> >logs. =A0Why would I need a crosscheck for archive logs? =A0They are
> >included in the backup, and they have been removed once backed up.
> >Additionally, I'm assuming that I would not need a 'DELETE ARCHIVELOG'
> >statement either.
>
> >The docs are not very clear on this........
>
> >Regards.
>
> The very purpose of crosscheck is to repair inconsistencies between
> disk (or tape library) and catalog (whether in a controlfile or in a
> separate catalog database). Crosscheck marks entries in the catalog
> which no longer exist on disk or in the =A0tape library as deleted.
> Inconsistencies mainly arise from administrators not using RMAN to
> maintain their backups.
> If you solely use RMAN to maintain backups and archivelogs, you
> shouldn't need to run crosschecks.
> Apart from that running crosscheck prior to a backup implicitly only
> checks the consistency of prior backups. Which is why it is redundant.
>
> --
> Sybrand Bakker
> Senior Oracle DBA


Thank you Sybrand.  So, if I understand you correctly, all I really
need is the DELETE OBSOLETE command to get rid of the backups which
are not needed to fit the recovery window......

Regards.