RE: Recovery without backup.

There is no file, just logs since the creation.

I know the create datafile syntax, but I think there is some hitch that is new to 8.1.7. Unless he was talking about create datafile. I am going to look into it more, didn't want to mess with it until I got some time with my test box.

"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863  

-----Original Message-----
Sent: Wednesday, August 08, 2001 4:17 PM To: Multiple recipients of list ORACLE-L

That sounds impossible. Where do you get the file from?

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Wed, 8 Aug 2001, Christopher Spence wrote:



> I don't know much about this feature, but someone mentioned in 8.1.7 

> you can recover a datafile even without a backup as long as you have a 

> control file that knew about it and the archive logs.

>

> Anyone give this a try?  I am going to attempt this weekend on my test 

> box.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  INET: cspence_at_FuelSpot.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).