-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|