Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 25377 invoked from network); 8 Sep 2007 03:13:37 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 8 Sep 2007 03:13:36 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8BCD873BE7E; Sat, 8 Sep 2007 03:34:54 -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 15328-05; Sat, 8 Sep 2007 03:34:54 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0AFFF73BD83; Sat, 8 Sep 2007 03:34:54 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 08 Sep 2007 02:50:23 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 893B473B9C7 for ; Sat, 8 Sep 2007 02:50:23 -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 10817-10 for ; Sat, 8 Sep 2007 02:50:23 -0400 (EDT) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.179]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E9C0573B9B8 for ; Sat, 8 Sep 2007 02:50:22 -0400 (EDT) Received: by wa-out-1112.google.com with SMTP id k22so892720waf for ; Sat, 08 Sep 2007 00:29:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=Axwldb9Zta0qOrsC+kdu6N//K72llq0OXXHkUZkfLdA=; b=Q5kUf/NycXyi+FoWT/o7/ef1cNo/a/43+PlrJMBLb8bHds4c8gHCmVWLrcPzoRPXt1KhqOKtm3quYTaon6tO6FTueJyUEgKOWag3MMiVHWpdqNpPizjJDABrZQlXBE9WhRVND14cJ+dK4/ziLmK/CctIk0EZlvr/6xgiNMhgUoI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=uH07TnyStHfGhmmUIDRTZC7r0x7XGu4PtwNrwOwDLCArIb71HPzkyJESRZZfCJSq8/jVDER/dKPZ/EmpwGGi/Pp5a8aqB2SHfMCLoAkLIophJHbDiTX7H8HAyZ9NOE7q4OvkW/NkvtYcEohsC5kgOGNBX9EN1eppVxhAMWhrMYc= Received: by 10.114.137.2 with SMTP id k2mr2005374wad.1189236542805; Sat, 08 Sep 2007 00:29:02 -0700 (PDT) Received: by 10.114.144.12 with HTTP; Sat, 8 Sep 2007 00:29:02 -0700 (PDT) Message-ID: <6e9345580709080029q779f2e8ek5729abe7ad41e858@mail.gmail.com> Date: Sat, 8 Sep 2007 09:29:02 +0200 From: "LS Cheng" To: sacrophyte@gmail.com Subject: Re: Need a lesson in RMAN for RAC Cc: oracle-l In-Reply-To: <7b8774110709071142k4863ed2dk49bd56a79a897be2@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3887_31238418.1189236542793" References: <7b8774110709071142k4863ed2dk49bd56a79a897be2@mail.gmail.com> X-archive-position: 1354 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: exriscer@gmail.com Precedence: normal Reply-to: exriscer@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 X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_Part_3887_31238418.1189236542793 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Do you have another Incarnation on 29th of 30th of Augost? You log sequence is reset. If so run LIST INCARNATION OF DATABASE and see if you are using the current otherwise try use reset database to incarnation to current incarnation... Thanks -- LSC On 9/7/07, 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' > > RMAN-00571: =========================================================== > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== > RMAN-00571: =========================================================== > RMAN-03002: failure of recover command at 09/07/2007 13:21:23 > RMAN-11003: failure during parse/execution of SQL statement: alter > database recover logfile '+DATA/lumqa/2_2_629052887.dbf' > ORA-00328: archived log ends at change 679438, need later change 3331515 > ORA-00334: archived log: '+DATA/lumqa/2_2_629052887.dbf' > > The confusing part is that this log is really old, and I have no idea how > it is relevant or needed for this recovery: > 1 select NAME,FIRST_CHANGE#,to_char(FIRST_TIME,'DD-MON-YYYY > HH24:MI:SS'), > 2 NEXT_CHANGE#,to_char(NEXT_TIME,'DD-MON-YYYY HH24:MI:SS') > 3 from v$archived_log > 4* where name like '%2_2_629052887%' > LUMQA1_SQL > / > > NAME FIRST_CHANGE# > TO_CHAR(FIRST_TIME,' NEXT_CHANGE# TO_CHAR(NEXT_TIME,'D > ---------------------------------------- ------------- > -------------------- ------------ -------------------- > +DATA/lumqa/2_2_629052887.dbf 589921 27-JUL-2007 > 17:38:36 679439 28-JUL-2007 16:59:26 > > Here are the other logs: > LUMQA1_SQL > select * from > 2 (select NAME,FIRST_CHANGE#,to_char(FIRST_TIME,'DD-MON-YYYY > HH24:MI:SS'), > 3 NEXT_CHANGE#,to_char(NEXT_TIME,'DD-MON-YYYY > HH24:MI:SS') > 4 from v$archived_log > 5 where next_time is not null > 6 and first_time < '01-SEP-2007' > 7 order by NEXT_TIME desc) > 8* where rownum < 11 > LUMQA1_SQL > / > > NAME FIRST_CHANGE# > TO_CHAR(FIRST_TIME,' NEXT_CHANGE# TO_CHAR(NEXT_TIME,'D > ---------------------------------------- ------------- > -------------------- ------------ -------------------- > +DATA/lumqa/2_3_631971295.dbf 2997861 31-AUG-2007 > 22:00:10 3097750 02-SEP-2007 02:01:44 > +DATA/lumqa/1_4_631971295.dbf 3004658 31-AUG-2007 > 22:11:27 3051322 01-SEP-2007 09:00:40 > +DATA/lumqa/1_3_631971295.dbf 2876764 30-AUG-2007 > 12:09:54 3004658 31-AUG-2007 22:11:27 > +DATA/lumqa/2_2_631971295.dbf 2877457 30-AUG-2007 > 12:09:56 2997861 31-AUG-2007 22:00:10 > +DATA/lumqa/2_34_629052887.dbf 3331608 29-AUG-2007 > 17:51:55 3331784 29-AUG-2007 17:53:38 > +DATA/lumqa/1_39_629052887.dbf 3331605 29-AUG-2007 > 17:51:53 3331781 29-AUG-2007 17:53:37 > +DATA/lumqa/2_33_629052887.dbf 3245386 28-AUG-2007 > 18:07:51 3331608 29-AUG-2007 17:51:55 > +DATA/lumqa/1_38_629052887.dbf 3258246 28-AUG-2007 > 21:08:10 3331605 29-AUG-2007 17:51:53 > +DATA/lumqa/1_37_629052887.dbf 3168436 27-AUG-2007 > 22:00:35 3258246 28-AUG-2007 21:08:10 > +DATA/lumqa/2_32_629052887.dbf 3146903 27-AUG-2007 > 17:55:54 3245386 28-AUG-2007 18:07:51 > > -- > Charles Schultz ------=_Part_3887_31238418.1189236542793 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Do you have another Incarnation on 29th of 30th of Augost? You log sequence is reset.

