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
[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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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).

Reply via email to