RE: New Oracle Install and Old Data Files

Regina,

Yes there is - but you probably don't want to do it yourself if you're not a DBA ... do a backup control file to trace:

alter database <database> backup controlfile to trace;

shut down the database and modify the sql in the file you created so it contains the information for the tablespaces you need.

use the sql file to start up the database

hopefully everything starts ok. Can't guarantee what happens to integrity, etc. if you don't have all the tablespaces.

Randy Kirkpatrick

-----Original Message-----
Harter
Sent: Friday, October 26, 2001 5:10 PM
To: Multiple recipients of list ORACLE-L

Okay People,

I am not the DBA and don't have all the details but this is our situation the way it was explained to me:

We had a server crash to the point where Unix and Oracle had to be reinstalled, however the disks containing our data tablespaces (that is, everything but the system tablespaces) are still good, and apparently for several reasons, we have not had a good backup for at least a week. Is there anyway to get a new Oracle install to recognize old tablespaces?

TIA, Regina

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Regina Harter
  INET: rharter_at_emc-inc.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: Randy Kirkpatrick
  INET: randywk_at_usa.net

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