Re: Recovery problems when creating a new DB from backup copy

From: Don Seiler <don_at_seiler.us>
Date: Thu, 10 Oct 2013 16:36:27 -0500
Message-ID: <CAHJZqBCgBg2geArgej8G=T2rR2xyu-FO1r_yBx-jqtzgEdSOEw_at_mail.gmail.com>

Yeah this was it. I had been running "recover database using backup controlfile" which would eventually end withan ORA-00308 when it ran out of logs, and afterwards the "alter database open resetlogs" would fail. It did it again and so I just ran "recover database using backup controlfile until cancel', then typed CANCEL at the first prompt and now the open resetlogs is working.
I'm guessing if I ran the "recover database using backup controlfile until cancel" from the start it would issue a clean cancel when it ran out of logs and not give me this confusing problem.

I feel like there should be a DBA reaction gif for this somewhat annoying technicality.

On Thu, Oct 10, 2013 at 4:05 PM, Don Seiler <don_at_seiler.us> wrote:

> Yep that's what I was just reading a few minutes after sending that mail.
> I'm going to let this set of logs finish recovering and test that out.
>
> Thanks,
> Don.
>
>
> On Thu, Oct 10, 2013 at 4:01 PM, David Fitzjarrell <oratune_at_yahoo.com>wrote:
>
>> 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_at_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
>>
>>
>>
>>
>>
>
>
> --
> Don Seiler
> http://www.seiler.us
>

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


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

Received on Thu Oct 10 2013 - 23:36:27 CEST