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 <wisernet100_at_yahoo.com> 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." <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).
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: deepakthapliyal_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).
Received on Wed Oct 24 2001 - 13:26:30 CDT
