Re: consolidation of multiple rows

From: Jerry Stuckle <>
Date: Wed, 12 Mar 2008 13:53:20 -0500
Message-ID: <>

DA Morgan wrote:
> Alex Kuznetsov wrote:
>> On Mar 12, 8:53 am, wrote:
>>> Aah - so your course covers backing up and restoring a system (I'm
>>> assuming it's the whole OS environment including all configuration
>>> settings, not just DB backup/restore ... otherwise you're not meeting
>>> the recovery requirement). Why does your course cover this non-DBA
>>> function but not DB installation? It's far more likely that a DBA
>>> would just need to set up a new database server than restore an entire
>>> backed up system :-/
>> Putting on my business hat, installing a new system is a planned
>> event. As such, it can be prepared for and done in a cost effective
>> way.
>> On the other hand, a disaster is not planned. If downtime means losing
>> money, then you want recovery ASAP, so you practice recovery
>> frequently and must be ready to actually do the recovery at any time.
>> This is why in some places DBAs are experts in recovery but not in
>> installation.
> Part of the reason why we make sure students can configure operating
> systems and perform installations is so that they will feel comfortable
> totally trashing a database installation as part of learning to perform
> recovery.

Oh, so now you're teaching them non-DBA functions also? Configuring the OS is not a DBA's job.

> If you don't feel that reinstalling from scratch is trivial you probably
> aren't going to feel comfortable opening your system01.dbf in vi and
> creating block corruption. And waiting around for single block
> corruption to happen on its own is not an award winning skill.

Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
Received on Wed Mar 12 2008 - 13:53:20 CDT

Original text of this message