maybe the problem was never in the file but in the controlfile in the backup?
standby assumes that the scn in the datafile header will be out of date and that you will be recovering up to or past the scn in the standby controlfile and that that is okay. --- "Miller, Jay" <[EMAIL PROTECTED]> wrote: > Another piece of information: > > On the basis of "it couldn't hurt to try" I recopied everything but > instead > of using the regular control file I used the standby control file. I > then > mounted it in standby mode, issued the recover standby database > command, > activated the standby, shutdown, and opened the database. It worked > fine. > > Why would it work with a standby controlfile and not with the regular > control file? I have my QC database working but I'm really puzzled. > > Jay Miller > > -----Original Message----- > Sent: Thursday, October 25, 2001 7:05 PM > To: Multiple recipients of list ORACLE-L > > > Okay, this is weird. > > I'm trying to rebuilding my QC database from a hot backup. As > always, I > copied all the hot backup files, all the archive logs from the period > of the > hot backup and the control files. > > After doing > recover database using backup controlfile; > > I got > SVRMGR> alter database open resetlogs; > alter database open resetlogs > * > ORA-01113: file 1 needs media recovery > ORA-01110: data file 1: '/data1/nyccp/systnyccp.dbf > > Thinking that perhaps I just needed to apply more logs I went on to > apply > another 12 hours worth of archive logs. I still get the same error. > > > Now I'm really concerned that my hot backup is invalid for some > reason. > Does anyone have any suggestions for what else I can look at? > > TIA, > Jay Miller > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).