Re: How get everything back in sync after manual removal of archivelogs

From: Wayne Smith <>
Date: Thu, 9 Jun 2011 13:54:39 -0400
Message-ID: <>

Your validation will fail if the logs you removed are required.

For example, let's say you removed all logs created before yesterday, then yesterday did a level 0 backup.

  • "RESTORE DATABASE VALIDATE;" would work fine.
  • "CHANGE ARCHIVELOG ALL CROSSCHECK;" would show all the missing logs.
  • "RESTORE ARCHIVELOG FROM TIME 'SYSDATE-7' VALIDATE;" would complain about the missing logs.

The problem is that though crosscheck has been run, the control file or catalog still contains references to the now missing logs. Solution:

  • "DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;" This will show actual deletion of the entries for the logs.

Cheers, Wayne

Google before you ask. (R. Theriault)

On Mon, Jun 6, 2011 at 6:07 PM, P D <> wrote:

> I manually removed some archivelogs and then did a crosscheck.
> However, when the backup and reports run those logs that were manually
> removed are still showing up as 'validation failed for archived log X'.
> What is the proper syntax for the crosscheck command to get everything back
> in sync again or is it a different command besides crosscheck that I should
> be using?

Received on Thu Jun 09 2011 - 12:54:39 CDT

Original text of this message