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