Create control file for changing the db_files parameter

Hi,
I am asking very basic question i am confused actually.
In our DB. db_files=200. Which was set at creation of DB.
Now database is growing and we are almost to the limit of
reaching 200. So i will backup control file to trace and edit
the db_files parameter. and i will run that script in nomount
stage. My question is do i need to open DB in reset logs after
that or normal open will do. And if reset logs why. I am just
changing the no of datafiles.

I read the article by Amar.
http://www.dbasupport.com/forums/sho...highlight=Amar

But still i wann know if we change parameter in control file script. Do we need to open DB in reset logs.

Rgds
Parag

how about just changing the db_files parameter without recreating the control file

Ya it would have been good option but. My MAXDATAFILES in control file is set to 200. and in pfile db_files=200. So i think only alternative is to recreate control file.

Rgds
Parag

didnt pando (i think) prove that if you increase db_files then the control file will automatically get updated? (and you can see it in the alert log)

I was under assumption that db_files can max take MAXDATAFILES in control file according to following link....

http://download-west.oracle.com/docs...htm#REFRN10162

If you have any link ,document,pdf that will point to what you are saying.
I will be very thank full to you.

Rgds
Parag

it was an old thread on here (try searching for it) might not of been db_files, could of been something else but it rings a bell.

try it, if your db doesnt open just change db_files back to 200 and restart - quicker and less chance of error than re-creating a control file

Hi,
I checked on "test DB". In my control file MAXDATAFILES is 300. I set
db_files=600 in pfile . And bounced the DB. It came up properly. After
that i took backup of control file to trace in that file MAXDATAFILES is
still 300. and if you check
show parameter db_files its showing 600.
So i am confused . Will it give me error when i am trying to add file no
301. Coz control file holds value 300 and pfile contains 600.

Can any body explain.

Rgds
Parag

does the alert log show anything about expanding the control file

No nothing in Alert log...


Rgds
Parag

Thanks Davey I got it here iotself...

http://www.dbasupport.com/forums/sho...te+controlfile

Just that alert file will show expanding messages when you reach actual limit. Till that it will show max_data_file =300 and db_files=600 (in my case).
I guess once you reach 300 it will expand control file also and will show 600 in control file also.

Thanks any way. It was a new learning for me...

Rgds
Parag