Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle Recovery from Cold backup.

Re: Oracle Recovery from Cold backup.

From: Shantanu Talukder <shantanu_t_at_yahoo.com>
Date: Fri, 21 Sep 2001 10:01:41 -0700
Message-ID: <F001.00394E22.20010921101132@fatcity.com>


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 daysago.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 restoredare old.Do you just tell Oracle where the archive logs are and it keeps aplying themuntil 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@kmg.comFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing Lists------------------------------------------------!
!
--------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information in <a
href="http://rd.yahoo.com/mail_us/tag/?http://dailynews.yahoo.com/fc/US/Emergency_Information/">Yahoo! News. Received on Fri Sep 21 2001 - 12:01:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US