| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Control Files Question - PLEASE HELP
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C0612F.4B147344
Content-Type: text/plain;
charset="iso-8859-1"
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
"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-----
From: Fred Smith [mailto:fred_fred_1_at_hotmail.com]
Sent: Friday, December 08, 2000 10:40 AM
To: Multiple recipients of list ORACLE-L
Subject: Control Files Question - PLEASE HELP
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
-- 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-LReceived on Fri Dec 08 2000 - 09:55:23 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C0612F.4B147344 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: Control Files Question - PLEASE HELP</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Hi Fred Fred 1,</FONT> </P> <P><FONT SIZE=3D2>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.</FONT></P> <P><FONT SIZE=3D2>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.</FONT></P> <P><FONT SIZE=3D2>HTH</FONT> </P> <P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT> <BR><FONT SIZE=3D2>Oracle Database Administrator</FONT> <BR><FONT SIZE=3D2>Qode.com</FONT> <BR><FONT SIZE=3D2>4850 North State Road 7</FONT> <BR><FONT SIZE=3D2>Suite G104</FONT> <BR><FONT SIZE=3D2>Fort Lauderdale, FL 33319</FONT> </P> <P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT> <BR><FONT SIZE=3D2>F: 954.484.2933 </FONT> <BR><FONT SIZE=3D2>C: 954.658.5849</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A></FONT> </P> <P><FONT SIZE=3D2>"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."</FONT></P> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Fred Smith [<A = HREF=3D"mailto:fred_fred_1_at_hotmail.com">mailto:fred_fred_1_at_hotmail.com</= A>]</FONT> <BR><FONT SIZE=3D2>Sent: Friday, December 08, 2000 10:40 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Control Files Question - PLEASE HELP</FONT> </P> <BR> <P><FONT SIZE=3D2>Hi List,</FONT> </P> <P><FONT SIZE=3D2> I want to konw when I need to re-create = my control files. If I add a </FONT> <BR><FONT SIZE=3D2>tablespace to my database or add a datafile to one = of my existing </FONT> <BR><FONT SIZE=3D2>tablespaces do I need to re-create my controlfiles = ... or are they </FONT> <BR><FONT SIZE=3D2>automatically updated to reflect the change to my = database structure???</FONT> </P> <P><FONT SIZE=3D2>I know I need multiple copies of the control file on = different spindles, </FONT> <BR><FONT SIZE=3D2>etc.,... but I want to make sure that they are up to = date. (I just added a </FONT> <BR><FONT SIZE=3D2>new tablespace to my database).</FONT> </P> <P><FONT SIZE=3D2>Thank you!!!!</FONT> <BR><FONT SIZE=3D2> -Fred Smith</FONT> <BR><FONT = SIZE=3D2>_______________________________________________________________= ______________________</FONT> <BR><FONT SIZE=3D2>Get more from the Web. FREE MSN Explorer = download : <A HREF=3D"http://explorer.msn.com" = TARGET=3D"_blank">http://explorer.msn.com</A></FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Fred Smith</FONT> <BR><FONT SIZE=3D2> INET: fred_fred_1_at_hotmail.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
 |
 |