Re: Oracle Server will write continually to control files.

In article <cs3h0f0ja3_at_news3.newsguy.com>, Orlando Amador says...
>
>We have a Oralce 9.2 Standard database server with multiple database
>instances. Each instance has 2 control files, although in the same
>directory.
>
>Using a file monitor we find that the server will write a block of 8K to
>offset 24576 of the control files every 3 seconds. I wonder if this some
>kind of synchronization, locking, or heartbeat function in the database.
>The accumulated IO from the writes from a single database is not a problem,
>but the accumulation from multiple database is creating problem for our
>backup software (Veritas BackupExec with OFO).

how is this creating a program for backup software?

file system backups of controlfiles for open database are "not useful" -- they shouldn't be touching them while the database is up.

You aren't "backing up" your databases with this stuff are you? (if so -- it is probable that you have nothing valid to restore with)...

>
>We figure that we can repartition this server and separate the databases in
>separate disk, but we are saving that as a last resort. I was hopping
>someone could point me to the reason of this updates and if there is a way
>to configure the timing? Maybe this is a required function but it could be
>slow down a bit? This updates happens constantly, even when the database is
>not in use and there is no connections.
>
>Any suggestions?
>
>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
>11:39:37 AM oracle.exe:1128 WRITE D:\oracle\oradata\ISODEV\CONTROL01.CTL
>SUCCESS Offset: 24576 Length: 8192
>11:39:37 AM oracle.exe:1128 WRITE D:\oracle\oradata\ISODEV\CONTROL02.CTL
>SUCCESS Offset: 24576 Length: 8192
>11:39:40 AM oracle.exe:1128 WRITE D:\oracle\oradata\ISODEV\CONTROL01.CTL
>SUCCESS Offset: 24576 Length: 8192
>11:39:40 AM oracle.exe:1128 WRITE D:\oracle\oradata\ISODEV\CONTROL02.CTL
>SUCCESS Offset: 24576 Length: 8192
>11:39:43 AM oracle.exe:1128 WRITE D:\oracle\oradata\ISODEV\CONTROL01.CTL
>SUCCESS Offset: 24576 Length: 8192
>11:39:43 AM oracle.exe:1128 WRITE D:\oracle\oradata\ISODEV\CONTROL02.CTL
>SUCCESS Offset: 24576 Length: 8192
>11:39:46 AM oracle.exe:1128 WRITE D:\oracle\oradata\ISODEV\CONTROL01.CTL
>SUCCESS Offset: 24576 Length: 8192
>11:39:46 AM oracle.exe:1128 WRITE D:\oracle\oradata\ISODEV\CONTROL02.CTL
>SUCCESS Offset: 24576 Length: 8192
>
>Saludos
>Orlando Amador
>
>
>

-- 
Thomas Kyte
Oracle Public Sector
http://asktom.oracle.com/
opinions are my own and may not reflect those of Oracle Corporation