Create control file for changing the db_files parameter
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Create control file for changing the db_files parameter

  1. #1
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    how about just changing the db_files parameter without recreating the control file

  3. #3
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    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

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    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)

  5. #5
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    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

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    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

  7. #7
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    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

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    does the alert log show anything about expanding the control file

  9. #9
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    No nothing in Alert log...


    Rgds
    Parag

  10. #10
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    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
  •  



Click Here to Expand Forum to Full Width