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

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 <pdba1966_at_hotmail.com> 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?
>

--
http://www.freelists.org/webpage/oracle-l