Re: Mysterious disk activity

If you are backing up 'live' Oracle files, you may be asking for potential problems...
Either shutdown the database before doing a cold backup, or set up a 'hot' backup scenario that puts tablespace(s) into backup mode and resets them after copying it ( if you isolate your tablespace data disks from your log file disk(s), no activity will happen on the 'backup mode' tablespace drive(s) - or use an 3rd party Agent ( like ArcServ's ) that 'knows' about Oracle...

"John" <john_nospam_at_tolltex.com> wrote:

>
>"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
>news:3A55A3A9.7739_at_yahoo.com...
>> John wrote:
>> >
>> > This all makes sense to me. My problem is I cant find a way to diasable
 or
>> > extend the time period for the checkpoint process.
>> >
>> > The Oracle docs tell me to use "CHECKPOINT_PROCESS=FALSE" in the
 init.ora
>> > file, but on startup, the DB tells me that "CHECKPOINT_PROCESS" is an
>> > invalid parameter. I get the same result when changing the
 configuration
>> > using the oracle instance manager.
>> >
>> > Any other Ideas ?
>> >
>> > Oracle lover/hater:
>> > John
>> >
>> > "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in
 message
>> > news:934kq3$2df$1_at_soap.pipex.net...
>> > > "Jining Han" <hanj_at_mailcity.com> wrote in message
>> > > news:932pr5$1an$1_at_nnrp1.deja.com...
>> > > > In article <4f456.5885$fC1.38853_at_nnrp1.ptd.net>,
>> > > > "John" <john_nospam_at_tolltex.com> wrote:
>> > > > > I have an Oracle 8 DB installed on an NT-Server and with no
 sessions
 open,
>> > > > > the database accesses the disk about every three seconds. I have
 loked
>> > > > > everywhere I can think of to find what is causing this but have
 come
 up dry.
>> > > > >
>> > > > > Any ideas ?.
>> > > > >
>> > > > > Thanks in advance
>> > > > > John
>> > > > >
>> > > > >
>> > > >
>> > > > 'Cause it's NT:)
>> > >
>> > > Reproducible on Unix,VMS etc as well. By default the DB will
 checkpoint
>> > > every 3 seconds.
>> > >
>> > >
>> > > --
>> > > Niall Litchfield
>> > > Oracle DBA
>> > > Audit Commission UK
>> > >
>> > >
>>
>> Why worry about it ?
>>
>> One tiny I/O every three seconds will pale into insignficance once your
>> database starts getting used in earnest...
>>
>> HTH
>> Connor
>
>My backup software is failing with the error "unable to get sufficient disk
>quiet time". Besides this, I think it is silly for the disk to be written
>to every three seconds, 24/7/365 even if no sessions are open. This seems
>to just be asking for premature disk failure.
>
>John
>
>P.S. I already had my "log_checkpoint_interval" increased from 3 to 60 to no
>effect.
>
Received on Fri Jan 05 2001 - 14:14:24 CST