Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBV slow W2K server

RE: DBV slow W2K server

From: Seán <O'>
Date: Thu, 1 Jun 2006 14:21:58 +0100
Message-ID: <ED830ACBD3C0DD4AAC649376C54CFD8602347974@SWSMS01.emea.pharma.intra>

Use XCOPY to copy files disk-to-disk. Takes approx 80 minutes to copy files (147GB). 2GB RAM.

-----Original Message-----
From: Christo Kutrovsky [] Sent: 01 June 2006 14:08
To: O'Neill, S. (Seán)
Cc: Sriram Kumar; List, Oracle-l Freelists Subject: Re: DBV slow W2K server

So how do you backup your files ? Windows copy ?

If you are doing that, you are totally trashing your windows cache. I am not sure how big your system is (db size/RAM size) but I would guess that during the backup it's not performing that good ?

On 6/1/06, O'Neill, S. (Seán) <> wrote:
> Hi Sriram,
> The particular DB has an offline backup taken each night Mon - Fri.
> This is done on a disk-to-disk basis. I was simply running the DBV on
> the backed up files as an extra check to verify if any corruption was
> present in files. We've not moved to RMAN (yet!). The AV settings are
> as they always were on the drive in question, i.e. excluded.
> - Seán
> -----Original Message-----
> From: Sriram Kumar []
> Sent: 01 June 2006 12:50
> To: O'Neill, S. (Seán)
> Cc: List, Oracle-l Freelists
> Subject: Re: DBV slow W2K server
> Hi Sean,
> As pointed out by gurus it doesn't make sense to run a DBV on
> DB/Backup on a daily basis for a DB that is big in size. you can try
> to schedule the DBV may be once in a week/fortnight/month(off peak
> time when nothing else is
> running) as a proactive measure.
> I assume you are not using RMAN for DB backup.I dont know the size of
> your DB/backup and hence comment on the time taken for the DBV.
> Being a Windows Box, I am to ask you an basic question. Is by any
> chance the Virus Scanner is enabled on the area where Oracle
> Datafiles/Backups are located?. If yes this could slow down things and
> may be you can configure the VS to ignore these areas.
> Best Regards
> Sriram Kumar
> On 5/30/06, =?iso-8859-1?Q?O' <=?iso-
> 8859-1?Q?O'> wrote:
> > Hi Folks,
> >
> > Would appreciate some help/guidance with an issue I've noticed with
> > the
> dbv utility on Windows 2000 server. I'm using this utility as part of
> an offline backup process. For some reason the dbv is now taking over
> 9 hours to complete. It used to take about half this time. I've been
> to Internet to try and track down if this is a known issue but to no avail. The Oracle
> manuals have not been much help either. I've looked at the server and it
> does not appear to be maxed out by anything that would cripple the dbv
> executing.
> >
> > Regards,
> > - Seán O' Neill
> > --
> >
> >
> >
> >

Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group -
I blog at
Received on Thu Jun 01 2006 - 08:21:58 CDT

Original text of this message