RE: Please help! Recover a database on another server

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Wed, 24 Oct 2001 09:49:06 -0700
Message-ID: <F001.003B3589.20011024095524@fatcity.com>

Ron,

> 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?

I have a feeling that either you placed all the tablespaces in hot backup mode simultaneously (maybe you created a mirror, broke it and backed up the mirror) or the backups took a long time to complete and thus the redo records that recorded the fact that the tablespaces were taken out of backup mode did not find their way into the archive logs applied so far. I deduce this from the fact that you applied the archive log that was created a few seconds after the hot backup was run, BUT not the ones that were generated sometime after the hot backup completed. Unfortunately, it is the latter that contains the redo for the SYSTEM tablespace changes that occur when the hot backup completes and thus you will need to apply that last archive log... You will need to determine the archive log that was generated after the hot backup completed and re-apply it. You can do this even if you aborted the recovery process, as long as you did not disturb any other file in the recovery environment.

Hope this explains!
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Listen to great commercial-free christian music 24x7 at www.klove.com

The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: john.kanagaraj_at_hds.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:49:06 CDT