Re: Control file access in Oracle 8.1.5.

Hi Pat,

I set CONTROL_FILE_RECORD_KEEP_TIME=0 (alter system), but it made no difference. The control files are still written to every 3 seconds! The trace file from "backup control file to trace" gives no clues.

Tony

> Starting with Oracle 8.0, the control file is used to store info for
 RMAN
> backups and restores. Some of the info is overwritten regularly,
 some of
> it is not.
>
> If you don't use RMAN you can set the parameter
> CONTROL_FILE_RECORD_KEEP_TIME=0 to tell Oracle to recycle the
 information
> all the time. The integer zero is in days, so if you are using RMAN
 and
> want to keep a week's worth of info in the control file set it to 7.
>
> I wonder what ALTER DATABASE BACKUP CONTROL FILE TO TRACE would show
 you?
> I haven't tried this.
>
> Oracle may have added other things in the control file for 8i, I don't
> know.
>
> Regards,
>
> Pat.
>
> Tony Adolph wrote:
>
> > Hello All,
> >
> > Using NT File Monitor I noticed that on an Ora 815 database the
 control
> > files are written to every 3 seconds! (This is not the case on an
 Ora
> > 7.3.4 database). Is this really the case or the write only a memory
> > write? Any info would be appreciated.
> >
> > Cheers
> > Tony Adolph
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu May 04 2000 - 00:00:00 CDT