Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 27961 invoked from network); 9 Sep 2007 22:40:05 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 9 Sep 2007 22:40:05 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 79AEC73BCC1; Sun, 9 Sep 2007 23:01:24 -0400 (EDT) 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 15226-08; Sun, 9 Sep 2007 23:01:24 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DCACB73BC77; Sun, 9 Sep 2007 23:01:23 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 09 Sep 2007 22:16:53 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5CA8173C3A1 for ; Sun, 9 Sep 2007 22:16:53 -0400 (EDT) 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 10763-07 for ; Sun, 9 Sep 2007 22:16:53 -0400 (EDT) Received: from smtp43.singnet.com.sg (smtp43.singnet.com.sg [165.21.103.151]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B93F973C39D for ; Sun, 9 Sep 2007 22:16:52 -0400 (EDT) Received: from chitale.singnet.com.sg (bb220-255-241-94.singnet.com.sg [220.255.241.94]) by smtp43.singnet.com.sg (8.14.1/8.14.1) with ESMTP id l8A2tVpg018349; Mon, 10 Sep 2007 10:55:31 +0800 Message-Id: <200709100255.l8A2tVpg018349@smtp43.singnet.com.sg> Date: Mon, 10 Sep 2007 10:55:31 +0800 To: sacrophyte@gmail.com, oracle-l From: Hemant K Chitale Subject: Re: Need a lesson in RMAN for RAC In-Reply-To: <7b8774110709071142k4863ed2dk49bd56a79a897be2@mail.gmail.co m> References: <7b8774110709071142k4863ed2dk49bd56a79a897be2@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-archive-position: 1369 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: hkchital@singnet.com.sg Precedence: normal Reply-to: hkchital@singnet.com.sg 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 X-Virus-Scanned: Debian amavisd-new at localhost.localdomain 1. Could there have been an ALTER TABLESPACE BEGIN BACKUP command in the past ?, the file never having been taken out of backup mode ? 2. Check the alert log to confirm that it doesn't see any "fuzzy" datafiles when doing the recovery. 3. What are the timestamps and SCNs of the Archivelogs between 2_2 and 2_33 ? 4. I haven't used ASM and OMF but what is the "629052819" in "system.314.629052819". Is that an incarnation id ? different from "629052887" ? meaning that the system file has been restored from an older, pre-reset log image ? Hemant At 02:42 AM Saturday, Charles Schultz wrote: >While trying to restore a RAC database, I had a perplexing problem. >OSEE 10.2.0.3 all around >rman> run { >set until time "to_date('29-AUG-2007 17:51:55','DD-MON-YYYY HH24:MI:SS')"; >restore database; >recover database; >} > >... >starting media recovery > >archive log thread 1 sequence 38 is already on disk as file >+DATA/lumqa/1_38_629052887.dbf >archive log thread 1 sequence 39 is already on disk as file >+DATA/lumqa/1_39_629052887.dbf >archive log thread 2 sequence 33 is already on disk as file >+DATA/lumqa/2_33_629052887.dbf >archive log filename=+DATA/lumqa/1_38_629052887.dbf thread=1 sequence=38 >archive log filename=+DATA/lumqa/2_2_629052887.dbf thread=2 sequence=2 >ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get >error below >ORA-01152: file 1 was not restored from a sufficiently old backup >ORA-01110: data file 1: '+DATA/lumqa/datafile/system.314.629052819' > Hemant K Chitale http://hemantoracledba.blogspot.com "First they ignore you, then they laugh at you, then they fight you, then you win" !" Mohandas Gandhi Quotes : http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html -- http://www.freelists.org/webpage/oracle-l