ORA-00059

Database is in no mount state and am running into
ORA-00059: maximum number of DB_FILES exceeded
I cannot perform alter database backup controlfile to trace to determine MAXDATAFILES.
Need Help to bring up the database.

Thank You
praveen_kattaAsked:
Who is Participating?
 
rbrookerConnect With a Mentor Commented:
Hi,

just out of interest, had you issued :

alter system set db_files = 1000 scope=spfile;

even from nomount state, and restarted the database, you would have been ok.
i ran into this when i restored out data warehouse and this is how i got around it.

just for future reference....

:)
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>ORA-00059: maximum number of DB_FILES exceeded
you have to recreate the database, with a higher number set during create.
see here the full description of the steps:
http://www.jlcomp.demon.co.uk/faq/incr_db_files.html
0
 
praveen_kattaAuthor Commented:
As I have mentioned, the database is in nomount state
and cannot perform alter database backup controlfile to trace. The instructions
mentions to perform this step. Need an alternative please.
0
 
praveen_kattaAuthor Commented:
This problem is resolved. After removing the spfile from $ORACLE\database directory.
It took the change from init.ora file and I was able to open the database with no issues.

0
All Courses

From novice to tech pro — start learning today.