DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, April 30, 2018

I have faced ORA-01118: Cannot add any more data file limit exceeded.

When the Database is created the db_file parameter in the initialization file is set to a limit. You can shutdown the database and reset these up to the MAX_DATAFILE as specified in database creation. The default for MAXDATAFILES is 30. If the MAX_DATAFILES is set to low, you will have to rebuild the control file to increase it before proceeding.The simplest way to recreate the controlfile to change the ‘hard’ value MAXDATAFILES

I have followed below steps:

ALTER DATABASE BHACKUP CONTROLFILE TO TRACE;

Then go to UDUMP destination pick it up and modify the value of MAXDATAFILES

SHUTDOWN IMMEDIATE;
STARTUP NOMOUNT;
sql> @(name of edited file);


No comments: