First page Back Continue Last page Graphics

Continuation of Notes


Notes:

Initially, (just after CREATE DATABASE) the records are mostly empty. As activity occurs on the database, the control file receives information about log switches and archived logs from the log writer and archive writer background processes. This information is stored in reusable records in the control file. The control_file_record_keep_time parameter controls when a reusable record expires – which means the record can be overwritten. The purpose of the CFRKT parameter is to specify a recovery window – how far back in time you would like to be able to recover to.

Tom Kyte of “asktom.oracle.com” says: “set your control_file_record_keep_time to be at least one day GREATER then the period of time between your backups, else there is a chance that an archive record gets aged out during the backup which thoroughly confuses the situation.”