Re: Control file access in Oracle 8.1.5.

From: Pat Boivin <lori.pat_at_ns.sympatico.ca>
Date: 2000/05/03
Message-ID: <390F8D30.F7068AF8@ns.sympatico.ca>#1/1

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.
Received on Wed May 03 2000 - 00:00:00 CDT