Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: command line vs grid control

Re: command line vs grid control

From: DA Morgan <>
Date: Fri, 06 Jul 2007 13:28:21 -0700
Message-ID: <>

GD wrote:
> DA Morgan wrote:

>> GD wrote:
>>> DA Morgan wrote:
>>>> wrote:
>>>>  From my standpoint that is the case. Just as I would say that anyone
>>>> using shell/perl scripts to perform a backup should be trained or
>>>> terminated.
>>> What about those who don't use rman? Some people use storage features 
>>> (Business Copy, TimeFinder or whatever) to perform backup.
>>> Should they be terminated or trained?
>> First you try training. Then you terminate them: Yes.
>> You can use those tools to backup non-Oracle resources. But if they are
>> being used to backup an Oracle database then you are wasting time,
>> money, and putting your organization and its data at risk.

> You can use them to backup Oracle database (actually, many companies do
> that) and I don't agree that using them is a waste of time or risk for
> any organisation.

Then I will prove it to you.

  1. Organizational resources are money whether it is DBA time or CPU ticks or feet of DAT tape.
  2. Not using block change tracking wastes resources.
  3. No tool can do block change tracking except RMAN.
  4. Not using RMAN is a waste of money.
>>> If you use rman to backup your database, how do you invoke it and how 
>>> do you tell it when and what to do?

> Very useful resource, I agree.

People selling hardware.
Hardware costs money.
RMAN is free.
More money wasted.

>>> Don't you use some kind of shell for that purpose?
>> No need to but that isn't relevant to whether RMAN is or is not used.

> How do you invoke rman if you use it? Why wouldn't you use a shell
> script to do that?

Writing shell scripts requires an additional skill set. Shell scripts are difficult to maintain. Shell scripts are difficult to version control. Shell scripts are essentially never tested. Shell scripts can fail, for example, when additional resources are added or moved.
Shell scripts must be rewritten every time Oracle makes a change.

>> Take the tool of your choice and see whether you can:
>> Use block change tracking
>> Perform block media recovery
>> The answer in both cases is no.

> Probably true, but why would you terminate people who use
> perl/shell/whatever scripts to invoke whatever backup tool?

Because the are dinosaurs who refuse to keep their skill set current. If they can't/won't learn RMAN they can't/won't learn single row processing, AWR, ASH, and numerous other technology improvements and they cost the organization money and productivity and potentially put it and the other employees at risk.

To keep them would be irresponsible.

Daniel A. Morgan
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Fri Jul 06 2007 - 15:28:21 CDT

Original text of this message