Re: HOW to increase DB_FILES?

Hi

You can just increase the DB_FILES parameter in the init.ora and restart you're database. This should be sufficient to increase the maximum amount of db_files for that instance. However you're maximum number of datafiles is controlled by the MAXDATAFILES parameter at time of Database creation. You're maximim number of datafiles is also system specific. On the other hand an instance cannot be mounted unles DB_FILES equals or is greater than MAXDATAFILES. Don't ask me why as I don't get it as well.

If you need to up your MAXDATAFILES you have to recreate your CONTROL FILE.

I hope this was useful to you. Please let me know.

Cheers
akader_at_health.sanlam.co.za

thomasl_at_expansion.com wrote in article
<61cp8a$kgm_at_ecuador.earthlink.net>...
> Lando/others,
>
> Why can't you just up the db_files = <higher or lower value>
> stop and restart the datbase?
>
> Should the database read the parameter and readjust the configuration
> automatically?
>
> please email thomasl_at_earthlink.net
>
> Thanks
>
> Thomas
>
>
>
>
> In article <3433F3CC.9C3ACA95_at_quebim.com>, Lando <MarkL_at_quebim.com>
 writes:
>
> >You have reached the MAXDATAFILES limit that was imposed when you
> >created the
> >database (I believe the default is 32). To increase this limit you will
> >have to recreate your
> >controlfiles and up the parameter value for maxdatafiles. Briefly, To do
> >this:
> >0) make sure you have a good backup
> >
> >1) alter database backup controlfile to trace;
> >2) edit the .trc file just created in step 1, increase maxdatafiles
> >value;
> > edit initsid.ora increase db_files to equal new maxdatafile parm.
> >3) shutdown
> >4) startup nomount
> >5) run the file edited in step 2.
> >
> >This documented should be in the manuals somewhere.
> >
> >
> >DLEUNG wrote:
> >
> >> HI ,
> >>
> >> I am trying to increase the Max.number for DB_FILES in
> >> oracle 7.32. (solaris platform),
> >> because I would like to add more files to a tablespace.
> >>
> >> BUt I got the following error:
> >> alter tablespace data05 add datafile '/u9/oradata/CNC01/data05_u9.dbf'
> >> size 150M
> >> *
> >> ERROR at line 1:
> >> ORA-00059: maximum number of DB_FILES exceeded
> >>
> >> -----
> >> I go to init_instance_name.ora
> >> and change the db_files from 20 to 40 ,
> >> and then shutdown oracle and bring up by
> >> startup.
> >> BUt it still say the same error.
> >>
> >> I call Oracle support,
> >> they told me instruction of recreate control_files
> >> to increase MAXDATFILES,
> >> I can successfully increase the MAXDATAFILES to 60, but it does not
> >> help me ,
> >> I try to add one additional (new ) file to a tablespace data05
> >> , I havethe exact error again.
> >>
> >> I really appreciate if anyone can give me some help/hint,
> >> because ORacle Support is very unhelpful.
> >> They told me , it should work.
> >> I am wondering whether MAXDATAFILES has anything to do with DB_FILES?
> >>
> >> Please email me directly, because I dont read this news group that
> >> often
> >>
> >> Thank you in advance,
> >>
> >> Dominica Leung
> >>
> >> dleung_at_cncx.com
> >>
> >> or dleung_at_concentric.net
> >
> >
> >
>
Received on Tue Oct 07 1997 - 00:00:00 CDT