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

From: David Fitzjarrell <>
Date: Thu, 10 Oct 2013 14:01:56 -0700 (PDT)
Message-ID: <>

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 <> 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

-- Received on Thu Oct 10 2013 - 23:01:56 CEST

Original text of this message