Re: Please help! Recover a database on another server

I only know that I got that line from Oracle Support. You had to open your database in mount state before restoring the datafiles. The database uses the controlfile it has, not the backed up directory. Maybe this is why you have to state 'using backup controlfile'. All I know is, doing this works. Maybe I am too simplistic in my approach but if something ain't broke I don't try to fix it.

Sorry I can't be more helpful,
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, October 24, 2001 4:20 PM

> Aren't they the same? If I restore the control file from the backup.
There
> was no control file on the server
> before I did the restore.
>
> Ron
>
> -----Original Message-----
> Sent: Wednesday, October 24, 2001 3:06 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Are you sure, if you don't state 'using backup controlfile' it will use
the
> control file you usd to startup the database.
>
> Just a thot,
> Ruth
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, October 24, 2001 3:46 PM
>
>
> > The control file was backed up the same time the data files were backed
> up.
> > The control file from the backup
> > is what we are using.
> >
> > Ron
> >
> > -----Original Message-----
> > Sent: Wednesday, October 24, 2001 1:05 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > 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." <rlsmith_at_kmg.com> 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
> > > rlsmith_at_kmg.com
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Smith, Ron L.
> > > INET: rlsmith_at_kmg.com
> > >
> > > 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: ListGuru_at_fatcity.com (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: wisernet100_at_yahoo.com
> >
> > 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: ListGuru_at_fatcity.com (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: Smith, Ron L.
> > INET: rlsmith_at_kmg.com
> >
> > 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: ListGuru_at_fatcity.com (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: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
> 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: ListGuru_at_fatcity.com (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: Smith, Ron L.
> INET: rlsmith_at_kmg.com
>
> 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: ListGuru_at_fatcity.com (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: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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: ListGuru_at_fatcity.com (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).