If so run LIST INCARNATION OF DATABASE and see if you are using the current otherwise try use reset database to incarnation to current incarnation...

Thanks

--
LSC






On 9/7/07, Charles Schultz <sacrophyte@gmail.com> 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'

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/07/2007 13:21:23
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '+DATA/lumqa/2_2_629052887.dbf'
ORA-00328: archived log ends at change 679438, need later change 3331515
ORA-00334: archived log: '+DATA/lumqa/2_2_629052887.dbf'

The confusing part is that this log is really old, and I have no idea how it is relevant or needed for this recovery:
  1  select NAME,FIRST_CHANGE#,to_char(FIRST_TIME,'DD-MON-YYYY HH24:MI:SS'),
  2   NEXT_CHANGE#,to_char(NEXT_TIME,'DD-MON-YYYY HH24:MI:SS')
  3  from v$archived_log
  4* where name like '%2_2_629052887%'
LUMQA1_SQL > /

NAME                                     FIRST_CHANGE# TO_CHAR(FIRST_TIME,' NEXT_CHANGE# TO_CHAR(NEXT_TIME,'D
---------------------------------------- ------------- -------------------- ------------ --------------------
+DATA/lumqa/2_2_629052887.dbf                   589921 27-JUL-2007 17:38:36       679439 28-JUL-2007 16:59:26

Here are the other logs:
LUMQA1_SQL >  select * from
  2   (select NAME,FIRST_CHANGE#,to_char(FIRST_TIME,'DD-MON-YYYY HH24:MI:SS'),
  3                NEXT_CHANGE#,to_char(NEXT_TIME,'DD-MON-YYYY HH24:MI:SS')
  4     from v$archived_log
  5     where next_time is not null
  6     and first_time < '01-SEP-2007'
  7     order by NEXT_TIME desc)
  8*  where rownum < 11
LUMQA1_SQL > /

NAME                                     FIRST_CHANGE# TO_CHAR(FIRST_TIME,' NEXT_CHANGE# TO_CHAR(NEXT_TIME,'D
---------------------------------------- ------------- -------------------- ------------ --------------------
+DATA/lumqa/2_3_631971295.dbf                  2997861 31-AUG-2007 22:00:10      3097750 02-SEP-2007 02:01:44
+DATA/lumqa/1_4_631971295.dbf                  3004658 31-AUG-2007 22:11:27      3051322 01-SEP-2007 09:00:40
+DATA/lumqa/1_3_631971295.dbf                  2876764 30-AUG-2007 12:09:54      3004658 31-AUG-2007 22:11:27
+DATA/lumqa/2_2_631971295.dbf                  2877457 30-AUG-2007 12:09:56      2997861 31-AUG-2007 22:00:10
+DATA/lumqa/2_34_629052887.dbf                 3331608 29-AUG-2007 17:51:55      3331784 29-AUG-2007 17:53:38
+DATA/lumqa/1_39_629052887.dbf                 3331605 29-AUG-2007 17:51:53      3331781 29-AUG-2007 17:53:37
+DATA/lumqa/2_33_629052887.dbf                 3245386 28-AUG-2007 18:07:51      3331608 29-AUG-2007 17:51:55
+DATA/lumqa/1_38_629052887.dbf                 3258246 28-AUG-2007 21:08:10      3331605 29-AUG-2007 17:51:53
+DATA/lumqa/1_37_629052887.dbf                 3168436 27-AUG-2007 22:00:35      3258246 28-AUG-2007 21:08:10
+DATA/lumqa/2_32_629052887.dbf                 3146903 27-AUG-2007 17:55:54      3245386 28-AUG-2007 18:07:51

--
Charles Schultz

------=_Part_3887_31238418.1189236542793-- -- http://www.freelists.org/webpage/oracle-l