| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Please help! Recover a database on another server
it depends on how you created the control file that was on the backup.
If you just copied the control file from disk, that would explain your problem.
If you did a "alter system backup controlfile to <file>" and then backed that one up and moved it to the other server and then did a
recover database until <something> using backup controlfile
then what you did should have worked.
Rachel
--- "Smith, Ron L." <rlsmith_at_kmg.com> wrote:
> 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: 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).Received on Wed Oct 24 2001 - 15:10:06 CDT
 |
 |