Received: (qmail 18392 invoked from network); 6 Jun 2011 18:04:28 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 6 Jun 2011 18:04:07 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6447CE29408; Mon, 6 Jun 2011 19:04:05 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1307401445; bh=ZTMiwovSEbgu8LCyBvA1GflERt0fQaStkqBytDi1 PrM=; h=MIME-Version:In-Reply-To:References:Date:Message-ID:Subject: From:To:Cc:Content-Type:Sender:Reply-To:List-help:List-unsubscribe: List-Id:List-subscribe:List-owner:List-post:List-archive; b=sQuuSR Mn0LEceLMpYS3TT51g0v5b97UR9ZWOiaDCVcjXhXOnl6bFOlpCbEVO9AO6YWbgOhSak /h73uY1ByrHIvyz3xmHPvgwDbRgjyp7lzB9D/H8G+A7TEnhi1Gi4rkoV82UixBqZ7mS 0DBGbnnmq1JImo/NaVVUOaDzv2yOUog= X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id hVOGvWkbzTDT; Mon, 6 Jun 2011 19:04:05 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 57A04E29329; Mon, 6 Jun 2011 19:03:21 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 06 Jun 2011 19:02:39 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DEBECE29352 for ; Mon, 6 Jun 2011 19:02:38 -0400 (EDT) Authentication-Results: turing.freelists.org; dkim=pass (1024-bit key) header.i=@gmail.com Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id sAJCdkC11Es3 for ; Mon, 6 Jun 2011 19:02:38 -0400 (EDT) Received: from mail-bw0-f51.google.com (mail-bw0-f51.google.com [209.85.214.51]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A9A8FE292EA for ; Mon, 6 Jun 2011 19:02:35 -0400 (EDT) Received: by bwz10 with SMTP id 10so4261415bwz.10 for ; Mon, 06 Jun 2011 16:02:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type; bh=X+8su8lEEzH0z3yFDP6h+e13WgwLkfRVyLsr36pwUYo=; b=bTaRjc9YoTAz0vMN0yTaj9Yg1ZW6C1yCZgscBNvAZwhYvxkoGAfkH4PtuJTcGjHJHo tjoItEfyXkvLkMK7sfUsie35yhjk44F163556vhQvQJtWOQW0B2Q8XrpTq2fcma0a74b Drra+OQbNQuXqosjqDqhkvyxtJTUwmmbzW888= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=WANl+gDFGy71Ef3rVKdBjgEnNwOMpMDnwDoIgEvRaMCuDuOOVJYXp0KwNSdpa1Po93 4aNx2AWrjF7JgnCc4mAfaSKQQanEck50nbG7FR5aLDSdU6vVoRevlkjKNl//2qHQ2GqB LwrQOCU8eQ7sLIoltXBfdPZri/MdY/gNR9kmw= MIME-Version: 1.0 Received: by 10.204.20.134 with SMTP id f6mr3139972bkb.165.1307401349911; Mon, 06 Jun 2011 16:02:29 -0700 (PDT) Received: by 10.204.36.2 with HTTP; Mon, 6 Jun 2011 16:02:29 -0700 (PDT) Received: by 10.204.36.2 with HTTP; Mon, 6 Jun 2011 16:02:29 -0700 (PDT) In-Reply-To: References: Date: Tue, 7 Jun 2011 07:02:29 +0800 Message-ID: Subject: Re: How get everything back in sync after manual removal of archivelogs From: Hemant K Chitale To: pdba1966@hotmail.com Cc: oracle-l@freelists.org Content-Type: multipart/alternative; boundary=0003255599860a564204a5131991 X-archive-position: 36602 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: hemantkchitale@gmail.com Precedence: normal Reply-To: hemantkchitale@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --0003255599860a564204a5131991 Content-Type: text/plain; charset=ISO-8859-1 After the CROSSCHECK, you need to run DELETE [NOPROMPT] EXPIRED ARCHIVELOG ALL; Hemant K Chitale sent from my smartphone On 7 Jun 2011 06:08, "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? > > --0003255599860a564204a5131991 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

After the CROSSCHECK, you need to run DELETE [NOPROMPT] EXPIRED ARCHIVEL= OG ALL;

Hemant K Chitale

sent from my smartphone

On 7 Jun 2011 06:08, "P D" <pdba1966@hotmail.com> wrote:
>
> I manually removed some archivelogs and the= n 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 c= ommand to get everything back in sync again or is it a different command be= sides crosscheck that I should be using?
>
>
--0003255599860a564204a5131991-- -- http://www.freelists.org/webpage/oracle-l