Name

CONTROL_FILE_RECORD_KEEP_TIME (Oracle8 Only)

Synopsis

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

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset