Re: Cannot open DB (because corrupt Rman datafile)

Howard,

I thought the primary reason for keeping the catalog on a seperate database was to protect your backup data repository in the event of a total disk failure on the primary machine. At the company where I work, we currently keep the repository in our control file only because we don't want to spend the money on another oracle liscense. I am not wild about this solution because it does not address the scenerio I mentioned above where the datafiles and all controlfiles are lost. If Oracle no longer recomends having a seperate database for the backup repository, how do they address the scenerio where the entire machine including all controlfiles is wiped out?

John

Howard J. Rogers wrote:

> 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
> /
> > --------------------------------------------------------------------------
> -
> >

Posted via www.orafocus.com - Focusing on the World of Oracle Received on Thu Oct 18 2001 - 16:27:26 CDT