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

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Tue, 30 May 2000 15:29:33 -0400
Message-Id: <10513.107162@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFCA6D.625FD170
Content-Type: text/plain;

charset="iso-8859-1"

I understood his question as if we can do it without bouncing the database. I do not know how without not supported manipulation with DD and controlfiles.

Alex Hillman

-----Original Message-----
From: Deepak Sharma [mailto:sharmakdeep_at_yahoo.com] Sent: Tuesday, May 30, 2000 2:56 PM
To: Multiple recipients of list ORACLE-L Subject: Re: How to change the value of MAXDATAFILES of a running instance ?

You'll have to recreate the control file.

o Alter database backup controlfile to trace o Edit the trace file generated in UDUMP and increase the MAXDATAFILES
o Shutdown database
o Cold Backup database
o Run the Create controlfile script

For details, let me know

Deepak
- ALEMU Abiy <abiy.alemu_at_criltechnology.com> wrote:
  > 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).

Do You Yahoo!?
Kick off your party with Yahoo! Invites. http://invites.yahoo.com/

-- 
Author: Deepak Sharma
  INET: sharmakdeep_at_yahoo.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).

------_=_NextPart_001_01BFCA6D.625FD170
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>RE: How to change the value of MAXDATAFILES of a running =
instance ?</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>I understood his question as if we can do it without =
bouncing the database. I do not know how without not supported =
manipulation with DD and controlfiles.</FONT></P>

<P><FONT SIZE=3D2>Alex Hillman</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Deepak Sharma [<A =
HREF=3D"mailto:sharmakdeep_at_yahoo.com">mailto:sharmakdeep_at_yahoo.com</A>]<=
/FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, May 30, 2000 2:56 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Re: How to change the value of MAXDATAFILES =
of a running</FONT>
<BR><FONT SIZE=3D2>instance ?</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>You'll have to recreate the control file.</FONT>
</P>

<P><FONT SIZE=3D2>o Alter database backup controlfile to trace</FONT>
<BR><FONT SIZE=3D2>o Edit the trace file generated in UDUMP and =
increase</FONT>
<BR><FONT SIZE=3D2>the MAXDATAFILES</FONT>
<BR><FONT SIZE=3D2>o Shutdown database</FONT>
<BR><FONT SIZE=3D2>o Cold Backup database</FONT>
<BR><FONT SIZE=3D2>o Run the Create controlfile script</FONT>
</P>

<P><FONT SIZE=3D2>For details, let me know</FONT>
</P>

<P><FONT SIZE=3D2>-- Deepak</FONT>
</P>

<P><FONT SIZE=3D2>--- ALEMU Abiy &lt;abiy.alemu_at_criltechnology.com&gt; =
wrote:</FONT>
<BR><FONT SIZE=3D2>&gt; Is there somebody who knows how to change =
the</FONT>
<BR><FONT SIZE=3D2>&gt; MAXDATAFILES parameter value</FONT>
<BR><FONT SIZE=3D2>&gt; of a running database ?&nbsp; If so, I'm really =
very</FONT>
<BR><FONT SIZE=3D2>&gt; grateful to anyone who can</FONT>
<BR><FONT SIZE=3D2>&gt; explain me.</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp; </FONT>
<BR><FONT SIZE=3D2>&gt; Thank you friends !!!</FONT>
<BR><FONT SIZE=3D2>&gt; -- </FONT>
<BR><FONT SIZE=3D2>&gt; Author: ALEMU Abiy</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp; INET: =
abiy.alemu_at_criltechnology.com</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Fat City Network Services&nbsp;&nbsp;&nbsp; -- =
(858) 538-5051&nbsp; FAX:</FONT>
<BR><FONT SIZE=3D2>&gt; (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>&gt; San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public =
Internet</FONT>
<BR><FONT SIZE=3D2>&gt; access / Mailing Lists</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>&gt; To REMOVE yourself from this mailing list, send =
an</FONT>
<BR><FONT SIZE=3D2>&gt; E-Mail message</FONT>
<BR><FONT SIZE=3D2>&gt; to: ListGuru_at_fatcity.com (note EXACT spelling =
of</FONT>
<BR><FONT SIZE=3D2>&gt; 'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>&gt; the message BODY, include a line containing: =
UNSUB</FONT>
<BR><FONT SIZE=3D2>&gt; ORACLE-L</FONT>
<BR><FONT SIZE=3D2>&gt; (or the name of mailing list you want to be =
removed</FONT>
<BR><FONT SIZE=3D2>&gt; from).&nbsp; You may</FONT>
<BR><FONT SIZE=3D2>&gt; also send the HELP command for other =
information</FONT>
<BR><FONT SIZE=3D2>&gt; (like subscribing).</FONT>
</P>
<BR>

<P><FONT =
SIZE=3D2>__________________________________________________</FONT>
<BR><FONT SIZE=3D2>Do You Yahoo!?</FONT>
<BR><FONT SIZE=3D2>Kick off your party with Yahoo! Invites.</FONT>
<BR><FONT SIZE=3D2><A HREF=3D"http://invites.yahoo.com/" =
TARGET=3D"_blank">http://invites.yahoo.com/</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Deepak Sharma</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: sharmakdeep_at_yahoo.com</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =
538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =

Received on Tue May 30 2000 - 14:29:33 CDT