Re: 2 GB myth

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 25 Nov 2004 13:50:25 +1100
Message-ID: <41a54872$0$26294$afc38c87@news.optusnet.com.au>

Igor Laletin wrote:
> "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<41a41bc3$0$20857$afc38c87_at_news.optusnet.com.au>...
>

>>Igor Laletin wrote:
>>
>>>"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<41a2a9e6$0$20863$afc38c87_at_news.optusnet.com.au>...

>
> ...
>

>>>>Have you used RMAN to backup a database. The number of data files is a 
>>>>heavy determinant of how well it can parallelise the operation. It can 
>>>>make a big difference.
>>>
>>>Well I was talking about recovery, not backup. 
>>
>>The two go together. You arrange your database one way because "it makes 
>>no difference to the speed of recovery" and you've just crippled my 
>>ability to backup in parallel properly.

>
>
> Not my point. I just said bigger datafiles don't make recovery much
> slower. Not with the current hardware anyway. There may be other
> reasons to stick with small files (maybe i/o serialization or backup
> speed you mentioned) but recovery speed is not one of them.

Not with *your* current hardware, maybe. But in *general*, it *could* do, and it would be inappropriate to make a sweeping comment otherwise.

Also, when you made your initial comment, you didn't mention the fact that you were taking one factor out of dozens into account and completely ignoring the other factors. I think we should have been told, don't you?

>>>Anyway, even with backups, most sites

>
> ...
>

>>But on the grounds that most of the specific sites I have worked on 
>>backup and recovery strategies for actually backup to disk in the first 
>>instance, I am as qualified to say that you are wrong as you are to say 
>>the same of me.

>

> Rman to disk and to the tapes after that? Why not but with rather high
> disk space requirements could be better to buy some more disks and do
> split-mirror backups.

I really hate this sort of crap. You have *no idea* about my clients, so don't pontificate about them. Maybe they had sufficient hard disk space to do RMAN backups to them for a day or two, but not sufficient cash in the budget to go split mirror. You don't know, do you? So why make comments like this?

> I thought you would like to have the last word :)

Whatever. If this is just a game to you, please let us know, and I'll make sure I just killfile you, along with certain others.

You made a sweeping comment that is completely untrue *for me and my clients*. You made it without any proviso or caveat. You repeat it here.

What a waste of space.
HJR Received on Wed Nov 24 2004 - 20:50:25 CST