RE: DBV slow W2K server

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

-----Original Message-----
From: Christo Kutrovsky [mailto:kutrovsky.oracle_at_gmail.com] 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) <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