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

From: Don Seiler <don_at_seiler.us>
Date: Thu, 10 Oct 2013 16:05:03 -0500
Message-ID: <CAHJZqBBD+pACeAVm9RFxNfApxa8eGg2QfjitwJudTyHivxg08g_at_mail.gmail.com>

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


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

Received on Thu Oct 10 2013 - 23:05:03 CEST