Create control file for changing the db_files parameter

[paragp1981]

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

[davey23uk]

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

[paragp1981]

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

[davey23uk]

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)

[paragp1981]

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

[davey23uk]

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

[paragp1981]

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

[davey23uk]

does the alert log show anything about expanding the control file

[paragp1981]

No nothing in Alert log...


Rgds
Parag

[paragp1981]

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