DomainKey-Signature:a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type;
  b=P3tcnr6uqaEUYXhyAbqmhrlmRCOcESqbWaHCQdAmTTchG5ggButAHW0z11uB7+AfmHfq1oSIfAIIhUB7xf+rgNaNuEwX8jGHmrTLtqNDiWyvCwdkbBT8DTuKdGD6qpp/Tp0FhVe9bLBAEzwoqYyWDXHrPYza74tcYyUkQJ1moxc=;
References: <CAHJZqBBr3QFv_S-sUivZdXpy5OKSW+QmTvcmNGNrq30j-vyngQ@mail.gmail.com>
Message-ID: <1381438916.74117.YahooMailNeo@web121601.mail.ne1.yahoo.com>
Date: Thu, 10 Oct 2013 14:01:56 -0700 (PDT)
From: David Fitzjarrell <oratune@yahoo.com>
Subject: Re: Recovery problems when creating a new DB from backup copy
To: "don@seiler.us" <don@seiler.us>, ORACLE-L <oracle-l@freelists.org>
In-Reply-To: <CAHJZqBBr3QFv_S-sUivZdXpy5OKSW+QmTvcmNGNrq30j-vyngQ@mail.gmail.com>
MIME-Version: 1.0
Content-type: text/plain
Content-Transfer-Encoding: 8bit
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: oratune@yahoo.com

I had that same problem when I did not specify 'UNTIL CANCEL' in the recover command.  Once I did that, and then did a recover database cancel, the database opened without error.
 
It's a possibility.
David Fitzjarrell


On Thursday, October 10, 2013 2:41 PM, Don Seiler <don@seiler.us> wrote:
  
We took a backup-as-copy of our standby DB, and copied the archived logs
that spanned that time and beyond (the next day). Created a new controlfile
to point to those copy files and recovered the logs that we registered, but
when I went to open the DB, I got:
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/mnt/foo/data/FOO/datafile/foo_system.dbf'

Basically file 1, the system datafile.

v$datafile shows no FUZZY headers. Am I mis-interpreting this error?

I decided to copy 15 more archivelogs from the standby to feed it but I
didn't expect it to have this problem and so not sure why it would make a
difference. I'll follow up with those results.

Any other thoughts?

-- 
Don Seiler
http://www.seiler.us/


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