RE: Control Files Question

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Fri, 08 Dec 2000 13:44:51 -0500
Message-Id: <10704.124094@fatcity.com>

You should "backup controlfile to trace" after each database layout change = to have an ascii file to recreate the control file if need be.

ROR m=AA=BF=AAm

>>> Satar.Naghshineh_at_irvine.mellesgriot.com 12/08/00 11:22AM >>> no need to re-create your control file. It is automatically done for you.

You need to put multiple copies of your control file on different drives = not
for performance, but for redundancy.

Regards,
Satar

> -----Original Message-----
> From: Fred Smith [SMTP:fred_fred_1_at_hotmail.com]=20
> Sent: Friday, December 08, 2000 3:40 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Control Files Question - PLEASE HELP

>=20

> Hi List,

>=20
> I want to konw when I need to re-create my control files. If I add =
a=20
> tablespace to my database or add a datafile to one of my existing=20
> tablespaces do I need to re-create my controlfiles ... or are they=20
> automatically updated to reflect the change to my database structure???
>=20
> I know I need multiple copies of the control file on different =
spindles,=20
> etc.,... but I want to make sure that they are up to date. (I just =
added
> a=20
> new tablespace to my database).

>=20

> Thank you!!!!
> -Fred Smith
> _________________________________________________________________________=
_
> ___________
> Get more from the Web. FREE MSN Explorer download :
> http://explorer.msn.com=20

>=20

> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
> --=20
> Author: Fred Smith
> INET: fred_fred_1_at_hotmail.com=20

>=20


> 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).
Received on Fri Dec 08 2000 - 12:44:51 CST

RE: Control Files Question - PLEASE HELP