RE: Oracle Recovery from Cold backup.

From: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com>
Date: Fri, 21 Sep 2001 09:39:08 -0700
Message-ID: <F001.00394DA6.20010921095022@fatcity.com>

You have to tell it that you are using a backup control file. Otherwise it will think the database is up-to-date.

-----Original Message-----
Sent: Friday, September 21, 2001 10:21 AM To: Multiple recipients of list ORACLE-L

I have a "what if" question.
Say you had a complete cold backup, including control files from a few days ago.
You also had all the archive logs for the past few days. Today you lost your server and had to recover. You lay down all the database files, including the control files. Now you want to apply your archive logs. Oracle can't know about the archive logs because all the files you restored are old.
Do you just tell Oracle where the archive logs are and it keeps aplying them until
you say you are finished?

Just wondering.

Ron

--

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: Kimberly Smith
INET: kimberly.smith_at_gmd.fujitsu.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------