RE: RMAN catalog question
Date: Thu, 19 Jul 2012 18:49:41 +0000
So one thing that I just noticed while looking into this. The RMAN catalog schema(tables/procedures/etc) seems to get created based on the version of the target that executed the "create catalog" command, and not the version of the database that is hosting the catalog.
I checked this by comparing the schemas that were created by different versions of oracle. If it was dependent on the version of oracle that hosted the catalogs, they would all be the same. Ours differ by the version of oracle that was used when executing the "create catalog" command.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael Dinh Sent: Thursday, July 19, 2012 11:58 AM
To: Michael Schmitt
Subject: Re: RMAN catalog question
RMAN Compatibility Matrix [ID 73431.1] provides a little more details. RMAN executeable <= target database (when backup 9i database, use 9i RMAN) Catalog schema >= RMAN executeable Catalog database >=10.2.0.3 (note 1)
Based on the information, I would create the RMAN database and catalog using the latest and greatest release to ensure compatibilty.
On Thu, Jul 19, 2012 at 8:04 AM, Michael Schmitt <mschmitt_at_uchicago.edu>wrote:
> For our RMAN configuration, we run a single database to store
> individual catalogs for each of our databases. We create a new users
> in this central database and dedicate each user for the catalog of
> each database in our environment. That way we have a 1 to 1
> relationship between schemas(which store a catalog) and the databases we are backing up.
> Do we have to be concerned about what version of Oracle this central
> database that stores all the individual catalogs is running? Does it
> always have to be running the highest version of Oracle that we run in
> our environment?
> The matrix in the above link is not exactly clear to me. Does the
> version of the recovery catalog schema come from the RMAN client
> version used to execute the create catalog command, or the version of
> the database that is used to store the catalog?
> Does anyone have any guidance on this?
> Thanks in advance for your help.