Re: Oracle Server will write continually to control files.

Daniel:

This is not an Oracle backup question. We are doing proper Oracle backup using the proper agents. We have however, other files in that drive, which are not oracle related, which we like to backup. The IO generated by the oracle process, specifically in the control files is preventing BE OFO from generating a snapshot of this non-Oracle related files.

I was hopping we could adjust the timing of this writes. Maybe this should be an enhancement request for Oracle. :-)

I guess the bottom line is that since we cant eliminate the constant IO or reduce the minimum quiet time (below the minimum) we just have to plan and separate this thing in separate drives to eliminate the contention.

This would be a sample to specific software with particular requirements in which both can't be accommodated.

Thanks for the feedback.

"DA Morgan" <damorgan_at_x.washington.edu> wrote in message news:41e62387$1_1_at_127.0.0.1...
> Orlando Amador wrote:
>
> > 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).
> >
> > 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?
> <snipped>
> > Saludos
> > Orlando Amador
>
> Everything Tom Kyte said plus ... why aren't you using RMAN?
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace 'x' with 'u' to respond)
Received on Thu Jan 13 2005 - 16:25:49 CST