sometimes the error message is a little strange...
when it comes back 'media recovery complete' you can usually just do a 'alter database open;' command and not worry about resetting the logs. If you backed up the controlfiles, then you should run the script that was given to correctly bring the database back up. the trace file usually needs to be modified a little... but it's pretty simple if you look at it.
http://tahiti.oracle.com/ and find the 'backup and recovery guide'
-----Original Message-----
From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 9:40 AM
To: Multiple recipients of list ORACLE-L
Subject: Please help! Recover a database on another server
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).
