RE: Oracle Recovery from Cold backup.

From: Koivu, Lisa <lisa.koivu_at_efairfield.com>
Date: Fri, 21 Sep 2001 12:01:51 -0700
Message-ID: <F001.00395166.20010921115520@fatcity.com>

No. The control file has the current state of the database. It will consider the database up to date if all the scn's match.

You could fool the database into rolling forward with a more recent copy of the control file (say at the time of crash), but if you are recovering with an old version of the control file (at the time of the day-old backup) you can't make Oracle apply archive logs that are newer, and have newer SCN's, to the database. did I explain that clearly?

Ron, try it sometime. Recovering with a more recent control file is kinda slick :)

Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117

-----Original Message-----

From:   Smith, Ron L. [SMTP:rlsmith_at_kmg.com]
Sent:   Friday, September 21, 2001 3:35 PM
To:     Multiple recipients of list ORACLE-L

Subject: RE: Oracle Recovery from Cold backup.

I know, but the point is Oracle doesn't know anything about the archive logs, it just takes whatever you feed it until you cancel. Correct?

Ron

-----Original Message-----
Sent: Friday, September 21, 2001 1:12 PM To: Multiple recipients of list ORACLE-L

As long as you have all archived log files in log archive destination directory, which is defined in init.ora, you don't have to do anything but type 'auto' while doing recovery. Oracle will automatically apply all necessary archive log files and then you need to open database.

"Smith, Ron L." <rlsmith_at_kmg.com> wrote:

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

_____

Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information in Yahoo! <http://rd.yahoo.com/mail_us/tag/?http://dailynews.yahoo.com/fc/US/Emergency _Information/> News.

--

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