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_at_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_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).

>



Get FREE Email/Voicemail with 15MB at Lycos Communications at http://comm.lycos.com