Message-Id: <10711.124773@fatcity.com> From: "aaaa wwwwww" Date: Fri, 15 Dec 2000 22:40:39 -0800 Subject: RE: Control Files Question - PLEASE HELP Hi Lisa Can we recover if we have consistent datafiles only ? Rao -- On Fri, 08 Dec 2000 08:00:47 Koivu, Lisa wrote: >Hi Fred Fred 1, > >The controlfiles will know about these actions immediately. Convince >yourself by adding a tablespace or datafile, and issuing 'ALTER DATABASE >BACKUP CONTROLFILE TO TRACE' command. Check it out - your new objects >(datafile or tablespace) will be there. > >There are few occasions when you will need to recreate your control file. >Upping MAXDATAFILES, or any of the other parameters that are hard-coded at >database creation, or the unfortunate problem of losing ALL your control >files... I can't think of any other reasons why you would have to do this >off the top of my head. I've had both of these happen. Bear in mind a full >database backup is prudent when recreating the controlfile. > >HTH > >Lisa Rutland Koivu >Oracle Database Administrator >Qode.com >4850 North State Road 7 >Suite G104 >Fort Lauderdale, FL 33319 > >V: 954.484.3191, x174 >F: 954.484.2933 >C: 954.658.5849 >http://www.qode.com > >"The information contained herein does not express the opinion or position >of Qode.com and cannot be attributed to or made binding upon Qode.com." > > >-----Original Message----- >Sent: Friday, December 08, 2000 10:40 AM >To: Multiple recipients of list ORACLE-L > > >Hi List, > > I want to konw when I need to re-create my control files. If I add a >tablespace to my database or add a datafile to one of my existing >tablespaces do I need to re-create my controlfiles ... or are they >automatically updated to reflect the change to my database structure??? > >I know I need multiple copies of the control file on different spindles, >etc.,... but I want to make sure that they are up to date. (I just added a >new tablespace to my database). > >Thank you!!!! > -Fred Smith >____________________________________________________________________________ >_________ >Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Fred Smith > INET: fred_fred_1@hotmail.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). > Get FREE Email/Voicemail with 15MB at Lycos Communications at http://comm.lycos.com