Re: RMAN Archivelog question

From: <>
Date: Tue, 09 Sep 2008 17:35:11 +0200
Message-ID: <>

On Tue, 9 Sep 2008 06:50:09 -0700 (PDT), wrote:

>On Sep 8, 4:47 pm, wrote:
>> On Mon, 8 Sep 2008 11:01:47 -0700 (PDT), 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
>Sometimes the documentation is not really clear. For 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. Why would I need a crosscheck for archive logs? They 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........

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 tape 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
Received on Tue Sep 09 2008 - 10:35:11 CDT

Original text of this message