Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Control Files Question - PLEASE HELP

RE: Control Files Question - PLEASE HELP

From: aaaa wwwwww <>
Date: Fri, 15 Dec 2000 22:40:39 -0800
Message-Id: <>

Hi Lisa

Can we recover if we have consistent datafiles only ?



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.
>Lisa Rutland Koivu
>Oracle Database Administrator
>4850 North State Road 7
>Suite G104
>Fort Lauderdale, FL 33319
>V: 954.484.3191, x174
>F: 954.484.2933
>C: 954.658.5849
>"The information contained herein does not express the opinion or position
>of and cannot be attributed to or made binding upon"
>-----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 :
>Please see the official ORACLE-L FAQ:
>Author: Fred Smith
>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: (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
Received on Sat Dec 16 2000 - 00:40:39 CST

Original text of this message