CONTROLFILE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: CONTROLFILE

  1. #1
    Join Date
    Jun 2002
    Posts
    64
    Hi All,

    Oracle overwrites the controlfile records which exceeds the CONTROL_FILE_RECORD_KEEP_TIME init.ora parameter.

    Assume that the controlfile is full, none of the controlfile records exceed the no. of days specified by this paramter and the o/s file limit has reached for the controlfile.

    At this point if a few datafiles are added into the database, Oracle has to store this info in the controlfile, then oracle starts overwriting the controlfile records.

    Now, if the previously created datafile location and other info are overwritten, How Oracle will identify this and open the database during the next startup?

    Please correct me if my understanding is wrong

    Cheers
    Najmal

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Najmal,

    There are two type of records stored in the controlfile. One is recyclable while the other can not be recycled or overwritten.
    The information such as datafile and logfile are not overwritten. Only recyclable records can be overwritten.

    In your scenario I think Oracle will written some error that there is not enough space for controlfile to grow. Not sure though that Oracle has any such documented error.

    Sanjay






  3. #3
    Join Date
    Jun 2002
    Posts
    64
    Thanks Sanjay!

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