RE: How to change the value of MAXDATAFILES of a running instance

From: Aldo Sigura <asigura_at_cmsenergy.com>
Date: Wed, 31 May 2000 10:58:22 -0300
Message-Id: <10514.107292@fatcity.com>

--0__=SI2UvLx8NJYODBhJYfy8d0LKnZKo3T5FbihZvFLvyhboJhO7m3Us6e7w Content-type: text/plain; charset=us-ascii Content-Disposition: inline

The value of MAXDATAFILES is stored in the control files. When you make ALTER DATABASE BACKUP CONTROLFILE the commands are in the trace file to recreate the control files. In this moment the proccess take from the init.ora the parameter MAXDATAFILE, because you should previously change this parameter in the init.ora.

Aldo Sigura
DBA - Empresa Distribuidora de Electricidad de Entre Rios S.A. Parana - Entre Rios - Argentina

ALEMU Abiy <abiy.alemu_at_criltechnology.com> on 31/05/2000 09:17:33

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Aldo Sigura/EDEER/CMS)
Subject: RE: How to change the value of MAXDATAFILES of a running instance

What do you mean by recreating the control files ?

-----Message d'origine-----
De: Steve Boyd [mailto:pimaco_oracle_at_hotmail.com] Date: mardi 30 mai 2000 19:07

--0__=SI2UvLx8NJYODBhJYfy8d0LKnZKo3T5FbihZvFLvyhboJhO7m3Us6e7w

Content-type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-transfer-encoding: quoted-printable

=C0: Multiple recipients of list ORACLE-L Objet: Re: How to change the value of MAXDATAFILES of a running instanc= e
?

I'm surprised that nobody else has answered this one yet, so I'll go ah= ead
and post.

You need to recreate the controlfile. Do the good old ALTER DATABASE B= ACKUP CONTROLFILE TO TRACE; Up the parameter in the script this generates, and recreate the control= file.

Of course, you will need to take down your database to do this.

>From: ALEMU Abiy <abiy.alemu_at_criltechnology.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: How to change the value of MAXDATAFILES of a running instance=
?
>Date: Tue, 30 May 2000 07:56:04 -0800
>
>Is there somebody who knows how to change the MAXDATAFILES parameter v=
alue
>of a running database ? If so, I'm really very grateful to anyone who=
can
>explain me.
>
>Thank you friends !!!
>--
>Author: ALEMU Abiy
> INET: abiy.alemu_at_criltechnology.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 Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.co= m

--
Author: Steve Boyd
  INET: pimaco_oracle_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).
--
Author: ALEMU Abiy
  INET: abiy.alemu_at_criltechnology.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).

Received on Wed May 31 2000 - 08:58:22 CDT