From deepakthapliyal@yahoo.com Wed, 08 Aug 2001 14:48:53 -0700 From: deepak thapliyal Date: Wed, 08 Aug 2001 14:48:53 -0700 Subject: RE: Recovery without backup. Message-ID: MIME-Version: 1.0 Content-Type: text/plain this is for those scenerios where u have old control file backup which might not include entry of newer datafiles that u might have added (and later on lost due to media failure) .. so like said in the thread below .. u create a new entry in the control file by using the "create datafile .." statement and then recover the datafile using normal methods. For this to succeed, you must have archives to rollforward alll the information that the new file might have had before u lost it .. deepak --- Christopher Spence wrote: > I will need to find out what he was talking about, > perhaps he was refering > to this feature. It never dawned on me at the time. > When he mentioned what > he was talking about, he said it was 8.1.7 feature > that came out. I was > kind of confused about it at the time. > > > > "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: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 > > > > __________________________________________________ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: deepak thapliyal INET: deepakthapliyal@yahoo.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).