Re: lost control files

Wrong...I _think_ :)

If he rebuilds them using the correct file placements then it will work. The only problem is that he will have to open RESETLOGS and incomplete recovery will be impossible. But if he has all of his datafiles and is only missing control files then he can startup nomount and create controlfile from there.

Jeff Herrick
non-OCP DBA

On Thu, 9 Jan 2003, David L Phillips wrote:

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeff Herrick
  INET: jherrick_at_igs.net

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