Create control file for changing the db_files parameter
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 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.
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.