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

From: gentry <gentry_at_allina.com>
Date: Wed, 31 May 2000 10:20:15 -0500
Message-Id: <10514.107311@fatcity.com>

This is a multi-part message in MIME format. --------------B6CD0C51F7E80F257551F4A4
Content-Type: multipart/alternative;
boundary="------------7E3484AC48D8EE896DF6591D"

--------------7E3484AC48D8EE896DF6591D
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

X-MIME-Autoconverted: from 8bit to quoted-printable by ns1.allina.com id e4VFLFH29802

If you are doing this to expand the MAXDATAFILES parameter, keep in mind,= as
Gilles Parc pointed out in an eariler email, this is only necessary if yo= u are
not on release 8.0.x or later.

[See the following quote from page 10-3 of the Oracle 8i Administrators G= uide:]

> .Control file upper bound
> When you issue CREATE DATABASE or CREATE CONTROLFILE statements,
> the MAXDATAFILES parameter specifies an initial size of the datafile po=
rtion
> of the control file. Later, if you add a file whose number exceeds
> MAXDATAFILES but is less than or equal to the value specified by the DB=
_
> FILES initialization parameter, the control file automatically expands =
to allow
> the datafile portion to accommodate more files.
>

HTH,
Bill Gentry

James Bullard wrote:

> This means that your instance will need to be shutdown. Edit the trace=
file
> that is generated with the backup controlfile to trace and startup nomo=
unt
> and execute the create controlfile statement with the new maxdatafiles
> setting. You can run this like a SQL statement. If you have never don=
e
> this before and/or this is a production instance I would suggest taking=
a
> look at one of the manuals, or a backup and recovery guide. I also hig=
hly
> recommend trying this initially in a test environment so that you get a=
feel
> for it. It is not a difficult task, but also not something to be taken
> lightly either.
>
> Comments, corrections are always welcome.
>
> James
>
> -----Original Message-----
> Sent: Wednesday, May 31, 2000 5:18 AM
> To: Multiple recipients of list ORACLE-L
> 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
> =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)...
> --
> Author: James Bullard
> INET: jbullard_at_onvia.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).

--------------7E3484AC48D8EE896DF6591D
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html>
If you are doing this to expand the MAXDATAFILES parameter, keep in mind, as Gilles Parc pointed out in an eariler email, this is only necessary if you are not on release 8.0.x or later. [See the following quote from page 10-3 of the Oracle 8i Administrators Guide:]
<blockquote TYPE=CITE>
<pre>.Control file upper bound
When you issue CREATE DATABASE or CREATE CONTROLFILE statements, the MAXDATAFILES parameter specifies an initial size of the datafile portion of the control file. Later, if you add a file whose number exceeds MAXDATAFILES but is less than or equal to the value specified by the DB_ FILES initialization parameter, the control file automatically expands to allow the datafile portion to accommodate more files.</pre> </blockquote>
HTH,

<br>Bill Gentry
<br>-------------------------------
<p>James Bullard wrote:
<blockquote TYPE=CITE>This means that your instance will need to be shutdown.&nbsp;

Edit the trace file
 that is generated with the backup controlfile to trace and startup nomount
 and execute the create controlfile statement with the new maxdatafiles setting.  You can run this like a SQL statement.  If you have never done
 this before and/or this is a production instance I would suggest taking a
 look at one of the manuals, or a backup and recovery guide.  I also highly
 recommend trying this initially in a test environment so that you get a feel
 for it.  It is not a difficult task, but also not something to be taken

<br>lightly either.
<p>Comments, corrections are always welcome.
<p>James
<p>-----Original Message-----
<br>Sent: Wednesday, May 31, 2000 5:18 AM
<br>To: Multiple recipients of list ORACLE-L
<br>instance
<p>What do you mean by recreating the control files ?
<p>-----Message d'origine-----
<br>De: Steve Boyd [<a href="mailto:pimaco_oracle_at_hotmail.com">mailto:pimaco_oracle_at_hotmail.com</a>]
<br>Date: mardi 30 mai 2000 19:07
<br>&Agrave;: Multiple recipients of list ORACLE-L
<br>Objet: Re: How to change the value of MAXDATAFILES of a running instance
<br>?
<p>I'm surprised that nobody else has answered this one yet, so I'll go

ahead
 and post.
You need to recreate the controlfile.  Do the good old ALTER DATABASE BACKUP

<p>CONTROLFILE TO TRACE;
<p>Up the parameter in the script this generates, and recreate the controlfile.
<p>&nbsp; Of course, you will need to take down your database to do this.
<p>>From: ALEMU Abiy &lt;abiy.alemu_at_criltechnology.com>
<br>>Reply-To: ORACLE-L_at_fatcity.com
<br>>To: Multiple recipients of list ORACLE-L &lt;ORACLE-L_at_fatcity.com>
<br>>Subject: How to change the value of MAXDATAFILES of a running instance

<br>>Date: Tue, 30 May 2000 07:56:04 -0800
<br>>
<br>>Is there somebody who knows how to change the MAXDATAFILES parameter

value
 >of a running database ?  If so, I'm really very grateful to anyone who can

<br>>explain me.
<br>>
<br>>Thank you friends !!!
<br>>--
<br>>Author: ALEMU Abiy
<br>>&nbsp;&nbsp; INET: abiy.alemu_at_criltechnology.com
<br>>
<br>>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp;

FAX: (858) 538-5051
 >San Diego, California        -- Public Internet access / Mailing Lists

<br>>--------------------------------------------------------------------
<br>>To REMOVE yourself from this mailing list, send an E-Mail message
<br>>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

<br>>also send the HELP command for other information (like subscribing).
<p>________________________________________________________________________
<br>Get Your Private, Free E-mail from MSN Hotmail at <a href="http://www.hotmail.com">http://www.hotmail.com</a>
<p>--
<br>Author: Steve Boyd
<br>&nbsp; INET: pimaco_oracle_at_hotmail.com
<p>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp;

FAX: (858) 538-5051
 San Diego, California        -- Public Internet access / Mailing Lists

<br>--------------------------------------------------------------------
<br>To REMOVE yourself from this mailing list, send an E-Mail message
<br>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

<br>also send the HELP command for other information (like subscribing).
<br>--
<br>Author: ALEMU Abiy
<br>&nbsp; INET: abiy.alemu_at_criltechnology.com
<p>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp;

FAX: (858) 538-5051
 San Diego, California        -- Public Internet access / Mailing Lists

<br>--------------------------------------------------------------------
<br>To REMOVE yourself from this mailing list, send an E-Mail message
<br>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

<br>also send the HELP command for other information (like subscribing)...
<br>--
<br>Author: James Bullard
<br>&nbsp; INET: jbullard_at_onvia.com
<p>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp;

FAX: (858) 538-5051
 San Diego, California        -- Public Internet access / Mailing Lists

<br>--------------------------------------------------------------------
<br>To REMOVE yourself from this mailing list, send an E-Mail message
<br>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).</blockquote> </html>

--------------7E3484AC48D8EE896DF6591D--

--------------B6CD0C51F7E80F257551F4A4
Content-Type: text/x-vcard; charset=us-ascii; name="gentry.vcf"
Content-Description: Card for gentry
Content-Disposition: attachment;
filename="gentry.vcf"
Content-Transfer-Encoding: 7bit Received on Wed May 31 2000 - 10:20:15 CDT