why does he need a backup control file? this appears to be a straightforward case of moving databases(i mean restoring to a new host). does not look like they have done structural changes or things like that.
ron do you use rman? if not then someone earlier suggested taking the datafiles off of the backup mode using the end backup command. see if that works for you. Deepak --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > the key is when did you create the backup > controlfile? > > Try using a backup controlfile as opposed to a copy > of the controlfile. > > yes, there is a difference. > > > --- "Smith, Ron L." <[EMAIL PROTECTED]> wrote: > > We are trying to recover a database to another > server. > > > > The backup was a hot backup. The files are all > copied to the new > > server, > > along with the archive log that was created a few > seconds after the > > hot > > backup was run. We bring the database up and > apply the archive log > > and > > Oracle says recovery complete. We then do an > alter database open > > resetlogs. > > At this point Oracle says the System file needs > more recovery. > > Oracle said the recovery was complete! Why is it > saying the system > > file > > needs more recovery? > > > > Any ideas? > > > > Thanks! > > > > Ron Smith > > Database Administrator > > [EMAIL PROTECTED] > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Smith, Ron L. > > 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). __________________________________________________ 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: Deepak Thapliyal 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).
