Oracle-L: Re: lost control files

From: BigP <big_planet_2000_at_hotmail.com>
Date: Thu, 09 Jan 2003 11:29:45 -0800
Message-ID: <F001.0052B8FF.20030109112945@fatcity.com>

But if u look at the control file dump script . It doesn't say anything about creation date or scn or anything . All it has is list of datafiles , logfiles .. etc. If my other db on another server is layed out exactly same . wny can't I use that control file , just change db name .

-Bp

Original Message ----- From: David L Phillips To: Multiple recipients of list ORACLE-L Sent: Thursday, January 09, 2003 11:08 AM Subject: Re: lost control files

No. It would be like getting amnesia and just using the memories of someone that looks like you. The data stored in the control files is unique to that database. It contains location of files, database name, recovery info etc.

  David L Phillips
  Database Consultant (8i OCP)
  Digital Concepts Inc.

Original Message ----- From: BigP To: Multiple recipients of list ORACLE-L Sent: Thursday, January 09, 2003 1:18 PM Subject: lost control files

If I loose all my control files can I restore them by using create control file dump from a similer database .

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: BigP
INET: big_planet_2000_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

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 Thu Jan 09 2003 - 13:29:45 CST