urgent help in creating backup controlfile to trace

[dba_usa]

Hello,

I created a 8.1.7 database and added 250 new tablespaces. at one point i got ora-00059- maximum DB_FILES exceeded.
I increased the db_files parameter and i again started the database, got the same error, it did not mount.

i tried to alter database backup controlfile to trace to edit the file, but database is not mounted ora 01507

what to do now?

how to proceed?

thanks

[pando]

startup mount

alter database backup controlfile to trace

[dba_usa]

I tried that : alter database backup controlfile to trace, but i get that error that database is not mounted.

if i try startup mount : i get 00059: maximum DB_FILES exceeded.

so, what should i do ? delete the database and recreate all over again ?

[pando]

well from 8i if you increase db_files your controlfile would accommodate more datafiles based on db_files parameter so I dont see why you are getting problems?

[dba_usa]

db_files=500, i increased db_files=800 in the init.ora, then the problems started, i went back to 500, still that exists.

so, what is that i have to do now?

[jmodic]

Are you absolutely sure you are editing the correct init.ora file? Try STARTUP MOUNT with PFILE=the_file_you_have_edited option.

[pando]

also are you sure you have less than 800 files...?

[dba_usa]

yes, i am sure i am editing the correct file and also am sure it has less than 800 files.
i will try to startup mount with pfile=edited_file option and see what happens.

thanks

[helpme]

try to follow the steps from here

http://www.jlcomp.demon.co.uk/faq/incr_db_files.html

HTH
sam

[dba_usa]

i could mount with startup mount with pfile=edited_file option ,
also i changed the maxdatafiles in the trace file.

now,how to proceed?
do i have to delete all the controlfiles,log files etc, and then recreate the database again?
or just run the edited trace file ?