ALEMU make following steps:
1.- alter database backup controfile to trace noresetlogs;
2.- Edit your dump file and modify MAXDATAFILES value.
Normally you can find that file in $ORACLE_HOME/rdbms/log.
3.- Shutdown your database.
4.- Startup nomount your database.
5.- Run the 'create controlfile' command in your dump file.
6.- alter database open;
Maybe, before that, it's interesting you make a full backup and,
after that, another full backup.
HTH
Regards.
Miguel.
> -----Mensaje original-----
> De: ALEMU Abiy [SMTP:abiy.alemu_at_criltechnology.com]
> Enviado el: mi=E9rcoles 31 de mayo de 2000 14:18
> Para: Multiple recipients of list ORACLE-L
> Asunto: RE: How to change the value of MAXDATAFILES of a running
> instance
>=20
> What do you mean by recreating the control files ?
>=20
> -----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
> ?
>=20
>=20
> I'm surprised that nobody else has answered this one yet, so I'll go =
ahead
>=20
> and post.
>=20
> You need to recreate the controlfile. Do the good old ALTER DATABASE
> BACKUP
>=20
> CONTROLFILE TO TRACE;
>=20
> Up the parameter in the script this generates, and recreate the
> controlfile.
>=20
> Of course, you will need to take down your database to do this.
>=20
>=20
> >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).
>=20
> =
________________________________________________________________________=
> Get Your Private, Free E-mail from MSN Hotmail at =
http://www.hotmail.com
>=20
> --=20
> Author: Steve Boyd
> INET: pimaco_oracle_at_hotmail.com
>=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).
> --=20
> Author: ALEMU Abiy
> INET: abiy.alemu_at_criltechnology.com
>=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
Received on Wed May 31 2000 - 09:23:08 CDT