Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Please help! Recover a database on another server

RE: Please help! Recover a database on another server

From: <Mohammed.Ahsanuddin_at_VerizonWireless.com>
Date: Wed, 24 Oct 2001 09:05:59 -0700
Message-ID: <F001.003B3494.20011024091125@fatcity.com>

Ron,

Make sure you have atleast applied the archive logs between

Archive old log sequence number before start of hot backup and Archive current log sequence number after end of hot backup.

It may not need all of them but you need the last one for incomplete recovery..

Mohammed Ahsanuddin
Oracle DBA

-----Original Message-----
Sent: Wednesday, October 24, 2001 12:40 PM To: Multiple recipients of list ORACLE-L

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Mohammed.Ahsanuddin_at_VerizonWireless.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 - 11:05:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US