Re: RMAN v Control Files

From: Bill & Mary Border <bb22_at_adelphia.net>
Date: Mon, 17 Feb 2003 01:02:09 GMT
Message-ID: <lwW3a.9281$jR3.4947659@news1.news.adelphia.net>

If you're asking about the age-old question of whether or not to use an RMAN recovery catalog...

Pros to using RCVCAT:

The concept of database "incarnations" only works if you are using an RCVCAT. We found out (the hard) way that this is a big deal. That is, if you use the controlfile instead of an RCVCAT, you won't be able to use "incarnations". A BIG DEAL
Some of the reporting is better

Cons to using RCVCAT:

Increased support required (one or more additional instances to support).
If you have multiple DB's with the same DBID, each will require its own RCVCAT, which is not practical in our case.

Write to me if you need more info.

Bill

"Gary Mandaracas" <garym_at_singnet.com.sg> wrote in message news:b2ljd4$ub7$1_at_mawar.singnet.com.sg...
> Can anyone advise,
>
> We have installed HP's Data Protector to backup our Oracle databses and
> other systems in two of our sites and been given different advise by
> consultants working on each installation.
>
> For Data Protector you can configure the backup to integrate with RMAN or
> make use of Control files. In the first install we where advised to
> configure RMAN prior to the consultant coming in to install and set-up the
> backup software, however in a more recent install at another site the
> consultant advised us to make use of the Control files.
>
> Is he cutting corners to get the job done or does it really make no
> difference? What are the pros and cons of each approach?
>
> Any advice would be appreciated.
>
> Gary
>
>
Received on Sun Feb 16 2003 - 19:02:09 CST