Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re-creating control files with larger maxdatafile setting
KG,
you cannot increase the db_files parameters beyond the MAXDATALIFLES number. Oracle reserves space for storing the info about individual datafiles in the control files depending upon the MAXDATAFILES.
To increase the number of datafiles beyond this limit, you have to recreate the Control file.
TO create a control file, do a ALTER DATABASE BACKUP CONTROLFILE TO TRACE, which will create a script file to recreate the control file. You can edit that file and increase the MAXDATAFILES and then recreate the controlfile using the script file
Regards
Naveen
-----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
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 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).
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).
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 - 04:13:28 CDT
![]() |
![]() |