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) <Sean.oneill_at_organon.ie> 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 [mailto:k.sriramkumar_at_gmail.com]
> 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'Neill_at_freelists.org <=?iso-
> 8859-1?Q?O'Neill_at_freelists.org> 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
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>

-- 
Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group - www.pythian.com
I blog at http://www.pythian.com/blogs/
--
http://www.freelists.org/webpage/oracle-l