urgent help in creating backup controlfile to trace
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: urgent help in creating backup controlfile to trace

  1. #1
    Join Date
    Sep 2001
    Posts
    76
    Hello,

    I created a 8.1.7 database and added 250 new tablespaces. at one point i got ora-00059- maximum DB_FILES exceeded.
    I increased the db_files parameter and i again started the database, got the same error, it did not mount.

    i tried to alter database backup controlfile to trace to edit the file, but database is not mounted ora 01507

    what to do now?

    how to proceed?

    thanks


  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    startup mount

    alter database backup controlfile to trace

  3. #3
    Join Date
    Sep 2001
    Posts
    76
    I tried that : alter database backup controlfile to trace, but i get that error that database is not mounted.

    if i try startup mount : i get 00059: maximum DB_FILES exceeded.

    so, what should i do ? delete the database and recreate all over again ?

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well from 8i if you increase db_files your controlfile would accommodate more datafiles based on db_files parameter so I dont see why you are getting problems?

  5. #5
    Join Date
    Sep 2001
    Posts
    76
    db_files=500, i increased db_files=800 in the init.ora, then the problems started, i went back to 500, still that exists.

    so, what is that i have to do now?

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Are you absolutely sure you are editing the correct init.ora file? Try STARTUP MOUNT with PFILE=the_file_you_have_edited option.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    also are you sure you have less than 800 files...?

  8. #8
    Join Date
    Sep 2001
    Posts
    76
    yes, i am sure i am editing the correct file and also am sure it has less than 800 files.
    i will try to startup mount with pfile=edited_file option and see what happens.

    thanks

  9. #9
    Join Date
    Jun 2001
    Posts
    316
    try to follow the steps from here

    http://www.jlcomp.demon.co.uk/faq/incr_db_files.html

    HTH
    sam

  10. #10
    Join Date
    Sep 2001
    Posts
    76
    i could mount with startup mount with pfile=edited_file option ,
    also i changed the maxdatafiles in the trace file.

    now,how to proceed?
    do i have to delete all the controlfiles,log files etc, and then recreate the database again?
    or just run the edited trace file ?

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