Re: Cannot open DB (because corrupt Rman datafile)

From: Howard J. Rogers <howardjr_at_www.com>
Date: Fri, 19 Oct 2001 06:08:27 +1000
Message-ID: <3bcf348f@news.iprimus.com.au>

Oracle is a rich person's toy, for sure. But the good news, Charles, is that in 9i the use of a catalog is no longer required, nor even recommended. So the licensing worries disappear completely.

The reason is simply that the only real justification for a catalog was that the RMAN scripting language made Java look like a walk in the park, so having once managed to pull of a script that actually worked, *storing* it was important -and you can only store scripts in a catalog.

In 9i, the command to take a complete backup is: backup database; -and even I can manage that! No nasty syntax, no need to store scripts, no need for the catalog.

So now you can have your Christmas bonus and your compressed parallelized backups, too.

Regards
HJR

--
Resources for OracleT: www.geocities.com/howardjr2000
=========================================


"Charles J. Fisher" <cfisher_at_rhadmin.org> wrote in message
news:Pine.LNX.4.33.0110181016190.1817-100000_at_galt.rhadmin.org...


> On Fri, 5 Oct 2001, Howard J. Rogers wrote:

>

> > On another point, is this database actually useful for anything other

than


> > RMAN?  I mean is it your real, live, production database?  If so, why on

> > Earth is the RMAN tablespace *within* the database it's supposed to be

> > backing up?  The RMAN catalog is supposed to be in a separate database

on a


> > separate machine.  Otherwise, it would be a case of too many eggs in one

> > vulnerable basket.

>

> This is the thing that I don't understand about RMAN - I assume that you

> have to buy another Oracle license to run it in the optimal manner. I'd

> rather do standard hot backups and pocket the difference as my Christmas

> bonus.

>

>     ----------------------------------------------------------------------

-----


>    / Charles J. Fisher                   | "Those who do not understand

UNIX /


>   /  cfisher_at_rhadmin.org                 |  are condemned to reinvent it,

/


>  /   http://rhadmin.org:81               |  poorly."   -- Henry Spencer

/


> --------------------------------------------------------------------------

-


>

Received on Thu Oct 18 2001 - 15:08:27 CDT