Re: Oracle Server will write continually to control files.

"Orlando Amador" <oamador_REMOVE_ME_at_obipr.jnj.com> wrote in message news:cs3kt30mg8_at_news3.newsguy.com...
>
> Veritas BackupExec Open File Option requires a minimun quite time.
> Because
> if the constant writes it is not able to acchive the minimun quite window.

I assume you mean 'quiet'.

>>
>> file system backups of controlfiles for open database are "not useful" --
> they
>> shouldn't be touching them while the database is up.
>>
>
> The have agents for performing hot backup of the data, redo, and control
> files. That is not the issue here. There are other non-Data files on the
> same drive we are trying to backup.

First up you should keep database files and os files separate. You've just run into a very good reason for this, the backup characteristics are different. This isn't Oracle specific advice by the way its a feature of the RDBMS software - as you are running windows take a look at the file placement recommendations for sql server, you'll find a similar thing.

<snip>
>
> Any ideas on how to reduce the frequency of this writes?

Can't be done.

>> >
>> >11:39:33 AM oracle.exe:1128 WRITE
>> >D:\oracle\oradata\ISODEV\CONTROL01.CTL
>> >SUCCESS Offset: 24576 Length: 8192
>> >11:39:33 AM oracle.exe:1128 WRITE
>> >D:\oracle\oradata\ISODEV\CONTROL02.CTL
>> >SUCCESS Offset: 24576 Length: 8192

Apart from anything else it looks like you have got two copies of your controlfile (this is a good thing) and placed them on the same logical volume (this isn't).

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com