CONTROL_FILE_RECORD_KEEP_TIME

CONTROL_FILE_RECORD_KEEP_TIME

Property	Description
Parameter type	Integer
Default value	7 (days)
Modifiable	ALTER SYSTEM
Range of values	0 to 365 (days)
Basic	No

CONTROL_FILE_RECORD_KEEP_TIME specifies the minimum number of days before a reusable record in the control file can be reused. In the event a new record needs to be added to a reusable section and the oldest record has not aged enough, the record section expands. If this parameter is set to 0, then reusable sections never expand, and records are reused as needed.

Note:

This parameter applies only to records in the control file that are circularly reusable (such as archive log records and various backup records). It does not apply to records such as datafile, tablespace, and redo thread records, which are never reused unless the corresponding object is dropped from the tablespace.

 

翻译如下：

control_file_record_keep_time表示控制文件里可重复使用的记录所能保存的最小天数。如果新增加一条记录到控制文件可以重复使用的部分，这时最老的记录尚没有超出最小保留天数，那么记录将控制文件的这一部分将扩展。如果将该参数设置为0，那么控制文件可以重复使用的部分将永远不会扩展。

注意，这个参数只应用于控制文件中可循环使用的部分，如归档日志文件，各种备份记录。不应用于诸如数据文件，表空间，重做线程记录等，这些内容只有当其从对应的表空间中删除后才能重用。

可重用的部分包括如下几种类型（可以通过查询视图$contofile_record_section得到）：
ARCHIVED LOG
BACKUP CORRUPTION
BACKUP DATAFILE
BACKUP PIECE
BACKUP REDO LOG
BACKUP SET
COPY CORRUPTION
DATAFILE COPY
DELETED OBJECT
LOGHISTORY
OFFLINE RANGE

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16405897/viewspace-620384/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16405897/viewspace-620384/