DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth;
        b=SVrIPyjfta/gzGCAfsWnuXX6GzBdRtVv9HvZAAClBAoFecVfVOOzRkQJoe3IrNfjoc2EdX10z8gZdiv7/qkp0Dsr8h5ywCqIIoLF0FgJNVP1LTaW7XmNZS8jenAdaqnXKs+c8AiRt1Ou232mdE2VM5wBmCOhtORAEwwFVjnqHzI=
Message-ID: <c2213f680709071945m195230a3kedaf2cdd9cda5b3e@mail.gmail.com>
Date: Fri, 7 Sep 2007 22:45:00 -0400
From: "Alex Gorbachev" <ag@oracloid.com>
To: sacrophyte@gmail.com
Subject: Re: Need a lesson in RMAN for RAC
Cc: "Jared Still" <jkstill@gmail.com>, oracle-l <oracle-l@freelists.org>
In-Reply-To: <7b8774110709071421kb60ae81w9f624b45f5b00ea8@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Disposition: inline
References: <7b8774110709071142k4863ed2dk49bd56a79a897be2@mail.gmail.com>
	 <bf46380709071302t9f6c5fq7686e1b61911ec82@mail.gmail.com>
	 <7b8774110709071421kb60ae81w9f624b45f5b00ea8@mail.gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: ag@oracloid.com

At the moment of failure, I would check what is the SCN of each
datafile. Check controlfile SCN, current incarnation and etc. I
remember that quite a few confusing situation like that were explained
after some research and matching it all to what was originally
restored.

You didn't mention your controlfile restore - would there be any problem?

Have you compared which backup pieces were used in failing and
succeeded restores? And what controlfiles were used.


On 9/7/07, Charles Schultz <sacrophyte@gmail.com> wrote:
> To answer your question (and Randy's query), the restore was from a valid
> incremental database backup. The perplexing part is that recovering to an
> hour before my target time has no such problems. Randy, you made a point
> about open transactions. I had the same thought, but how would an open
> transaction get "stuck" in an archived log that is over one month old?
> Something tells me that the stated archived log is a complete red herring,
> since I can recover to 4:51, but not 5:51. I am trying to find out why that
> error message popped up at all.

-- 
Alex Gorbachev, Oracle DBA Brewer, The Pythian Group
http://www.pythian.com/blogs/author/alex http://www.oracloid.com
BAAG party - www.BattleAgainstAnyGuess.com
--
http://www.freelists.org/webpage/oracle-l