Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN question

Re: RMAN question

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Tue, 18 Sep 2007 10:22:59 -0700 (PDT)
Message-ID: <900029.88770.qm@web38905.mail.mud.yahoo.com>


Unless of course your recovery catalog is gone.... and then do you use a recovery catalog to backup the recovery catalog? If that recovery catalog goes, what do you do? Just joking of course...

We have had some irritating performance problems with the recovery catalog of late which makes me less of a fan of it right now. The recovery catalog is another complex piece that is just waiting to break when you need it...

My feelings are if you can justify a need for the RC (reporting, script storage, longer term retention) then great, use it. If you have a large environment, the RC probably makes sense.

If you have just a few databases, then there is little or no real need for it.

My opinion, YMMV of course (and of course, my standard disclaimer applies here - IT DEPENDS!!)

RF
--- Jared Still <jkstill_at_gmail.com> wrote:

> On 9/18/07, LS Cheng <exriscer_at_gmail.com> wrote:
> >
> > hmm well it's relative, I backup to tape rman
> backup logs and it always
> > shows the autobackup filename....
> >
> >
>
> I don't agree.
>
> In a recovery situation, the simpler and easier, the
> better.
>
> Using a recovery catalog makes many recovery
> scenarios simpler and easier.
>
> Everyone is free to dictate their own 'best
> practices' of course.
>
> I've been in recovery situations with CF only, and
> did not like it.
>
> Too many "this would be easy with a recovery
> catalog" situations.
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>

Robert G. Freeman
Author:
Now Available for Pre-Sales on Amazon.com!!!!



Oracle Database 11g New Features (Oracle Press)

Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 18 2007 - 12:22:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US