From Surendra.Tirumala@am.sony.com Wed, 08 Aug 2001 13:09:50 -0700 From: "Tirumala, Surendra" Date: Wed, 08 Aug 2001 13:09:50 -0700 Subject: RE: Recovery without backup. Message-ID: MIME-Version: 1.0 Content-Type: text/plain Yes indeed. It was there in 7.3.I don't know about earlier versions. Refer to Case 12 (page no 361 of 7.3 edition) of Backup and Recovery Handbook by B&R God, Rama Velpuri. Suren -----Original Message----- Sent: Wednesday, August 08, 2001 4:33 PM To: Multiple recipients of list ORACLE-L It existed before 8i. There is an example in Backup and Recovery book. alter database create datafile ... and then recover. Alex Hillman -----Original Message----- Sent: Wednesday, August 08, 2001 3:22 PM To: Multiple recipients of list ORACLE-L 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. "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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: Surendra.Tirumala@am.sony.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).