Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN question
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!!!!
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 18 2007 - 12:22:59 CDT