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@xxxxxxxxx> 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@xxxxxxxxx>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@xxxxxxxxx> >> 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/ >> >> >> -- >> //www.freelists.org/webpage/oracle-l >> >> >> >> >> > > > -- > Don Seiler > http://www.seiler.us > -- Don Seiler http://www.seiler.us -- //www.freelists.org/webpage/oracle-l