Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re-creating control files with larger maxdatafile setting

RE: Re-creating control files with larger maxdatafile setting

From: Naveen Nahata <naveen_nahata_at_mindtree.com>
Date: Thu, 19 Sep 2002 03:43:23 -0800
Message-ID: <F001.004D3623.20020919034323@fatcity.com> 





Well, point taken. I'll try and test it too when I get time.



My point came from the DB Reference Guide, 9i Release 2. You can also see the
same point in the SQL Reference in ALTER SYSTEM command. Maybe it is
out-dated.



That caused the confusion.



Regards


Naveen



-----Original Message-----



Sent: Thursday, September 19, 2002 4:18 PM
To: Multiple recipients of list ORACLE-L




THis one is from  pg 876 of Oracle9i SQL Reference
PArt # A90125-01




*****BEGIN QUOTE********



MAXDATAFILES Clause


Specify the initial sizing of the datafiles section of the control file at
CREATE



DATABASE or CREATE CONTROLFILE time. An attempt to add a file whose number
is greater than MAXDATAFILES, but less than or equal to DB_FILES, causes the
control file to expand automatically so that the datafiles section can
accommodate


more files.


The number of datafiles accessible to your instance is also limited by the
initialization parameter DB_FILES.


********END QUOTE********



So it is clear that you can add datafiles to the database without
recreating the control files as long as the db_files are specified
to higher number.




KG




-----Original Message-----



Nahata


Sent: Thursday, September 19, 2002 2:39 AM
To: Multiple recipients of list ORACLE-L




KG,



This is from 9i Manual:



DB_FILES:



Parameter type             Integer
Default value              200
Parameter class            Static
Range of values
Minimum:                   the current actual number of datafiles in the
database
Maximum:                   the value that was specified in the MAXDATAFILES
                           clause the last time CREATE DATABASE or CREATE
CONTROLFILE
                           was executed




Oracle9i Real Application Clusters You must set this parameter for every
instance, and multiple


instances must have the same value.



Regards


Naveen



-----Original Message-----



Sent: Thursday, September 19, 2002 2:39 PM
To: Multiple recipients of list ORACLE-L




Not quite true. Starting from Oracle8 you don't need
to recreate the controlfile to increase the MAXDATAFILES
parameter.



You can just change the db_files and bounce the server.



KG




-----Original Message-----



Khanna


Sent: Thursday, September 19, 2002 1:43 AM
To: Multiple recipients of list ORACLE-L




KG,



It will not help just by increasing the db_files parameter in the Init.ora
file. Whenever you need to change MAXDATAFILES,MAXLOGFILES,MAXLOGMEMBERS for
your database the change is to recreate the control file and then mount and
open the database.



What needs to be done is :



Svrmgr> Alter database backup controlfile to TRACE;
This would generate an ASCII text based file at the location defined by
USE_DUMP_DEST in your init.ora. Edit that file in any text editor and chane
the Value of MAXDATAFILES (in your case). Save the file with some name at a
particular destination.eg C:\Controlfile\Control.Sql



SVRMGR> Shutdown immediate;


Instance Shutdown.


SVRMGR>Startup Nomount;


Instance Started.


SVRMGR>@C:\Controlfile\Control.Sql;


Statement Processed.


SVRMGR> Alter database mount;


Database Mounted.


Svrmgr> Alter database open;


Database opened.



Now you can create the new datafiles to expand your database. Never the
parameter db_files can be more that the MADATAFILES declared in your
controlfile;



Thanks


Vikas Khanna



-----Original Message-----



Sent: Thursday, September 19, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L




George:



If you want to recreate the controlfile **just to **
increase the max datafiles, you can simply increase
the db_files parameter and bounce the database. This
will automatically chance the max datafiles settings
when you create the additional datafiles.



KG




-----Original Message-----



Leonard (ZA)


Sent: Thursday, September 19, 2002 12:13 AM
To: Multiple recipients of list ORACLE-L




Hi all



Does someone maybe have a step by step guide to re-creating the control
files. I have found that one the my databases the maxdatafiles has been set
to small, would like to increase it now.



thx



George




George Leonard


Oracle Database Administrator


Dimension Data (Pty) Ltd


(Reg. No. 1987/006597/07)


Tel: (+27 11) 575 0573


Fax: (+27 11) 576 0573


E-mail:george.leonard_at_za.didata.com


Web:   http://www.didata.co.za



You Have The Obligation to Inform One Honestly of the risk, And As a Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity!
Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
or Injure Themselves as They See Fit!







This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.



This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.



www.mimesweeper.com





--



Please see the official ORACLE-L FAQ: http://www.orafaq.com


--



Author: George Leonard (ZA)


  INET: George.Leonard_at_za.didata.com


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

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


--



Please see the official ORACLE-L FAQ: http://www.orafaq.com


--



Author: K Gopalakrishnan


  INET: kaygopal_at_yahoo.com


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

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


--



Please see the official ORACLE-L FAQ: http://www.orafaq.com


--



Author: Vikas Khanna


  INET: vkhanna_at_quark.co.in


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

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



--



Please see the official ORACLE-L FAQ: http://www.orafaq.com


--



Author: K Gopalakrishnan


  INET: kaygopal_at_yahoo.com


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

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


--



Please see the official ORACLE-L FAQ: http://www.orafaq.com


--



Author: Naveen Nahata


  INET: naveen_nahata_at_mindtree.com


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

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



-- 



Please see the official ORACLE-L FAQ: http://www.orafaq.com


-- 



Author: K Gopalakrishnan


  INET: kaygopal_at_yahoo.com


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

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


-- 



Please see the official ORACLE-L FAQ: http://www.orafaq.com


-- 



Author: Naveen Nahata


  INET: naveen_nahata_at_mindtree.com


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

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 Thu Sep 19 2002 - 06:43:23 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US