CONTROL_FILE_RECORD_KEEP_TIME (Oracle8 Only)
Values:0 to 365
Default:7
Specifies the minimum age, in days, that certain records in the control file must attain before they can be reused. Records in some sections on the control file are circularly reusable, while records in other sections are never reused. CONTROL_FILE_RECORD_KEEP_TIME applies to the reusable sections. Ordinarily, when a new record needs to be added to a reusable section and the oldest record has not aged enough, the record section expands. When this parameter is set to 0, reusable sections never expand and records are reused as needed. The reusable sections of the control file are:
ARCHIVED LOG |
BACKUP CORRUPTION |
BACKUP DATAFILE |
BACKUP PIECE |
BACKUP REDO LOG |
BACKUP SET |
COPY CORRUPTION |
DATAFILE COPY |
DELETED OBJECT |
LOGHISTORY |
OFFLINE RANGE |