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

From: ALEMU Abiy <abiy.alemu_at_criltechnology.com>
Date: Wed, 31 May 2000 16:57:33 +0200
Message-Id: <10514.107315@fatcity.com>

Tnak you james !

-----Message d'origine-----
De: James Bullard [mailto:jbullard_at_onvia.com] Date: mercredi 31 mai 2000 17:24
=C0: Multiple recipients of list ORACLE-L Objet: RE: How to change the value of MAXDATAFILES of a running = instance

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 = 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 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 = instance
?

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

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

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 =
value
>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.com

--=20
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). --=20
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)... --=20
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
--------------------------------------------------------------------