From cspence@FuelSpot.com Wed, 08 Aug 2001 12:58:02 -0700 From: Christopher Spence Date: Wed, 08 Aug 2001 12:58:02 -0700 Subject: RE: Recovery without backup. Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@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@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@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@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).